MS Excel
0 Guide

How to Unhide Columns in Excel

This is an Arcade

Missing columns in your Excel sheet? Follow these steps to unhide columns using the right-click menu or the Format option in the Home tab.

1. Open your Excel worksheet

Launch Excel and open the file where one or more columns are hidden from view.‍

2. Select the entire sheet

Click the triangle icon in the top-left corner between A and 1 to highlight all rows and columns.

3. Right-click a column letter

With the sheet selected, right-click on any visible column letter in the header row.‍

4. Choose Unhide from the menu

In the dropdown menu, click Unhide. All previously hidden columns will now be visible.

5. (Optional) Use the Format menu to unhide columns

You can also go to the Home tab, click Format in the Cells group, and select Unhide Columns under Hide & Unhide.

MS Excel
0 Guide

Ready to create quick,
interactive product demos?

Sign up
– it's free
{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Unhide Columns in Excel", "description": "Missing columns in your Excel sheet? Follow these steps to unhide columns using the right-click menu or the Format option in the Home tab.", "step": [ { "@type": "HowToStep", "name": "Open your Excel worksheet", "text": "Launch Excel and open the file where one or more columns are hidden from view." }, { "@type": "HowToStep", "name": "Select the entire sheet", "text": "Click the triangle icon in the top-left corner between A and 1 to highlight all rows and columns." }, { "@type": "HowToStep", "name": "Right-click a column letter", "text": "With the sheet selected, right-click on any visible column letter in the header row." }, { "@type": "HowToStep", "name": "Choose Unhide from the menu", "text": "In the dropdown menu, click Unhide. All previously hidden columns will now be visible." }, { "@type": "HowToStep", "name": "(Optional) Use the Format menu to unhide columns", "text": "You can also go to the Home tab, click Format in the Cells group, and select Unhide Columns under Hide & Unhide." } ] }