by Allen Wyatt
(last updated May 23, 2018)
Tom notes that in older versions of Excel he would use Ctrl+0 would hide selected columns and Ctrl+Shift+0 to unhide those columns. When he upgraded to Excel 2007, however, only the Ctrl+0 worked for him, not Ctrl+Shift+0. Tom wonders if Microsoft changed one shortcut but not the other.
There was no change in the shortcuts; they both still work just fine in Excel 2007. If the second shortcut (Ctrl+Shift+0) doesn't work on your system, it could be because there is some add-in being loaded that stops the shortcut from working properly or, perhaps, because a custom shortcut key has been defined that uses the same keypress.
Another thing to keep in mind is that the only way that Ctrl+Shift+0 works is if you have at least one hidden column selected before you use it. For example, if you hide columns D and E, you can later unhide them by selecting columns C through F (which obviously includes the hidden columns) and then pressing the shortcut.
Finally, you should be aware that both of these shortcuts only work if you use the 0 key on the main keyboard. They won't work if you use the 0 key on the numeric keypad.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (7757) applies to Microsoft Excel 2007.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
One way you can widen the columns in a worksheet to fit whatever is in the column is by double-clicking the right edge of ...Discover More
Need to hide a given column based on the value in a particular cell? The easiest way to accomplish the task is to use a ...Discover More
It is easy to adjust the width of columns in Excel. It is much harder to adjust the width of a range of columns ...Discover More
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.