Excel Column Won’t Unhide? Causes, Checks, and Fixes

How-to basics · Updated November 18, 2026

If an Excel column will not unhide, select the columns on both sides of it—or select the whole worksheet—and choose Home > Format > Hide & Unhide > Unhide Columns. If that does not work, check whether the sheet is protected, the column is grouped, or its width was set to almost zero rather than hidden.

How Excel hides columns

A hidden column remains part of the worksheet, but Excel gives it a width of zero, so its letter and cells are not visible in the grid. For example, if the headings jump from A to D, columns B and C may be hidden. Their data and formulas still exist; hiding a column changes what is displayed, not the underlying cell contents.

That distinction matters because several different situations can look like a hidden column. A column might have a very small nonzero width, be part of a collapsed outline group, or simply be outside the visible area because the sheet has been scrolled horizontally. A filter, by contrast, hides rows, not columns. Finding which situation applies helps avoid changing more of the worksheet than intended.

Unhide a column with the ribbon or context menu

For a column between visible columns, select the headers on either side of the gap. If A is followed by D, select columns A through D, then use the ribbon command. You can also select just the hidden range if you know its letters.

  1. Select the affected column headers. To select a range, click the first header, then drag to the last; alternatively, use the Name Box to the left of the formula bar, type a range such as B:C, and press Enter.
  2. On the Home tab, choose Format > Hide & Unhide > Unhide Columns.
  3. Check the column headings and adjust the width if the column appears too narrow to read.

Another route is to select the neighboring headers, right-click one of the selected headers, and choose Unhide. The command is on the header’s context menu, not the menu for an individual cell. On Excel for Mac, select the columns and use Home > Format > Hide & Unhide > Unhide Columns, or use the header context menu; ribbon details can vary slightly with the window size and version. Excel for the web also provides an Unhide Columns command after you select the relevant headers, though its ribbon layout may differ.

Reveal the first or last worksheet column

Unhiding column A can be confusing because there is no column header to its left. If A is hidden, click the Name Box, type A:B, and press Enter to select the range, then choose Home > Format > Hide & Unhide > Unhide Columns. You can also select the whole worksheet using the Select All button at the intersection of the row numbers and column letters, then run Unhide Columns.

The same whole-sheet method is useful if you do not know which columns are missing. It can reveal every hidden column on that worksheet, however, so it may expose columns the workbook’s creator deliberately concealed. If you only want one specific range restored, use the Name Box to select that range and unhide it rather than changing the entire sheet.

Column XFD is the last column in a standard Excel worksheet. If it is hidden, or if the visible area is at the far edge of the sheet, selecting the whole worksheet is often easier than trying to position the pointer beside its header. The Name Box can also select a range near the edge when you know the column letters.

Check for a zero or very small column width

A column can appear missing even when it was not hidden with the Hide command. Its width may have been set to a tiny value, leaving a narrow divider that is difficult to notice. In that case, select the column by its range in the Name Box or select the headers around it, then choose Home > Format > Column Width. Enter a practical width and confirm. Alternatively, use Home > Format > AutoFit Column Width to size the selected column to its contents.

For example, if the headers jump from F to H, select F:H and inspect the width of G. If G is set to a small number rather than zero, Unhide Columns may not make a visible difference; setting a normal width will. If the cells contain long text, AutoFit may make the column much wider than expected, so a specific width can be more suitable for a carefully laid-out report.

AutoFit is not always a perfect measure of what you want to display. Wrapped text, merged cells, and unusually long entries can affect the result or make the layout awkward. If a column is technically visible but its contents still seem absent, check the cell values, font color, number format, and whether adjacent cells visually cover overflowing text before concluding that the column remains hidden.

Expand a grouped or outlined column range

Excel’s outline feature can collapse a group of columns. Look above the column letters for outline controls, such as a plus or minus sign, or numbered outline levels. A minus sign near a group generally indicates that the group is expanded; a plus sign indicates that it is collapsed. Click the plus sign to expand the grouped columns.

Grouping is useful for reports that need summary and detail views, and it is not the same as manually hiding columns. The standard Unhide command may not be the clearest way to restore a collapsed outline. If the group controls are visible, expand the group first. To remove the grouping, select its columns and use Data > Outline > Ungroup, but do this only if you no longer need the outline controls. Ungrouping changes the worksheet’s structure; expanding the group simply reveals its detail again.

Find out whether sheet protection is blocking the change

A protected worksheet may prevent column formatting, including hiding or unhiding columns. If Unhide is unavailable or the command does not change the sheet, open the Review tab and look for Unprotect Sheet. If the sheet is protected, select that command and provide the password if Excel requests one. Then select the columns and try the unhide command again.

Protection settings can allow some actions while blocking others. When someone protects a sheet, they can choose whether users may format columns. If you manage the workbook, you can review those options by selecting Review > Protect Sheet and checking the permissions before protecting it again. If you do not know the password, ask the workbook owner or administrator for access; do not assume that a missing column means the workbook is damaged.

Workbook structure protection is a separate setting from worksheet protection. It controls certain changes to sheet tabs, such as adding, deleting, or moving worksheets; it is not the usual control that blocks changing a column’s visibility on a sheet. For a column that will not unhide, check the protection status of the worksheet itself first.

Rule out scrolling, filtering, and display confusion

Before changing formatting, check whether the missing column is simply off-screen. Use the horizontal scrollbar at the bottom of the Excel window, or enter the column letter in the Name Box to move to that area. Freeze Panes can keep certain rows or columns in place while the rest of the sheet scrolls, which can make the layout less obvious, but freezing does not itself hide columns.

Filters hide records, meaning worksheet rows, when they do not match the selected criteria. If some entries seem to have disappeared but the column letters are all present, inspect the filter arrows and clear or adjust the filter rather than unhiding columns. Similarly, a hidden row can make data seem missing without affecting the column headings. Look at both the row numbers and the column letters to identify which dimension is concealed.

Also consider whether you are viewing a different worksheet tab than the one where the columns were hidden. Large workbooks often contain similarly named sheets, and each worksheet has its own hidden-column settings. Confirm the active tab and inspect the relevant range there.

What to do if the column still will not appear

Use this order to narrow down the cause without making unnecessary changes:

  • Select the exact range with the Name Box, such as B:C, and run Unhide Columns.
  • If the first column may be hidden or you do not know the affected range, select the whole worksheet and unhide columns, keeping in mind that this reveals all hidden columns on that sheet.
  • Set a known width with Home > Format > Column Width if the column may be extremely narrow.
  • Expand any outline group with its plus control.
  • Check Review for worksheet protection and ask the owner for the password if required.
  • Confirm that the issue is not horizontal scrolling, a filter hiding rows, or a different active worksheet.

If the workbook is shared or part of a controlled reporting process, note which columns you changed. Hidden columns can hold supporting calculations or sensitive information, and revealing them may change what other viewers can see. Restoring visibility does not delete data, but it can alter the intended presentation of a worksheet.

Frequently Asked Questions

Why does Unhide Columns do nothing in Excel?
Select the hidden range along with at least one adjacent visible column, then try again. If the column is merely very narrow, set its width directly. Also check for a collapsed outline group or a protected worksheet.

How do I unhide column A when there is no column before it?
Type A:B in the Name Box and press Enter, then choose Home > Format > Hide & Unhide > Unhide Columns. Selecting the whole worksheet with the Select All button is another option.

Can I unhide every column in a worksheet at once?
Yes. Select the whole worksheet using the Select All button, then use Home > Format > Hide & Unhide > Unhide Columns. This affects all hidden columns on that sheet, including ones that may have been hidden intentionally.

Does filtering hide columns in Excel?
No. A filter hides rows that do not match its criteria. Hidden columns are a separate display setting, so use the column headers and outline controls to investigate a missing column.

Why can I not select Unhide on a protected sheet?
The worksheet may prohibit column formatting while protection is enabled. If authorized, choose Review > Unprotect Sheet and enter the password if requested, or ask the workbook owner to change the protection settings.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.