Hiding and Unhiding Worksheets and Workbooks

graphics/microsoft19.gif

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.

graphics/04inf08.jpg

Hide or Unhide a Workbook

  • Hide . Open the workbook you want to hide, click the Window menu, and then click Hide.

  • Unhide . Click the Window menu, click Unhide, select the workbook you want to unhide, and then click OK.

    graphics/04inf09.jpg

    graphics/04inf10.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net