Tweet
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.
کامنت