How to Hide Worksheets in Excel 2007

1. Select the worksheets you want to hide. Click the worksheet tab, such as Sheet1 or Sheet2 to select one sheet. To select at two or more adjacent sheets, click the first tab then hold the 'Shift' key and click the last tab. To select more than one nonadjacent sheets, click the first tab then hold the 'Control' key and click the other tabs you want to hide. To select all sheets, right-click any sheet tab then choose 'Select All Sheets' on the shortcut menu.
2. Click 'Format' in the Cells group located on the Home tab above the worksheets.
3. Select 'Hide and Unhide' under Visibility and click 'Hide Sheet.'