Hiding & Unhiding With Shortcut Keys
According to the Excel Help system, you can use these key combinations to hide and unhide rows and columns within a selection:
- Hide rows: Ctrl+9
- Unhide rows: Ctrl+Shift+9
- Hide columns: Ctrl+0 (that's a zero)
- Unhide columns: Ctrl+Shift+0 (also a zer0)
They all work for me except the last one. It fails for Excel 2003, Excel 2007, and Excel 2010 (running Vista).
A bit of Googling tells me that others have the same problem. One theory is that the OS is intercepting that key combination before it gets to Excel.
Does Ctrl+Shift+0 work for you? If so, which OS and Excel version do you use? Note that to unhide columns, you must select a range of cells that includes columns to the left and to the right of the hidden columns.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.