• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Creating a Worksheet with Exc... > Hiding and Unhiding Worksheets and W...

Hiding and Unhiding Worksheets and Workbooks

Not all worksheets and workbooks should be available to everyone. You can hide sensitive information without deleting it by hiding selected worksheets or workbooks. For example, if you want to share a workbook with others, but it includes confidential employee salaries, you can simply hide a worksheet. Hiding worksheets does not affect calculations in the other worksheets; all data in hidden worksheets is still referenced by formulas as necessary. Hidden worksheets do not appear in a printout either. When you need the data, you can unhide the sensitive information.

Hide or Unhide a Worksheet

  • Hide. Click the sheet tab you want to hide, click the Format menu, point to Sheet, and then click Hide.

  • Unhide. Click the Format menu, point to Sheet, click Unhide, select the worksheet you want to unhide, and then click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint