Thursday, September 30, 2010
Hide and Seek
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!