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.
- Reader Comments -
Following are comments in response to this item.
The most recent comment is at the bottom.
- By Jason. Comment posted 11 April, 2010 4:43pmIt worked on my computer! I use Excel 2007 and have Microsoft Windows XP Home Edition Version 2002 on my computer.
- By Bill. Comment posted 11 April, 2010 5:26pmWindows 7 & Excel 2007:
Ctrl + 0 works to hide
Ctrl + Shift + 0 does not unhide the hidden columns using above.
- By Bao Wenqi. Comment posted 11 April, 2010 5:30pmIt worked on my computer also! I use Excel 2007 and have Microsoft Windows XP Home Edition Version 2002 service package 3 on my computer.
- By John Walkenbach. Comment posted 11 April, 2010 5:55pmJust as I thought. I know it USED to work for me - but that was when I was using Windows XP.
- By Daniel Ferry. Comment posted 11 April, 2010 6:44pmJohn,
It's working fine for me as well on WinXP Pro and Excel 2007.
- By OmarF. Comment posted 11 April, 2010 7:16pmI tried it on a Vista system with 2007. Works fine.
- By Jon Peltier. Comment posted 11 April, 2010 7:57pmExcel 2003 and Windows 7 Ultimate: Ctrl-Shift-Zero is broken.
- By Jon Peltier. Comment posted 11 April, 2010 7:58pmP.S. I like the way you spelled "zero" with a zero.
- By sam. Comment posted 11 April, 2010 8:23pmVista and above - Crtl+Shift+0 - fails - irrespective of the excel version.
- By Robert. Comment posted 11 April, 2010 8:26pmWindows 7 and Microsoft Excel 2007:
neither Ctrl-0 nor Ctrl-Shift-0 work
Ctrl-8 and Ctrl-Shift-8 work
- By John Walkenbach. Comment posted 11 April, 2010 9:03pmSo #6 blows the Windows XP-only theory. It must be some other software that's interfering.
- By Rick Rothstein (MVP - Excel). Comment posted 11 April, 2010 9:47pmDoes this help any?
- By vlatte. Comment posted 11 April, 2010 11:14pmMy Ctr + Shift + 0 didn't work for Excel 2003 or 2007 with Vista until I followed Rick Rothstein's Microsoft support link and followed the instructions.
Boy was that setting buried, but now I can unhide columns using the short cut keys.
- By Joe. Comment posted 12 April, 2010 1:05amWorked on my computer - Using Excel 2007 and 2003 - Windows XP Pro
- By Marc. Comment posted 12 April, 2010 4:05amExcellent find, that's been annoying me for the last month since switching to a new laptop with both [new for me] office 2007 and windows 7. Thanks so much!
- By John Walkenbach. Comment posted 12 April, 2010 6:19amGood find, Rick. And yes, that setting is really buried.
- By Bill Royal. Comment posted 12 April, 2010 3:10pmBoth the Hide and unhide columns keyboard shortcuts work on my machine: Acer Travelmate 2423 WXCi laptop running XP Home SP3 and Office 2003 (11.5612.5606)
- By UKPhil. Comment posted 13 April, 2010 4:36amAll working for me
XP Professional SP3
- By Grba. Comment posted 13 April, 2010 5:04amShortcut Ctrl+Shift+0 works in Excel at my post:
- Windows 7 + Office 2010 Beta
- Windowx Vista + Office 2007
- Windows XP (virtual) + Office 2007
- Windows XP (virtual) + Office 2003
I checked that MSKB article, too. Well, I use system keyboard switcher a lot, but I fixed the three layouts to Alt+Shift+[8|9|0] a long time ago.
- By Damian. Comment posted 23 April, 2010 11:05pmThanks Rick. Google took me here and after following your link it works now.
- By Wendy!. Comment posted 11 May, 2010 12:38amWow. That was fun!
- By adrienneQ. Comment posted 15 June, 2010 2:35amWored on XP- profesional with Excel 2010
- By krishna. Comment posted 21 October, 2010 7:03amIt worked with xp operating system and excel 2003
- By Rahul. Comment posted 21 December, 2010 4:43amFor me also last one does not work well. But the above all works well.I am using windows 7 and Excel 2003.
- By Kris. Comment posted 23 March, 2011 1:44amHi Rick,
http://support.microsoft.com/kb/967893 worked for me! Thanks a ton.
- By Guilherme Poleto. Comment posted 10 April, 2011 6:40pmIt works for me! Windows 7 + Office 2010
- By mariel_ar. Comment posted 15 April, 2011 7:57amXP SP3 - Excel 2007 v.12.0.6545.5000
All work fine.
- By fonthiller. Comment posted 01 November, 2011 10:46amThis cured it (running Win7 & Excel 2010):
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.