Ctrl+Shift+0: Unhides Columns

The shortcut Ctrl+Shift+0 is to unhide the selected columns. When working with Excel, it is common to hide some columns either for security reason or for the convenience. You can hide the columns with the shortcut "Ctrl+0", and you can unhide them with the shortcut Ctrl+Shift+0.

Step 1: Select the columns before and after the hidden columns;

Step 2: Press the "Ctrl" key and the "Shift" key from the keyboard, then click the number "0". The hidden columns will become available.

Please note that many users may find the shortcut of unhiding columns "Ctrl+Shift+0" does not work, the reason is that the system has assigned the "Ctrl+Shift" keys for Regional/Language settings. Please check details "why the unhide column shortcut key doesn't work".

Alternatively, you can always use the right-click to unhide columns.

Step 1: Select the columns in front and after the hidden columns;

Step 2: Right-click and select and click "Unhide" from the drop-down list.

Leave a Reply