Unhide Columns | Keyboard Shortcut | Microsoft Excel

HomeExcel Keyboard ShortcutsUnhide Columns | Keyboard Shortcut | Microsoft Excel

In Excel, sometimes users hide some columns while working with data and miss to unhide the columns before sharing the file or hide the columns that they assume are not relevant to the receiver and share the file with hidden columns and the receiver gets the file with hidden columns.

But many times, you want to review the unhide columns and for this, you no need to worry as Excel has multiple ways to unhide the columns manually or using keyboard shortcuts.

In this tutorial, we have explained shortcut keys to unhide the columns.

Keyboard Shortcut to Unhide Columns in the Excel

There are multiple keyboard shortcuts to unhide the columns but some shortcuts to unhide columns do not work for everyone and one has to change the Excel setting to make them work, but here we have captured only shortcuts that will work for everyone.

unhide-column-using-keyboard-shortcut

Alt → O → C → U

keyboard-shortcut-to-unhide-columns

Alt → H → O → U → L

Steps to Unhide Columns Using Keyboard Shortcuts

  • First, Press “Ctrl + A + A” to select the entire sheet to unhide all the hidden columns from the whole sheet.
  • Or select only the specific columns range using “Ctrl + Spacebar” and “Shift + “<” or “>” arrow keys if you want to unhide columns only from that specific range of columns and not from the entire sheet.
  • Once the entire sheet or specific columns range gets selected, just press “Alt → O → C → U” or “Alt → H → O → U → L” shortcut keys, and hidden columns will get visible.

➜ Excel Shortcuts Cheat Sheet (PDF)