How To Unhide All Columns In Excel At Once

3 min read

Whether you inherited a messy spreadsheet from a colleague or accidentally hid important data while cleaning up your worksheet, knowing how to unhide all columns in Excel at once can save you hours of frustration. Hidden columns are a common feature in Microsoft Excel, often used to temporarily remove sensitive information or declutter a wide dataset without deleting anything permanently. That said, when you need to review the full picture, searching column by column is inefficient. This guide walks you through the most reliable methods to reveal every hidden column in your workbook quickly, using built-in tools, keyboard shortcuts, and even a simple VBA macro for power users.

Why Columns Get Hidden in Excel

Before jumping into the solutions, it helps to understand why columns disappear

Common reasons include protecting sensitive data like salaries or personal identifiers, simplifying a view for a presentation or printout, or as an accidental byproduct of past formatting or filtering actions. Recognizing the cause can sometimes hint at the best recovery method.

Method 1: The Keyboard Shortcut (Quickest for a Single Sheet)

We're talking about the fastest way to unhide columns on the active sheet.

  1. Select All Columns: Press Ctrl + A. This selects every cell on the worksheet.
  2. Open the Format Menu: Press Alt + H + O (Hold down Alt, then press H, then O).
  3. Unhide Columns: Press I, then C.

The column letter headers will reappear instantly.

Method 2: Using the Format Menu (Visual and Intuitive)

If you prefer using the mouse, the Format menu is straightforward Not complicated — just consistent..

  1. Select the Surrounding Columns: Click and drag across the column letters immediately to the left and right of the hidden column(s). Here's one way to look at it: to unhide column D (which is between C and E), click and drag from column C to column E.
  2. Right-Click: Right-click on any of the selected column letters.
  3. Choose Unhide: From the context menu, select Unhide.

To unhide multiple columns at once, select a range that includes the hidden columns and their visible neighbors, then right-click and choose Unhide Most people skip this — try not to. Still holds up..

Method 3: Unhide All Columns with a VBA Macro (For Multiple Sheets or Complex Workbooks)

When columns are hidden across many sheets or you need a one-click solution, a simple VBA macro is your best friend. Here’s how to create and run it.

Step 1: Open the VBA Editor

  • Press Alt + F11.

Step 2: Insert a New Module

  • In the VBA Project window, right-click on your workbook's name.
  • Hover over Insert and click Module.

Step 3: Paste the Macro Code

  • Copy and paste the following code into the code window:
Sub UnhideAllColumns()
    Dim ws As Worksheet
    For Each ws In ThisWorkbook.Worksheets
        ws.Columns.AutoFit ' This line forces Excel to evaluate and unhide all columns
        ws.Columns.ColumnWidth = ws.Columns.ColumnWidth ' This ensures they stay unhidden
    Next ws
    MsgBox "All columns in all sheets have been unhid.", vbInformation
End Sub

Step 4: Run the Macro

  • Press Alt + F8.
  • Select UnhideAllColumns from the list and click Run.

This macro loops through every sheet in your workbook, ensuring no column remains hidden.

Conclusion

Whether you need a quick fix on a single sheet or a comprehensive sweep of an entire workbook, Excel provides the tools to recover your hidden data efficiently. Mastering the keyboard shortcut for immediate needs and the VBA macro for larger tasks will eliminate the guesswork and restore your full dataset in seconds, keeping your workflow smooth and your data accessible That's the part that actually makes a difference..

What Just Dropped

Newly Added

Handpicked

Neighboring Articles

Thank you for reading about How To Unhide All Columns In Excel At Once. We hope the information has been useful. Feel free to contact us if you have any questions. See you next time — don't forget to bookmark!
⌂ Back to Home