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.
0 kommentar(er)
