Shortcut to hide and unhide columns in Excel

To hide a column in Excel using just your keyboard, select one of the cells in the column and press Ctrl + 0 (Zero).

To unhide a previously hidden column, select the 2 columns adjacent to the one that’s hidden and press Ctrl + Shift + 0 (Zero).

The shortcut for unhide  may not work for you if you are using Windows Vista or Windows 7.  You will need to change the windows settings to make it work as specified below

Remove the shortcut assignment to make the application work as expected. To do this, follow these steps:

  1. Click Start, and then click Control Panel.
  2. Double-click Regional and Language Options.
  3. Click Keyboards and Languages, and then click Change keyboards.
  4. Click Advanced Key Settings, and select Between input languages.
  5. Click change Key Sequence.
  6. For Switch Keyboard Layout, select Not Assigned.
  7. Click OK to close each dialog box.

Leave a Reply

Your email address will not be published. Required fields are marked *