How to Hide a Worksheet

Sometimes we want to share an Excel file (also known as a Workbook) with others, but we don’t want them to see a particular worksheet(s). To accomplish this task, we can “hide” the worksheet:

To Hide:

• Click in the worksheet that you want to hide
• From the Format menu, choose Sheet and then click Hide.

To Unhide:

• From the Format menu, choose Sheet and then click Unhide.
• A dialogue box will appear (example below)
• Double-click the name of the hidden sheet you want to display.

First Choice/Your Choice packs tips like these into their computer training programs throughout the Chicago area. For timely assistance with individual questions, the Help, I'm Stuck application support program is available nationwide.

Return to the main Tips & Tricks page