1. Computing

Hide a Worksheet in Excel

By

Hide a Worksheet in Excel in Excel 2007 or Excel 2010
Hide a Worksheet in Excel

Hide a Worksheet in Excel

© Ted French

Related Article: Unhide A Worksheet in Excel

As with all things Microsoft, there is more than one way to hide a worksheet in an Excel worksheet.

These instructions cover how to hide a worksheet using the Format button on the ribbon in Excel 2007 and Excel 2010.

When you hide a worksheet, data in that worksheet can still be used and referenced in formulas and functions in other worksheets.

Example: Hide a Single Worksheet in Excel

Note: For help with this example, see the image above.

  1. Click on the tab of the worksheet you wish to hide to make it the current worksheet (the worksheet visible on screen).

  2. Click on the Home tab.

  3. Click on the Format icon on the ribbon to open the Format drop down menu.

  4. Under the Visibility section of the drop down menu, choose the Hide / Unhide option to open the sub menu.

  5. Under the Hide / Unhide sub menu, click on the Hide Sheet option to hide the current worksheet.

  6. The worksheet should disappear from view.

Example: Hide Multiple Worksheets in Excel

  1. Click on the tab of the first worksheet you wish to hide with the mouse pointer.

  2. Press and hold down the CTL key on the keyboard.

  3. Click on the tab of a second worksheet you wish to hide with the mouse pointer.

  4. The tabs of both worksheets should be highlighted.

  5. Follow steps 2 to 6 above to hide the worksheets.

©2014 About.com. All rights reserved.