Best daily deals

Affiliate links on Android Authority may earn us a commission. Learn more.

How to unhide columns in Excel

Did your column disappear? Here's how to find it.
February 10, 2023

Hiding and unhiding columns in your spreadsheet is a convenient way to show only the data you need to focus on. Now and then, you may accidentally hide a column and wonder where it went. Here’s how to unhide columns in Excel.

Read more: How to add, hide, or remove columns or rows in Google Sheets


To unhide a column in Excel, select the columns adjacent to the one(s) hidden, then right-click and select Unhide from the drop-down menu.

How to unhide columns in Excel

You will see a grey double-line between the two adjacent columns to indicate that a column is hidden in your spreadsheet. Double-click on that to reveal the hidden column.

excel hidden column
Adam Birney / Android Authority

Alternatively, you can select both adjacent columns by clicking and holding over them or pressing Ctrl on the keyboard to select them. Then, right-click the selected columns and choose Unhide.

unhide column excel
Adam Birney / Android Authority

You should now be able to see all of your columns. To hide columns, follow the same steps but select Hide instead.

Read more: How to separate text into columns on Google Docs


If your columns are not unhiding, double-check that View–> Freeze panes aren’t enabled.

If your rows are not unhiding, double-check that View–> Freeze panes aren’t enabled.

If you’re familiar with VBA and macros, you can insert the following basic macro to unhide your columns. This can save a little bit of time instead of using the menu.

Sub UnhideAllColumns ()

Cells.EntireColumn.Hidden = False


Click the triangle symbol in the top left corner between your column and rows in Excel to select your entire sheet. Then, right-click and choose Unhide.