badonthego.blogg.se - Excel 2016 quick access toolbar make smaller

This technique can be performed in any Excel workbook. Right up front, this does not require the use of macro-enabled workbooks.

The moment you add a Data Table to ANY sheet, the Custom Views feature becomes inoperable.īecause more and more people use Data Tables in their workbooks (and why wouldn’t you? They’re AMAZING!!!), we need to explore another way of unhiding all hidden worksheets. Custom views do not work with Data Tables. When it comes time to redisplay all the sheets, we repeat the process and select our “normal” view and click “ Show”.

If we create a custom view prior to hiding ANY of the sheets ( View (tab) -> Workbook Views (group) -> Custom Views -> Add…), we can hide as many sheets as we like.

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.