Friday, July 15, 2011

How to Hide an Excel Worksheet so Another User Can't Unhide It


1. Open the Excel worksheet.
2. Click the sheet tab you wish to hide. If the tab is not visible at the bottom of the screen, click the tab scrolling button until the tab comes into view, then click the tab.
3. Click the 'Home' tab on the command ribbon.
4. Click the down-arrow for the 'Format' button in the 'Cells' group. A list of options appears.
5. Click the 'Hide Unhide' option in the 'Visibility' section.
6. Click the 'Hide Sheet' option. The worksheet hides from view.
7. Customize the command ribbon so the 'Cells' group and its 'Format' button also hides from view by clicking the Excel 'File' tab and the 'Options' link. Click the 'Customize Ribbon' button. Click the 'Main Tabs' option in the 'Customize the Ribbon' text box on the right.
8. Click the 'Cells' group under the 'Home' tab section. Click the 'Remove' button between the left and right panes. Click 'OK.' The 'Cells' group and the 'Format' button that contains the 'Unhide Sheet' option disappears from the command ribbon.

Blogger news