Thursday, September 30, 2010

Hide and Seek

Keeping Things Simple” is almost always a good thing. Hiding a worksheet is one way of keeping your workbook tidy, and also can serve to protect sensitive data from prying eyes. As with all things Microsoft, there is more than one way to hide and unhide a worksheet in an Excel, but we are going to look at the most straightforward method of doing this in Excel 2007 and 2010.

To hide a single worksheet in Excel, open the worksheet and then simply Right-Click the tab and choose Hide. To Unhide it, simply right-click any tab and choose the worksheet to Unhide from the dropdown list.

To hide multiple worksheets, just select the first worksheet to hide with your mouse, hold down on the Ctrl button on your keyboard, choose the tabs of other worksheets to hide, and then right-click and Hide.

Please note that if you want to Hide a worksheet so no one else can Unhide it, simply Protect your workbook with a password by going to Review ribbon on the toolbar ribbon and choose Protect Sheet in the Changes grouping.

Easy and effective; always a good combination. Give it a try, and keep things simple and private. Happy Exceling!

No comments: