How do I unhide all columns in Excel?

How do I unhide all columns in Excel?

Press Ctrl + Shift + 9 to unhide all rows or Ctrl + Shift + 0 (zero) to unhide all columns. If this doesn't work, then right-click on a row or column identifier and select Unhide. Note that you need to select the identifier—you can't just click anywhere and select Unhide using this particular method.

Why won’t my columns unhide in Excel?

If you have an Excel table where multiple columns are hidden and want to show only some of them, follow the steps below. Select the columns to the left and right of the column you want to unhide. Go to the Home tab > Cells group, and click Format > Hide & Unhide > Unhide columns.

How do I get my columns back in Excel?

Click the "Select All" button, which is the button in the top left corner of the spreadsheet. You can also click "Ctrl-A" to select the entire spreadsheet. Click "Format" in the Cells group of the Home tab. Select "Visibility," and then select "Hide & Unhide" and "Unhide Columns" to make all missing columns visible.