How To Unhide Columns In Excel?

Select the columns around the hidden area (e.g., select a column to the left and the column to the right of where columns are missing).

Go to the Home tab.

In the Cells group, click Format.

Click Hide & Unhide.

Click Unhide Columns.

If columns are hidden due to a filter: go to the Data tab, click Clear (or remove the filter) to show all rows, then recheck for hidden columns.

If columns are hidden via column width: select the full sheet by clicking the Select All button (top-left corner), then go to Home > Format > Column Width, enter a width, and click OK.

Suggested for You

Trending Today