Quick answer: To unhide columns in Excel, select the columns on both sides of the hidden one, right-click, and choose Unhide. If that fails, use Home → Format → Hide & Unhide → Unhide Columns.

Knowing how to unhide columns in Excel saves time when data seems to vanish from your sheet. The good news is that your data is not gone. This guide covers every working method, plus fixes for the most common problems.

What Does “Unhide Columns” Mean in Excel?

Unhiding columns means making hidden columns visible again in your worksheet. The data was never deleted. Excel just stopped showing it.

People hide columns on purpose to simplify a view, protect data, or focus attention on key numbers. Sometimes columns get hidden by accident, and you only notice later.

You can spot hidden columns in two ways. First, look for gaps in the column letters. If you see A, C, D, then column B is hidden. Second, look for a double line between two column headers. That line means one or more columns sit between them.

Why Are Columns Hidden in Excel?

Columns are usually hidden by choice, by accident, or because the sheet came from someone else. Knowing the cause helps you pick the right fix.

Common reasons include:

• Someone hid helper or backup data to make the sheet look cleaner.
• A shortcut or drag action hid a column by mistake.
• The column width was dragged down to zero.
• A shared file arrived with hidden sections you did not create.

People often search for this after opening a file and noticing missing letters. Others need old data back, or want to know why Column A will not reappear.

Quick Answer: What Is the Fastest Way to Unhide Columns?

The fastest way is the right-click method. Select the columns on the left and right of the hidden ones, right-click the selection, and click Unhide.

If you want to hide and unhide with the keyboard, the ribbon sequence Alt+H+O+U+L works well on Windows. We cover it below.

Here is a quick comparison of all the methods:

Method	Best for	Steps	Platform
Right-click Unhide	Quick fixes	Select adjacent columns → Right-click → Unhide	Windows, Mac
Ribbon	When right-click fails	Home → Format → Hide & Unhide → Unhide Columns	Windows, Mac
Alt+H+O+U+L	Power users	Press keys in order	Windows
Name Box (A1)	Hidden Column A	Type A1 → Enter → Format → Unhide Columns	Windows, Mac
Select All	Whole sheet	Ctrl+A twice → Right-click → Unhide	Windows, Mac
Tap and hold	Phones and tablets	Tap column → Hold → Extend → Unhide	iOS, Android

Right-Click Method (Most Common)

Select the columns on each side of the hidden column, then right-click and choose Unhide. You cannot click a hidden column directly, so you must select its neighbors.

Say column C is hidden. Here is what to do:

1. Click the header of column B.
2. Hold Shift and click the header of column D.
3. Right-click on either selected header.
4. Choose Unhide.

Column C will appear right away. This works the same way on Excel for Windows and Mac.

Ribbon Method (Home → Format)

Use the Home tab if the right-click menu does not work. Select the neighboring columns first, just as before.

1. Select the columns on both sides of the hidden one.
2. Go to the Home tab.
3. Click Format in the Cells group.
4. Choose Hide & Unhide, then Unhide Columns.

This method is also handy when you work with several hidden sections at once.

Keyboard Shortcut for Unhiding Columns (Alt+H+O+U+L)

The most reliable shortcut on Windows is Alt+H+O+U+L. Press the keys one after another, not all at once.

First, select the columns around the hidden one. Then press Alt, H, O, U, and L in order. Each key opens the next part of the ribbon menu, ending at Unhide Columns.

You may have seen Ctrl+Shift+0 recommended in older guides. It often does not work today. See the troubleshooting section below for why.

How to Unhide All Columns at Once

Select the whole worksheet, then right-click any column header and choose Unhide. This is the best option when you do not know where the hidden columns are.

To select everything, press Ctrl+A twice, or click the small triangle at the top-left corner of the grid. Then right-click a column header and click Unhide.

This also helps when a big dataset has many hidden sections. You can reveal them all in one move instead of fixing each gap by hand.

How to Unhide Column A (the First Column)

Use the Name Box trick to unhide Column A. Column A has no neighbor on its left, so the normal method fails.

1. Click the Name Box (to the left of the formula bar).
2. Type A1 and press Enter.
3. Go to Home → Format → Hide & Unhide → Unhide Columns.

Typing A1 selects the cell even though the column is hidden. That lets the Unhide command work.

How to Unhide Columns in Excel on Mac

On Mac, use the right-click menu or the Home → Format → Hide & Unhide path. Both work the same way as on Windows.

Select the columns on both sides of the hidden one. Then Control-click or right-click and choose Unhide. You can also use the ribbon.

Shortcut support on Mac is inconsistent. The research shows Ctrl+Shift+0 does not work reliably there, so stick with the menu methods.

How to Unhide Columns on Excel Mobile (iOS and Android)

On a phone or tablet, tap and hold the column header next to the hidden section. Excel mobile apps support unhiding through context menus.

1. Tap the header of a column next to the hidden one.
2. Hold, then extend the selection to include the other side.
3. Tap Unhide from the menu.

There is no right-click on mobile, so the tap-and-hold gesture is the key step. The layout differs a little from desktop, but the idea is the same.

Why Is the Unhide Option Greyed Out?

The sheet is most likely protected. Sheet protection blocks formatting changes, including unhiding, unless the owner allowed it.

Go to Review → Unprotect Sheet. Enter the password if there is one. Then try unhiding again. If someone else protected the file, ask them for access first. Do not try to get around a password you were not given.

Why Doesn’t Ctrl+Shift+0 Work?

Microsoft disabled Ctrl+Shift+0 on many Windows installations. It conflicts with the Windows shortcut for switching keyboard layouts.

This has been reported since around 2016, and it is still true in 2026. Recent guides now recommend the ribbon or right-click menu instead. If you want a keyboard option, use Alt+H+O+U+L.

If your team relies on shortcuts, teach them this one. It works on any Windows setup where the ribbon is available.

Hidden vs. Zero-Width Columns: What’s the Difference?

A hidden column is turned off, while a zero-width column is just squeezed to nothing. They look the same but need different fixes.

If a column still seems missing after you use Unhide, its width may be set to zero. Drag the border between the headers to pull it open. You can also set the width to a number above zero.

Problem	Likely cause	Fix
Unhide greyed out	Sheet protected	Review → Unprotect Sheet
Ctrl+Shift+0 fails	OS hotkey conflict	Use Alt+H+O+U+L or right-click
Column A won’t unhide	No left neighbor	Use the Name Box trick
Column still invisible	Width is zero	Drag the border or set a width
No Unhide on Mac	Shortcut blocked	Use right-click or ribbon

What Does the Double Line Between Columns Mean?

A double line between two column headers means one or more columns are hidden there. It is the quickest visual sign.

You can often double-click that line to reveal the hidden column. This works in many cases, though not all. If it does not, fall back on the right-click method.

Advanced Tips for Unhiding Columns

A few small tricks make unhiding faster and safer.

• Use the Name Box to jump to hidden first columns or rows.
• Select the entire sheet if you are unsure where columns are hidden.
• Check sheet protection first when Unhide is greyed out.
• Remember that you cannot select a hidden column directly.

To prevent accidental hiding, protect the sheet and lock column widths. Protection settings can allow or block the “Format columns” action, so set them with care. For shared files on OneDrive or SharePoint, tell your team which columns are meant to stay visible.

Advanced users can also use a short VBA macro to unhide every column automatically. This is useful for large files with many hidden sections.

Common Mistakes to Avoid

Most failed attempts come from a few simple errors.

• Trying to click the hidden column itself.
• Assuming Ctrl+Shift+0 will always work.
• Forgetting to unprotect the sheet first.
• Missing that Column A needs the Name Box trick.
• Mixing up hidden columns and zero-width columns.
• Skipping tap-and-hold on mobile.

FAQs

How do I unhide multiple columns at once?
Select the whole worksheet with Ctrl+A twice. Right-click any column header and choose Unhide. All hidden columns will return together.

Can I unhide columns without a password?
Not if the sheet is protected and Unhide is greyed out. You need to unprotect the sheet first, which may require the password. Ask the file owner if you do not have it.

What if I don’t know which columns are hidden?
Look for gaps in the column letters or double lines between headers. Or skip the search and select the entire sheet, then unhide everything.

Is there a way to unhide columns using VBA?
Yes. A short VBA macro can unhide all columns automatically. It is a good choice for advanced users and large files.

What is the shortcut to unhide columns in Excel?
Use Alt+H+O+U+L on Windows. Ctrl+Shift+0 is often disabled because of a conflict with keyboard layout switching.

How do I unhide the first column in Excel?
Type A1 in the Name Box, press Enter, then go to Home → Format → Hide & Unhide → Unhide Columns.

Why can’t I unhide columns in Excel?
The most common cause is a protected sheet. Other causes are a zero-width column or a blocked shortcut