How to Unhide All Columns in Excel: The 2026 Guide

TL;DR: The fastest universal way to unhide all columns in Excel is to select the entire sheet, then right-click any column header and choose Unhide. In modern Excel, that applies across 16,384 columns and typically takes less than two seconds on standard hardware, and it works on Windows, Mac, and Excel Online.

You open a spreadsheet from a teammate, and the column letters jump from C to H. Then from K to P. Formulas still calculate, but half the sheet looks broken.

That usually means the file isn’t broken at all. Someone hid columns on purpose, collapsed a group, applied a filter, or protected the sheet and forgot to mention it.

If you work in Excel often, this is one of those small problems that can waste a surprising amount of time. It gets worse in shared workbooks, exported reports, and old templates that nobody wants to rebuild. If that sounds familiar, it’s also a sign you may need to replace spreadsheets for parts of the workflow that keep breaking under handoffs and versioning.

For now, the fix is usually quick. The methods below cover the simple sheet-wide unhide, the keyboard-first route, and the stubborn cases that make people think Excel is glitching. If you work across spreadsheet tools regularly, this broader category view is also useful: https://toolradar.com/categories/spreadsheets

Why Are My Excel Columns Hidden Anyway

Most hidden columns fall into one of a few buckets. Somebody hid them manually to simplify the view. A template shipped with helper columns tucked away. Or a report was built for presentation, not editing, so calculation columns were hidden before sharing.

In practice, the confusion comes from the fact that several different Excel features can make columns seem to disappear. A standard hidden column behaves differently from a grouped column. A filtered dataset behaves differently again. A protected sheet can block all of your usual fixes.

What hidden columns usually signal

• Manual cleanup: Someone wanted the sheet to look cleaner and hid intermediate calculations.
• Template logic: Budget files, reporting models, and exports often hide lookup or staging columns.
• Outline grouping: Financial models commonly collapse sections so you only see headline figures.
• Protection: The sheet owner locked the layout, so Excel won't let you reveal anything.

Hidden columns aren't usually a data loss problem. They're a visibility problem.

The fastest way to diagnose it is simple. If standard unhide works, you're dealing with ordinary hidden columns. If it doesn't, look for filter arrows, outline controls, zero-width columns, or protection. That tells you where to go next.

The Universal Method to Unhide All Columns Fast

This is the method I use first because it works almost every time. Select the entire worksheet, then tell Excel to unhide any hidden columns inside that selection.

According to DataCamp’s guide on unhiding columns in Excel, selecting the full sheet and using Unhide works across 16,384 columns in modern Excel, is a long-standing built-in feature, and typically takes less than two seconds on standard hardware. DataCamp also notes that this reduces workflow interruptions by an estimated 75% compared with hunting through hidden columns one by one, and frames the task in the context of the 81% of business professionals who use Excel for data analysis (DataCamp).

Windows and Excel for the web

Use either of these:

1. Press Ctrl + A. If your cursor is inside a data table, press it again so Excel selects the entire sheet.
2. Or click the small triangle at the top-left corner, where row numbers and column letters meet.
3. Right-click any column letter.
4. Click Unhide.

If you prefer the ribbon:

• Go to Home
• Click Format
• Choose Hide & Unhide
• Click Unhide Columns

That ribbon path is useful when right-click is awkward, especially in dense sheets or browser-based sessions.

Mac

On Mac, the same idea applies:

• Press Command + A until the full sheet is selected
• Or click the top-left triangle
• Right-click a column header
• Choose Unhide Columns

If right-click behavior is inconsistent because of trackpad settings, the ribbon path is often smoother.

Why this works better than selecting around a gap

A lot of people try to select the visible columns on either side of each hidden section. That works for one hidden block. It gets annoying fast when there are multiple non-adjacent hidden areas.

Selecting the entire sheet removes the guesswork. You don't need to know where the hidden columns are. Excel checks the whole worksheet at once.

Practical rule: If you're trying to figure out how to unhide all columns in excel, don't start by hunting gaps. Start by selecting everything.

When this method won't solve it

If nothing happens, the columns may not be hidden in the standard way. Common reasons include:

That’s when you move beyond the basic unhide command.

Keyboard Shortcuts for Maximum Efficiency

If you spend most of your day in Excel, the keyboard route is faster than reaching for the mouse. For repeated cleanup work, it also feels more reliable because you can do it from muscle memory.

The most dependable shortcut sequence is Alt + H + O + U + L. Wall Street Prep notes that this sequence arrived with the Excel 2007 ribbon interface and has shown a 20-30% productivity lift for keyboard-focused users. The same source also notes that Ctrl + Shift + 0 is faster when it works, but can be unreliable for about 15% of users because of system-level key mapping conflicts (Wall Street Prep).

The shortcut I trust most

Use this order:

1. Select the whole sheet with Ctrl + A
2. Press Alt
3. Then press H
4. Then O
5. Then U
6. Then L

This tells Excel to open the Home tab, then Format, then Hide & Unhide, then Unhide Columns.

It sounds long on paper. In real use, it’s quick.

The fast but flaky option

Ctrl + Shift + 0 can unhide selected columns directly. On some Windows machines, though, it won't fire. If that happens, don't waste time troubleshooting unless you use it constantly. Just switch to the Alt sequence or the universal right-click method.

A quick visual walkthrough helps if you want to see the rhythm in action:

Once the Alt sequence is in your hands, it's one of those small Excel habits that sticks.

Mac users are better off sticking with sheet selection plus right-click or the ribbon. Shortcut support is less consistent across setups, and the universal method is usually just as fast in practice.

Uncovering Columns Hidden by Filters and Groups

Often, people get tripped up. They try standard unhide, nothing changes, and they assume the file is corrupted. Usually it isn't.

If the columns are hidden by a filter, an outline group, or a nearly invisible width setting, Unhide may not solve the problem. You need to identify what Excel is doing.

If your missing columns are affecting charts, dashboards, or exports, this broader roundup of data display tools is worth browsing too: https://toolradar.com/best/data-visualization

When filters are the real issue

A filter doesn't technically hide columns in the same way as the format command. But filtered views often make users think part of the sheet disappeared, especially when tables are involved and only certain fields or outputs remain visible in context.

Look for dropdown arrows in the header row. If they're active, go to:

• Data
• Sort & Filter
• Clear

That resets the filter state. If the sheet suddenly makes sense again, you weren't dealing with hidden columns at all.

Grouped columns and outline controls

Grouped columns are common in reporting models. You'll usually see a plus or minus control above the column headers.

Use one of these approaches:

• Click the plus sign to expand a collapsed section
• Select the grouped area and use Ungroup
• If the outline structure is a mess, go to Data and clear the outline

This matters in financial and operational sheets because the file can contain all the data you need, but the outline keeps major sections collapsed.

A grouped worksheet can look like it has missing columns even when nothing is hidden by the standard hide command.

Zero-width columns that don't look hidden

This is the sneakiest case. A column may be set to such a narrow width that it appears gone, but Excel doesn't present it as a normal hidden column.

Try this:

1. Select the columns around the missing one
2. Right-click
3. Choose Column Width
4. Enter a normal width value

If you don't know which column is affected, select a broader area and apply a visible width. That often reveals the problem immediately.

A simple diagnosis checklist

If standard unhide works only partly, I usually check groups next. In shared business files, grouped columns are one of the biggest reasons the worksheet still looks incomplete after an unhide command.

Advanced Unhiding with a VBA Macro

When the sheet is large, messy, or full of non-contiguous hidden columns, VBA is the cleanest fix. It tells Excel directly to make every column visible instead of relying on interface actions.

GeeksforGeeks notes that a VBA macro using Columns.EntireColumn.Hidden = False can be up to 10 times faster than the manual Ctrl+A > Right-click > Unhide route, with a near-100% success rate on unprotected sheets (GeeksforGeeks).

Copy and run this macro

Open the VBA editor with Alt + F11. Then go to Insert > Module and paste this code:

Sub UnhideAllColumns()
    Columns.EntireColumn.Hidden = False
End Sub

Press F5 while your cursor is inside the macro to run it.

Why this method is worth keeping

This is the option I keep for ugly files. It’s especially useful when the workbook has been edited by several people, imported from another system, or packed with hidden support columns.

It also saves time if you regularly clean up exports before analysis. If you edit scripts or automate workflows elsewhere, a list of lightweight coding tools can help with that broader toolkit too: https://toolradar.com/blog/best-free-code-editors

VBA is less elegant than a quick right-click, but it's much better at brute-force cleanup.

One caution: if the worksheet is protected, the macro won't help until you remove protection.

Fixing Common Unhide Errors and Protected Sheets

When Unhide is grayed out, Excel is usually telling you one of two things. Either your selection doesn't include any hidden columns, or the worksheet is protected.

Protected sheets

Check the Review tab. If you see Unprotect Sheet, click it. If the file owner set a password, you'll need that password before Excel lets you change hidden columns.

This is common in shared operational files, especially when the workbook is part of a larger reporting or handoff process. If hidden data keeps interfering with updates, the underlying problem may be the workflow design rather than the sheet itself. That’s the same class of issue teams run into during broader system transitions like https://toolradar.com/blog/data-migration-strategy

Hidden first or last columns

Column A and the far-right column are awkward because you can't select a column on both sides of them.

Use one of these fixes:

• Click the Select All triangle in the top-left corner, then use the ribbon to unhide.
• Click the Name Box, type A1, press Enter, then go to Home > Format > Hide & Unhide > Unhide Columns.

If nothing seems to work

Run through this short checklist:

• Select the full sheet, not just part of it
• Check Review for protection
• Look for grouping symbols above headers
• Set column width manually if a gap looks suspiciously narrow

That sequence solves most "Excel won't unhide my columns" situations without much trial and error.

Frequently Asked Questions About Unhiding Columns

Can I unhide only certain non-adjacent hidden columns

Yes. Select the visible columns around each hidden section while holding Ctrl on Windows. Then right-click one of the selected headers and choose Unhide.

If the file has lots of scattered hidden areas, it's usually faster to unhide the whole sheet, inspect it, and then re-hide the columns you want hidden.

Why is the Unhide option grayed out

The usual causes are:

• Your selection doesn't include hidden columns
• The worksheet is protected
• You're dealing with grouped or zero-width columns, not standard hidden ones

The fix is to select the entire sheet first. If that fails, check protection and grouping.

Does unhiding columns change formulas or data

No. Unhiding changes visibility, not content. Your formulas, references, and stored values stay the same.

What does change is your ability to inspect them. That's why unhiding is often the first thing to do before troubleshooting mismatched formulas or export issues.

Is there a better option than Excel for complex shared files

Sometimes, yes. If multiple people constantly hide, group, protect, and reshape the same workbook, the underlying issue may be that the process has outgrown a spreadsheet. If you're comparing options beyond Excel and Access-heavy setups, this roundup can help: https://toolradar.com/blog/microsoft-access-alternatives

If you're comparing spreadsheet tools, workflow apps, developer utilities, or reporting software, Toolradar is a practical place to shortlist options without bouncing between generic review pages.