poydad.blogg.se

#EXCEL 2016 QUICK ACCESS TOOLBAR GONE WINDOWS#

The screen will immediately return to the desired state.Ĭustom views also work with the visible/hidden states of worksheets. If you change the hidden/visible state of rows and/or columns but then wish to return to the saved configuration, repeat the process ( View (tab) -> Workbook Views (group) -> Custom Views), select your saved view then click “ Show”.

Click View ( tab) -> Workbook Views ( group) -> Custom Views -> Add… and give the current configuration a name.

This is convenient when you wish to show details of data for one printout, but a summarized version of the data in a different printout. Never fear, a solution is here ( actually, three solutions)Īn often-overlooked feature in Excel is the ability to save a custom view.Ĭustom views can be used to “save” the hidden or visible states of rows and columns. This means you will have to perform the unhide operation eleven times to restore all the hidden sheets to a visible state.

If you right-click a sheet tab and select “ Unhide”, the proceeding dialog box only allows a single sheet to be selected for the unhide operation. Unfortunately, unhiding multiple sheets in a single step is not as easy.

One of the easiest methods is to select a sheet ( or select multiple sheets using standard Windows CTRL and Shift selection techniques), right-click the sheet tab then select “ Hide”.Īs an example suppose you have twelve sheets labeled “January” through “December” and you want to hide all the monthly sheets except “December”. This is an exceptionally useful feature as it allows us to store data in a sheet, such as lists and tables, but keep the user of the workbook from seeing, manipulating, and more importantly, corrupting the information on the hidden sheet.Īs with most things in Excel, there is more than one way to hide a sheet or multiple sheets. One of the first “tricks” an Excel user learns is to hide and unhide a sheet.

#EXCEL 2016 QUICK ACCESS TOOLBAR GONE WINDOWS#