Show Me Microsoft Office Excel 2003

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.

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.

Категории