Excel tip: Hide and unhide multiple sheets
AccountingWEB.com Excel expert David Ringstrom continues his educational campaign with some simple viewing and formatting advice.
It’s easy enough to hide worksheets in Excel, but much less convenient to try and unhide several sheets in a particular workbook. Users who don’t know better end up having to unhide the worksheets one at a time.
This tutorial shows how to hide and unhide multiple worksheets at once.
There are a couple of different ways to hide worksheets in Excel. To hide a single worksheet follow these steps:
- Excel 2007 and later: As shown below, choose Format, Hide and Unhide on the Home tab, and then Hide Sheet. Or, to save a couple of steps, right-click on the worksheet tab and then choose Hide.
- Excel 2003 and earlier: Choose Format-Sheet-Hide.
- Excel 2011 (Mac): Ctrl-left-click on a worksheet tab and choose Hide from the shortcut menu.
Register for free and log into AccountingWEB.co.uk to read how to apply these operations to multiple sheets.
"Either you work Excel, or it works you!" says David Ringstrom CPA, the head of Atlanta-based software and database consultancy Accounting Advisors. He presents Excel training webcasts for CPE Link and contributes articles on Excel to AccountingWEB and Microsoft Professional Accountant's Network newsletter. He can be reached by email at david[AT]acctadv.com.