How to Unhide Columns in Excel: 5 Methods (with Shortcuts)
How to unhide columns in Excel: drag headers, right-click Unhide, Ctrl+Shift+0, Go To Special, and fixes for columns that refuse to reappear. Full guide.
Learning how to unhide columns in Excel is a rite of passage because hidden columns are invisible by design: the sheet looks complete while salary bands, ID keys, or audit flags sit concealed one drag away. Inherited workbooks hide columns constantly — for printing, for focus, sometimes by accident — and the analyst who cannot restore them is analysing a redacted dataset. This guide builds on the interface tour and complements the companion piece on hiding columns.
On the Data Analyst Roadmap, this is week-1 table stakes: verify you can see all the data before you analyse any of it.
A hidden column is just a column with zero width — nothing is deleted
Unhiding restores the previous width, so data, formulas, and formatting return intact. That reversibility is why hiding beats deleting for working sheets — and why you should always check for hidden columns in inherited files.
How to Unhide Columns in Excel: the Standard Method
The universal right-click method from Microsoft Support:
- Spot the gap. Hidden columns announce themselves as a doubled header line and skipped letters — columns jump
BtoE, with a thicker divider between them. - Select both neighbours. Click column
B's header, holdShift, click columnE's header. The hiddenC:Dsit inside the selection. - Right-click → Unhide. Anywhere on the selected headers, right-click and choose Unhide.
CandDreappear at their previous widths.
Keyboard-first analysts: with the flanking columns selected, press Ctrl+Shift+0 (zero). The ribbon path is Home → Format → Hide & Unhide → Unhide Columns — worth memorising for the edge cases below where right-click cannot reach.
How to Unhide Columns in Excel When the Usual Way Fails
Unhiding everything at once. When a handover sheet hides columns in five scattered places, hunt them one by one is a waste: click the Select All triangle above row 1 and left of column A (or Ctrl+A), then right-click any column header → Unhide. Every hidden column on the sheet restores in one move.
Unhiding column A. The first column has no left neighbour, so the flank-selection trick is impossible. Three options: type A1 in the Name Box (left of the formula bar) and press Enter, then Home → Format → Hide & Unhide → Unhide Columns; or Select-All plus Unhide; or drag-select from the row-number gutter rightward across where A should be, then right-click → Unhide.
Dragging zero-width columns open. A column set to width 0.00 behaves hidden but sometimes ignores Unhide. Hover the doubled header divider until the double-arrow cursor appears, then double-click (autofit) or drag right. If the cursor never appears, the sheet is likely protected — see below.
| Symptom | Cause | Fix |
|---|---|---|
| Letters skip (B→E) with thick divider | Standard hidden columns | Select flanks → right-click → Unhide |
| Column A missing, no divider visible | Hidden first column | Name Box A1 → Format → Unhide Columns |
| Unhide option greyed out | Sheet protection | Review → Unprotect Sheet (password may be needed) |
| Unhide runs but nothing appears | Zero width, panes, or filter | Drag divider; unfreeze panes; clear filters |
Column visible but cells show ### | Too narrow, not hidden | Widen column or enable Wrap Text |
How do you audit a sheet for hidden columns without eyeballing letters?
On wide handover sheets, scanning header letters for skips is slow and error-prone. Two faster audits: first, the Select-All test — click the corner triangle, then Home → Format → Hide & Unhide → Unhide Columns followed by Unhide Rows, and watch the scrollbars jump. If the used range shrinks or totals change, something was concealed. Second, the width check with the CELL function in a helper row: =CELL("width", C1) returns the column width in characters (FALSE if the column is hidden or the sheet recalculates oddly — zero-width columns report distinctly from visible ones). Drag it across the header row and scan for zeros. Neither replaces the visual check entirely — very-hidden sheets (VBA xlVeryHidden) need the VBA editor — but together they catch standard hiding in seconds on sheets with hundreds of columns, which is exactly where manual letter-scanning fails.
Common Mistakes and Fixes
Frozen panes masquerading as hidden column A
Freeze panes at B2 and scroll right: column A slides out of view while the header still reads C, D, E…. Analysts "unhide" a column that was never hidden. Before any unhide routine, check View → Freeze Panes → Unfreeze — if A reappears, the mystery is solved and no hiding was ever involved.
The second trap is sheet protection. Inherited finance sheets often protect structure with forgotten passwords; every Unhide path greys out uniformly. Confirm via Review → Unprotect Sheet. Without the password you cannot unhide — request it from the owner rather than rebuilding the data, because retyped columns diverge from source within a week.
Audit every inherited workbook for hidden data first
Press Ctrl+A → right-click → Unhide, then Home → Format → Unhide Rows, as step zero of any handover. Hidden columns have concealed salary fields, discontinued-SKU flags, and second versions of "final" numbers in real engagements. Pair this with the data cleaning audit: the query ran, but was it run on the whole dataset?
How to Unhide Columns in Excel vs Related View Controls
| Feature / Criteria |
|---|
Learn all three together: handover sheets combine hidden columns, hidden rows, and frozen panes freely, and misdiagnosing one as another wastes the most time. The full Select-All unhide of both dimensions plus an unfreeze is the reliable "show me everything" reset — run it before trusting any inherited sheet, and read the hiding guide to use concealment deliberately rather than accidentally.
When to Unhide Columns in Analyst Work
Handover audits. Every inherited workbook gets the unhide-everything pass before analysis begins. Hidden columns routinely hold the previous analyst's scratch logic, deprecated mappings, or the key column a lookup needs — finding them early prevents rebuilding what already exists.
Print-to-analysis recovery. Sheets formatted for printing hide helper columns aggressively. When that "clean" sheet becomes your analysis source, unhide first and re-verify totals: helpers often contain the adjustments the printed figures depend on, and analysing without them reproduces numbers you cannot reconcile.
Debugging #REF! and stale lookups. A deleted-looking column that a formula still references was often just hidden — unhiding reveals whether the source survived. Combined with formula-bar tracing from the interface tour, this resolves a surprising share of "broken" inherited models in minutes.
Related Excel Tutorials
- Excel Formulas: The Complete Guide
- XLOOKUP Formula in Excel
- SUM Formula in Excel
- Excel Pivot Tables Guide
- Explore All Guides in the Excel Tutorials Hub
Master Excel for Data Analysis
Learn Excel formulas, pivot tables, and dashboards with free, project-based courses.
Start Free Excel CourseFrequently Asked Questions
How do I unhide columns in Excel?
Select the columns on both sides of the hidden ones, right-click the header, and choose Unhide. Alternatively select the surrounding range and press Ctrl+Shift+0, or use Home > Format > Hide & Unhide > Unhide Columns.
What is the shortcut to unhide columns in Excel?
Ctrl+Shift+0 (zero) unhides columns within the current selection. Select the columns flanking the hidden ones first — with no selection context the shortcut may appear to do nothing.
How do I unhide all columns in Excel at once?
Click the Select All triangle (top-left corner), then right-click any column header and choose Unhide, or Home > Format > Hide & Unhide > Unhide Columns. This restores every hidden column on the sheet.
Why won't my columns unhide in Excel?
Three usual causes: the column width was set to zero (drag the boundary instead), the sheet or workbook is protected (Review > Unprotect Sheet), or frozen panes make it look like column A is missing when it is just scrolled out of view.
How do I unhide the first column (column A) in Excel?
Column A has no left neighbour to select, so use the Name Box: type A1, press Enter, then Home > Format > Hide & Unhide > Unhide Columns. Or select the whole sheet and Unhide everything.
Written by
Founder at Topfolio with 6+ years in data & analytics across JPMC, Ultrahuman, and high-growth startups. Sat on hiring panels, reviewed 500+ resumes, and writes practical SQL & data guides.
Related Articles
How to Hide Columns in Excel: Shortcuts, Grouping, and Best Use
How to hide columns in Excel: right-click Hide, Ctrl+0, grouping outlines for reports, and what hiding does to formulas, printing, and shared workbooks.
How to Delete Blank Rows in Excel: 4 Safe Methods (with Checks)
How to delete blank rows in Excel safely: Go To Special Blanks, AutoFilter blanks, helper COUNTBLANK flags, and backup checks every analyst must run first.
How to Insert Checkbox in Excel: Developer Tab + COUNTIF Uses
How to insert checkbox in Excel: enable Developer tab, link cells to TRUE/FALSE, count checked boxes, and build interactive task trackers step by step.