Need a quick way to hide and unhide columns in a worksheet? The shortcuts described in this tip can help fill the bill. (This tip works with MS Excel 2007.)
In older versions of Excel, Ctrl+0 would hide selected columns and Ctrl+Shift+0 to unhide those columns. When upgrading to Excel 2007, however, only Ctrl+0 works, not Ctrl+Shift+0. Some people wonder 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 key press.
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.
Posts
Actually, there is a weird Vista setting that makes the shortcut not work appropriately. You can resolve the issue by going to:
ReplyDeletehttp://support.microsoft.com/kb/967893