Page 272 - Excel 2013 All-in-One For Dummies

254 Reorganizing the Workbook
“Now you see them; now you don’t”
Another technique that comes in handy when working with multiple work- sheets is hiding particular worksheets in the workbook. Just as you can hide particular columns, rows, and cell ranges in a worksheet, you can also hide particular worksheets in the workbook. For example, you may want to hide a worksheet that contains sensitive (for-your-eyes-only) material, such as the one with all the employee salaries in the company or the one that contains all the macros used in the workbook.
As with hiding columns and rows, hiding worksheets enables you to print the contents of the workbook without the data in worksheets that you con- sider either unnecessary in the report or too classified for widespread distri- bution but which, nonetheless, are required in the workbook. Then after the report is printed, you can redisplay the worksheets by unhiding them.
To hide a worksheet, make it active by selecting its sheet tab, then click the Format command button on the Home tab of the Ribbon and choose Hide & Unhide➪Hide Sheet from its drop-down menu (or press Alt+HOUS). Excel removes this sheet’s tab from the row of sheet tabs, making it impossible for anyone to select and display the worksheet in the document window.
To redisplay any of the sheets you’ve hidden, click the Format command button on the Home tab and choose Hide & Unhide➪Unhide Sheet from its drop-down menu (or press Alt+HOUH) to display the Unhide dialog box.
In the Unhide Sheet list box, click the name of the sheet that you want to display once again in the workbook. As soon as you click OK, Excel redis- plays the sheet tab of the previously hidden worksheet — as simple as that! Unfortunately, although you can hide multiple worksheets in one hide opera- tion, you can select only one sheet at a time to redisplay with the Unhide command.
Opening windows on different sheets
The biggest problem with keeping your spreadsheet data on different work- sheets rather than keeping it all together on the same sheet is being able
to compare the information on the different sheets. When you use a single worksheet, you can split the workbook window into horizontal or vertical panes and then scroll different sections of the sheet into view. The only way to do this when the spreadsheet data are located on different worksheets is to open a second window on a second worksheet and then arrange the win- dows with the different worksheets so that data from both desired regions are displayed on the screen. The easiest way to do this is to use Excel’s View Side by Side command to tile the windows one above the other and auto- matically synchronize the scrolling between them.