How to Unhide Multiple Columns

– How to Unhide a Column

To unhide the hidden columns, please refer to Ctrl+Shit+0 if you like using shortcut or follow the steps below:

Step 1: Select columns or the whole worksheet by clicking the top left corner;

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 or select whole worksheet;

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 columns will appear.