Hidden columns in Excel are a common annoyance — sometimes they were hidden deliberately to clean up a view, sometimes they were hidden accidentally by clicking the wrong menu item, and sometimes a shared workbook arrives with columns hidden by a previous user. Unhiding them is straightforward in most cases. The simplest method: select the columns on either side of the hidden range, right-click any column header in your selection, and choose Unhide. Excel reveals the hidden columns immediately. The same approach works for any number of hidden columns between two visible columns.
The reality is that several methods work, and which one is fastest depends on the specific situation. Right-click works for small ranges with adjacent visible columns. The ribbon menu (Home → Format → Hide & Unhide → Unhide Columns) works the same way but produces the same result through menu navigation. Keyboard shortcuts work for users who prefer not to lift their hands from the keyboard. Special tricks handle the edge cases — column A specifically, columns hidden via filters, columns set to width zero, and stubborn cases where standard methods do not seem to work.
The most common mistake when unhiding columns is selecting only one side of the hidden range. To unhide column C between visible columns B and D, you must select both B and D before choosing Unhide. Selecting only B will not work because Excel does not know which direction to look.
The other common mistake is confusing hidden columns with very narrow columns. A column with width zero looks identical to a hidden column but is technically still visible — the unhide command does nothing because the column is not actually hidden. Knowing the difference saves frustration when standard methods fail.
Different scenarios benefit from different methods. A spreadsheet with a single hidden column gets unhidden fastest by right-click. A workbook inherited with dozens of hidden columns scattered throughout gets unhidden fastest by selecting the entire sheet and using the ribbon menu. A column A that was hidden by a previous user gets unhidden through the Name Box trick. Knowing which method matches the situation matters more than memorising every method. Excel's design makes the unhide capability discoverable through right-click and ribbon, but the edge cases are not obvious until you encounter them.
Right-click method: Select columns on both sides of hidden range → right-click any column header → Unhide. Ribbon method: Select adjacent columns → Home tab → Format → Hide & Unhide → Unhide Columns. Unhide all: Click the corner above row 1 / left of column A to select entire sheet → Home → Format → Unhide Columns. Column A trick: Type A1 in the Name Box (left of formula bar) → press Enter → Home → Format → Unhide Columns. Keyboard: Select adjacent columns → Ctrl + Shift + 0 (may not work on default Windows — see fix below).
This is the standard method most users learn first. Click the column letter to the left of the hidden range, hold Shift, and click the column letter to the right of the hidden range. Both columns plus everything between them are now selected. Right-click any of the selected column letters and choose Unhide from the menu. Excel reveals the hidden columns. The same workflow handles any number of hidden columns between two visible columns — they all appear at once.
The right-click method works on Excel for Windows and Excel for Mac with one small difference: Mac users right-click using Control + Click or two-finger tap on the trackpad. The menu options and behaviour are otherwise identical. The key requirement is having visible columns on both sides of the hidden range. If column A is hidden and your selection starts at B, the right-click menu still shows Unhide but the command fails silently because there is no column to the left of A. Column A requires a different approach (covered below).
Selection precision matters with the right-click method. Clicking the column letter selects the entire column. Shift-clicking another column letter extends the selection to include both columns and everything in between, including hidden columns. The selection appears highlighted across the column letters. The right-click menu then offers options that apply to the selected range. If you accidentally click a cell within the column rather than the column letter, the right-click menu shows different options without Unhide. Re-click the actual column letter (the grey area at the top with the letter) to get the column-level menu.
Fastest for unhiding 1-3 hidden columns when adjacent visible columns are available. Select the columns on either side, right-click any column letter in selection, choose Unhide. Works in Excel Windows, Excel Mac, and Excel for the web (with Control+Click on Mac). The standard method most Excel courses teach first.
Same result as right-click but through ribbon navigation. Useful when right-click is disabled (some corporate Excel deployments restrict context menus) or when you prefer menu-based workflows. Path: Home tab → Format dropdown in Cells group → Hide & Unhide → Unhide Columns. Slightly slower than right-click but more discoverable.
For unhiding every hidden column in the worksheet at once. Click the small triangle in the corner above row 1 and left of column A to select the entire sheet. Home → Format → Hide & Unhide → Unhide Columns. Reveals all hidden columns simultaneously. Useful for inherited workbooks where multiple hidden columns scatter across the sheet.
Type A1 in the Name Box (left of formula bar above column A header) and press Enter. The cursor jumps to A1 even though A is hidden. Then Home → Format → Hide & Unhide → Unhide Columns. The selection of A1 makes column A part of the active range; the unhide command then reveals it. Standard right-click does not work for column A because there is no column to its left to anchor selection.
Select columns adjacent to hidden range, then press Ctrl + Shift + 0. Often fails on default Windows because Microsoft removed this shortcut in newer Windows versions to avoid conflict with keyboard layout switching. Fix below explains how to restore the shortcut. Mac equivalent: Control + Shift + 0 reliably works.
For workbooks where standard methods fail, a one-line VBA macro reliably unhides all columns: Range("A1:ZZ1048576").EntireColumn.Hidden = False. Open VBA editor with Alt + F11, paste in immediate window or new module, run. Works even when worksheet is protected with structure protection (different from password-protected). Last resort method for difficult workbooks.
The ribbon path produces the same result through menu navigation. Click the column letter to the left of the hidden range, Shift-click the column letter to the right, then go to the Home tab. In the Cells group, click the Format dropdown. Hover over Hide & Unhide. Click Unhide Columns. The hidden columns appear. The same path works for hidden rows by choosing Unhide Rows instead. The ribbon method is helpful when right-click is disabled by IT policy in some corporate environments, or when you prefer menu-based workflows over context-menu workflows.
The Format menu also contains the Hide commands. Hide Columns hides the currently selected columns; Unhide Columns unhides hidden columns within the current selection. The same submenu also handles row hiding, sheet hiding, and even hiding entire windows. Spending a moment exploring the Hide & Unhide submenu reveals capabilities most users do not know exist. Like Absolute Reference Excel shortcuts, knowing where Excel hides menu options pays off across many different tasks.
The Format dropdown also offers Cell Size options including Row Height, Column Width, AutoFit Row Height, and AutoFit Column Width. AutoFit options resize rows or columns to fit the content automatically. This is sometimes a useful step after unhiding columns where the original column width was too narrow to display the actual data clearly. Selecting the unhidden columns then choosing AutoFit Column Width sizes them to the content automatically. Combine the unhide command with AutoFit when working with inherited workbooks where column sizing is inconsistent.
Standard right-click does not work because there is no column to the left of A. Type A1 in the Name Box (left of the formula bar, above column A's header) and press Enter. The cursor jumps to A1 even though A is hidden. Now go Home → Format → Hide & Unhide → Unhide Columns. Column A reveals. Alternative method: select column A and column B together by clicking on the line between the row numbers and column letters in the top-left corner area, then unhide.
Click the small triangle in the corner above row 1 and to the left of column A. This selects the entire worksheet. Home → Format → Hide & Unhide → Unhide Columns. Every hidden column in the sheet reveals at once. Same approach works for rows: same selection, then Unhide Rows. Useful for cleaning up workbooks inherited from other users where multiple hidden columns scatter across the sheet.
A column with width zero looks identical to a hidden column. Difference: hidden columns have width null and unhide reveals them. Width-zero columns have width zero and unhide does nothing. To fix width-zero columns: select adjacent columns, right-click → Column Width → enter a value like 10. The narrow column resizes to the new width. Tell the difference by looking at column letters — hidden columns produce a gap (A B D) while width-zero columns produce a thin line that you can drag to resize.
Active filters sometimes appear to hide content but technically use display logic rather than the Hide command. Look for the filter dropdown arrow in column headers. Right-clicking and choosing Unhide does not work for filtered content because no Hide was applied. Clear the filter instead: Data tab → Clear, or click the filter dropdown and choose Clear Filter from [column name]. Filtered rows reappear. The Show All option in the filter dropdown works the same way.
Excel's Group and Outline feature collapses sections of rows or columns by clicking the minus or plus buttons in the row/column header margins. The collapsed section is technically hidden but Unhide does not work because the visibility is controlled by the outline state. Click the plus button in the margin to expand the group, or use Data → Ungroup to remove the grouping entirely. The grouped state often surprises users who do not realise their workbook contains outline structures.
Worksheets protected with sheet protection (Review → Protect Sheet) sometimes block format changes including Unhide Columns. The Unhide menu item is greyed out or the command appears to do nothing. Unprotect the sheet first: Review → Unprotect Sheet (enter password if set). Now standard unhide methods work. Re-apply protection after unhiding if the sheet should remain protected, but configure the protection options to allow column formatting if users need to unhide in the future.
The official Excel shortcut for unhiding selected columns is Ctrl + Shift + 0. The problem: in many Windows installations, this shortcut conflicts with the keyboard layout switching shortcut and Excel's version of the shortcut does nothing. The fix involves disabling the keyboard layout shortcut in Windows settings or remapping the keyboard layout switcher to a different key combination. The exact path varies by Windows version: Settings → Time & Language → Language → Advanced keyboard settings → Input language hot keys → change the Between input languages shortcut to a different key combination or set to Not Assigned.
After making the Windows change, restart Excel and test Ctrl + Shift + 0 with adjacent columns selected. The columns should unhide. If the shortcut still does not work, an alternative shortcut combination exists: Alt → H → O → U → L on Windows uses keyboard navigation through the ribbon (Home → Format → Hide & Unhide → Unhide Columns). Slower than a single shortcut but completely reliable on default Windows installations. Mac users have it easier — Control + Shift + 0 works without configuration changes on Excel for Mac.
Some users prefer to leave the Windows shortcut as is and use Excel's alternative shortcut sequence. Press Alt to activate ribbon navigation, then H for Home tab, O for Format dropdown, U for Hide & Unhide submenu, and L for Unhide Columns (or O for Unhide Rows). The sequence Alt → H → O → U → L is slower than a single shortcut but completely reliable across all Windows configurations. Keyboard-focused users often memorise this sequence as a permanent fallback that works regardless of system configuration.
Another keyboard alternative for users who prefer not to lift hands from the keyboard: assign a custom keyboard shortcut to the Unhide Columns command via Excel Options → Customize Ribbon → Keyboard Shortcuts. Choose the Format menu, find HideUnhideColumns, and assign your preferred key combination. The custom shortcut works regardless of Windows keyboard layout settings. This approach takes a few minutes to configure but produces a reliable shortcut for users who routinely work with hidden columns.
The visual indicator of hidden columns is a gap in the column letter sequence. Visible columns A, B, D, E means column C is hidden. Visible columns A, F, G, H means columns B through E are hidden. Looking at the column letters before assuming nothing is hidden saves time when troubleshooting workbooks that look fine but seem to have missing data. Some users overlook the gap entirely because the column letters appear to flow naturally even with hidden columns between them.
The Name Box (the box left of the formula bar that shows the active cell reference) also reveals hidden columns. Click in any cell, then type a column letter and row number you suspect is hidden, like C1. Press Enter. The cursor moves to C1 even though column C is hidden. The active cell reference in the Name Box now shows C1, confirming that column C exists in the worksheet but is hidden from view. This trick also works to navigate to hidden ranges before unhiding them, which saves time on large worksheets.
Another visual clue is the cursor behaviour at column boundaries. When hovering the cursor between two visible columns where a hidden column exists between them, the cursor changes to a special two-arrow icon indicating you can drag to expand the hidden column without using the unhide command at all. Click and drag to the right with this cursor active, and the hidden column expands back to a visible width. This trick works for unhiding individual columns quickly without menu navigation, though it requires precise mouse positioning at the boundary line.
The methods are nearly identical between platforms with two small differences. Right-click on Mac is Control + Click or two-finger tap on the trackpad. Keyboard shortcut on Windows is Ctrl + Shift + 0 (often blocked by Windows); on Mac it is Control + Shift + 0 (works reliably). Ribbon navigation is identical on both platforms. The Name Box trick for column A works the same way on both. VBA macros work the same way except for very minor syntax differences that do not affect the simple unhide operations covered here.
Excel for the web (Microsoft 365 online) supports the right-click and ribbon methods but has reduced functionality for VBA macros. The Name Box trick works in the web version for navigating to hidden cells. Most casual users will not encounter platform differences for routine unhide operations. The Mac and Windows desktop versions both fully support every method described here.
The version of Excel matters too. Older Excel versions (2007 and earlier) used a different ribbon structure that made unhide commands harder to find. Excel 2010 and later all use the modern ribbon with consistent placement of the Hide & Unhide submenu. Excel 365 (the subscription version) sometimes adds new shortcuts or capabilities that older perpetual licence versions lack. The methods covered here work in Excel 2010 and all later versions on both Windows and Mac, including the current Microsoft 365 versions.
Hidden rows work identically to hidden columns. Select the rows above and below the hidden range, right-click a row number in the selection, and choose Unhide. Or use Home → Format → Hide & Unhide → Unhide Rows from the ribbon. The keyboard shortcut Ctrl + Shift + 9 unhides selected rows on Windows; the same Windows configuration issue can affect this shortcut as affects Ctrl + Shift + 0. The Name Box trick works for hidden row 1 — type A1, press Enter, then unhide rows.
Excel treats rows and columns symmetrically for hide and unhide operations. Workbooks like Budget Template Excel often have hidden rows for calculation logic that benefits from understanding how to unhide them when needed.
One subtle row-specific gotcha: hidden row 1 sometimes gets confused with frozen panes that are positioned at the top of the worksheet. If row 1 appears missing but standard unhide does not work, check View → Freeze Panes to see if frozen panes are active. Unfreezing the panes sometimes reveals row 1 was never actually hidden. Similarly, View → Split can produce visual artifacts that look like hidden rows but are actually a divided window view. Removing the split restores the standard view.
Most common cause. User selects columns and chooses Hide from right-click menu, often to clean up the view of a large worksheet. Sometimes hidden deliberately by data analysts to focus attention on key columns. Sometimes hidden accidentally when a user clicks the wrong menu item or drags a column boundary too far left.
Columns can be sized to width zero by dragging the column boundary all the way to the left or by setting Column Width to 0. Looks identical to hidden but is not technically hidden — the unhide command does nothing because Excel sees the column as visible. Restore by selecting adjacent columns, right-click → Column Width → enter a positive value.
Filtering hides rows that do not match filter criteria. Column equivalent is rare but possible with conditional formatting and complex Power Query setups. Filtered content is not hidden in the technical sense; it is shown or not shown based on filter state. Clear the filter to reveal everything.
Data → Group creates collapsible outlines for rows or columns. Collapsed groups appear hidden but use a different visibility mechanism. Click the plus button in the row/column margin to expand, or Data → Ungroup to remove the grouping. Common in financial models with section roll-ups.
Some workbooks resist standard unhide methods — sheet protection, complex outlines, or corrupted column properties can produce the symptom of seemingly stuck hidden columns. A one-line VBA macro reliably unhides everything: Range("A:ZZ").EntireColumn.Hidden = False. Open the VBA editor with Alt + F11, then either paste this command in the Immediate Window (View → Immediate Window) and press Enter, or create a new module and paste it inside a Sub procedure for repeated use. The command unhides all columns in the active sheet regardless of how they were hidden.
The same VBA approach handles row hiding: Range("A1:A1048576").EntireRow.Hidden = False unhides all rows in the active sheet. Combine both into one macro to clean up any workbook completely: Cells.EntireColumn.Hidden = False : Cells.EntireRow.Hidden = False. Save this as a Personal Macro Workbook macro for instant access from any open workbook. The Personal Macro Workbook lives at startup and provides utility macros across every Excel session, useful for routine maintenance tasks like reset-all-hidden-content.
VBA also helps when sheet protection blocks the unhide commands. The macro Sheets(1).Unprotect : Sheets(1).Cells.EntireColumn.Hidden = False : Sheets(1).Protect unprotects the sheet, unhides all columns, and re-protects. This works without a password if the protection has no password set; with a password, the macro becomes Unprotect Password:="yourpassword". Use carefully — modifying protected workbooks is sometimes restricted by organisational policy.
The shortcut conflicts with Windows keyboard layout switching in many Windows installations, and Microsoft removed Excel's claim on it. Fix: open Windows Settings → Time & Language → Language → Advanced keyboard settings → Input language hot keys → change the Between input languages shortcut to a different combination or set it to Not Assigned. Restart Excel. The shortcut should now unhide selected columns reliably. Mac users do not need this fix; Control + Shift + 0 works on Mac without configuration changes.
The standard right-click method does not work for column A because there is no column to its left to anchor the selection. Use the Name Box trick: type A1 in the Name Box (the box left of the formula bar above column A's header) and press Enter. The cursor moves to A1 even though A is hidden. Now go Home → Format → Hide & Unhide → Unhide Columns. Column A reveals. Same trick works for hiding row 1 — type A1 in Name Box, then Unhide Rows.
Several possible causes: the worksheet is protected (Review → Unprotect Sheet first), the columns have width zero rather than being technically hidden (right-click adjacent column → Column Width → enter value above 0), an active filter is hiding rows you mistook for columns (Data → Clear filter), or grouped/outlined sections are collapsed (click plus button in margin or Data → Ungroup). VBA fallback: Alt + F11 → Immediate Window → type Range("A:ZZ").EntireColumn.Hidden = False and press Enter.
Yes. Click the small triangle in the corner above row 1 and left of column A — this selects the entire worksheet. Then go Home → Format → Hide & Unhide → Unhide Columns. Every hidden column in the sheet reveals at once. Same approach works for rows: same selection, then Unhide Rows. Useful for cleaning up workbooks inherited from other users with multiple hidden columns scattered across the sheet.
Hidden columns have null width and Excel hides them entirely from display. Very narrow columns (width 0 or 0.01) appear as thin lines or no visible space at all but are technically still visible. The unhide command works for hidden columns but does nothing for narrow columns. Tell them apart by looking at the column letter sequence — hidden columns produce a gap (A B D), while narrow columns leave the letters in sequence (A B C D) but with no visible width for one or more.
No. Hidden columns participate in formulas and calculations exactly the same as visible columns. Hiding is purely a display setting. Formulas like =SUM(A:A) include hidden cells in the sum unless you specifically use a function like SUBTOTAL with the right function number to exclude hidden values. The hide and unhide operations are display-only and do not change calculation results in any way.