Site icon ExcelNotes

How to Unhide a Column

– How to Unhide Multiple Columns

To unhide a column that was hidden, please refer to Ctrl+Shit+0 if you like using shortcut to unhide a column or follow the steps below for commands:

Step 1: Select columns between the hidden column;

Step 2: Right-click and select "Unhide" from the dialog box;

Step 3: The hidden column will show up.

Alternatively, please use the commands in the ribbon.

Step 1: Select the hidden columns between the column;

Step 2: Click the "Home" tab from the ribbon;

Step 3: Click "Format" in the Cells section, and select "Unhide Columns" from the "Hide & Unhide" command;

Step 4: The hidden column will appear.

Exit mobile version