Topics

Mar 31, 2011

Hide worksheet in Excel 2007

When you hide a worksheet, the data in the worksheet becomes invisible to others. You can hide a single worksheet or multiple worksheets at the same time. To hide multiple worksheets at the same time, you have to select the sheets first. Please be informed that you cannot hide all the worksheets. You must have at least one worksheet visible or unhidden. For information regarding selecting multiple worksheets, click the following web link:
Select or group multiple worksheets in Excel 2007

Once the selection of the worksheets is over, perform the following to hide the worksheet(s):
On the Home tab, in the Cells group, click Format, point to Hide & Unhide and click Hide Sheet.

0 comments:

Post a Comment