If columns are not showing in Excel, select the column headers on both sides of the gap, right-click, and choose Unhide. If that does not work, check whether the missing columns have zero width, are inside a collapsed outline group, or are simply outside the visible part of the worksheet.
First, identify what is missing
Look at the column letters above the grid. If they jump from A to D, for example, columns B and C are hidden or have a width of zero. If the letters run in order but the cells you expect are blank, the issue is probably not hidden columns: the data may be elsewhere, filtered indirectly by a different view, or on another worksheet.
Also distinguish a hidden column from one that has been scrolled out of sight. Excel worksheets can extend far to the right, so a column may be beyond the current window rather than concealed. Use the horizontal scroll bar at the bottom of the sheet, or press Ctrl+Home to return to the top-left area. On a Mac, use Control+Home if available on the keyboard; on some Mac keyboards, Fn+Control+Left Arrow performs the equivalent navigation.
These checks are for Excel for Microsoft 365 on Windows. Many of the same commands are available in Excel for Mac and Excel for the web, although their ribbon layouts and keyboard shortcuts can differ.
Unhide columns between visible headers
When a gap in the letters indicates hidden columns, select the visible column headers on either side of that gap. For example, if the headings jump from B to E, select columns B through E by dragging across their headers, then right-click one of the selected headers and choose Unhide. Selecting both boundary columns matters: choosing only E may not include the hidden columns to its left.
- Click the header of the visible column before the gap.
- Drag across the header of the visible column after the gap so the selection includes both boundaries.
- Right-click within the selected header area and choose Unhide.
- Check the column letters and worksheet contents to confirm the columns returned.
You can also use the ribbon: select the columns around the gap, then choose Home > Format > Hide & Unhide > Unhide Columns. In Excel for Mac, select the neighboring column headers and use the context menu’s Unhide command; ribbon wording or placement can vary slightly by release. In Excel for the web, selecting the adjacent headers and using the right-click menu is often the simplest route.
If you do not know where columns are hidden, select the entire worksheet by clicking the small triangle at the top-left corner of the grid, where the row and column headers meet. Then use Home > Format > Hide & Unhide > Unhide Columns. This can reveal every hidden column on that sheet, so it may also expose columns intentionally concealed for presentation.
Reveal column A or another column at the edge
The first column is a special case because there is no visible column to its left. If A is hidden, clicking the apparent first header, often B, and trying to select a boundary can be confusing. Use the Name Box instead: it is the small box to the left of the formula bar, normally showing a cell reference such as B1.
- Click the Name Box and type
A:B, then press Enter. This selects columns A and B, including hidden column A. - Choose Home > Format > Hide & Unhide > Unhide Columns, or right-click the selected headers and choose Unhide.
The same approach works for a hidden column at the far end of a known range: type a range that includes it into the Name Box, then unhide the selection. If the Name Box is not visible, make sure you are in the worksheet view and not editing a cell. You can also select the whole sheet using the upper-left corner control and unhide all columns.
Check for zero-width columns
A column can be present but effectively invisible because its width is set to zero or a very small value. This can look exactly like a hidden column: the letters skip, and the cell contents cannot be seen. The Unhide command often restores a conventionally hidden column, but setting a specific width is a useful fallback.
Select the columns on both sides of the gap, then choose Home > Format > Column Width. Enter a reasonable width, such as 10, and confirm. The number is a character-based width, not a measurement in inches, so the displayed result depends on the workbook’s font and settings. You can instead use Home > Format > AutoFit Column Width to size the selected columns to their contents. AutoFit can make a column very wide if it contains long text, so a fixed width may be preferable for a clean layout.
To check whether a visible column is merely too narrow, point to the boundary between its letter header and the next one. When the resize cursor appears, drag the boundary to the right. Double-clicking the boundary AutoFits that column. Avoid dragging the wrong boundary: resizing an adjacent column changes the layout but does not reveal the missing one.
Expand grouped or collapsed columns
Excel’s outline feature can group columns so a user can collapse them without treating them as ordinary hidden columns. Look above the column letters for outline controls, such as level numbers or a plus and minus button. A plus sign near the grouped columns usually means that group is collapsed. Click it to expand the columns. If outline symbols are not visible, check Data > Outline for the grouping controls.
Grouping is useful for reports that show a summary by default and let readers expand detailed fields. For instance, a sales worksheet might keep individual monthly columns collapsed while displaying an annual total. A collapsed group can be mistaken for missing data, particularly when someone else prepared the workbook. Expanding the outline is usually better than ungrouping it, because ungrouping removes the worksheet’s deliberate summary structure.
Check sheet protection and workbook restrictions
If Unhide is unavailable or greyed out, the worksheet may be protected. Check Review > Unprotect Sheet. If the sheet is protected, Excel may require the password set by the workbook’s owner. Protection is intended to limit changes to a sheet; it is not a sign that the columns have been deleted. Ask the person who supplied the workbook for permission or the password rather than trying to work around the protection.
Workbook structure protection is a separate setting that can restrict actions such as adding, deleting, moving, or hiding sheets. It is less commonly the direct cause of a column-level Unhide command being unavailable, but if workbook structure is protected, some workbook changes may be disabled. The Review tab indicates protection-related controls. Do not remove protection on a shared or business file unless you are authorized to change it.
Another possibility is that you are viewing a read-only copy or lack edit permission in a shared workbook. You may be able to inspect the sheet but not change its layout. If commands are disabled, confirm that you have editing access and that the file is not opened in a restricted mode.
Rule out scrolling, panes, filters, and display confusion
Frozen panes do not hide columns, but they can make navigation seem unusual. A thick line in the worksheet marks a freeze boundary. Columns to the left of that line remain fixed while the rest of the sheet scrolls horizontally. If you are looking for a field farther right, use the horizontal scroll bar rather than expecting the frozen area to move. To change the setting, choose View > Freeze Panes and select the appropriate unfreeze or freeze option. Be aware that changing freeze panes affects the workbook’s navigation for other users too.
Filters normally hide rows that do not meet the chosen criteria, not columns. If column headers are present but expected records are missing, inspect the filter arrows in the header row and clear the relevant filter using Data > Clear, or open the filter menu and select the appropriate values. This is a related but different problem: clearing a filter will not restore a missing column letter.
Also check the active worksheet tab. A workbook can contain several sheets with similar names, and the expected columns may be on another tab. If column letters are present but the area looks blank, consider whether the text is formatted in the same color as the cell background, whether the column is extremely narrow, or whether you are viewing a different copy of the workbook. Zoom changes the size of the view, but it does not hide columns by itself.
When columns were deleted rather than hidden
If the column letters are consecutive and the data is genuinely absent, the columns may have been deleted rather than hidden. Unhide cannot restore deleted content. If the deletion just happened, use Ctrl+Z on Windows to undo it; on Mac, use Command+Z. Undo may not be available after closing the workbook, saving over a file, or performing other actions that clear the undo history.
For a saved workbook, check version history if the file is stored in OneDrive or SharePoint, or restore a copy from an established backup. In Microsoft 365, use File > Info to look for version-related options when they are available for that file and storage location. Restoring an earlier version can also discard newer edits, so compare versions carefully or save a separate copy before restoring. If the file is managed by an organization, its administrator may control retention and recovery options.
Prevent columns from seeming to disappear
When preparing a worksheet for others, distinguish between hiding, grouping, and deleting columns. Hiding is reversible and useful for temporarily simplifying a view; grouping makes the collapse and expand controls more apparent; deleting removes the data and may require Undo or a backup to recover. Add a note or clear label when a report intentionally conceals supporting fields.
- Use outline grouping when readers should be able to expand details themselves.
- Keep important identifiers visible when hiding optional or technical fields.
- Before changing a shared workbook, save a copy or confirm that collaborators are not relying on its current layout.
- If you use protection, document who can unprotect the sheet and where the authorized password is maintained.
- When a column looks empty, check its width and the column letters before assuming its contents were erased.
Frequently Asked Questions
How do I unhide the first column in Excel?
Click the Name Box, type A:B, and press Enter to select columns A and B. Then choose Home > Format > Hide & Unhide > Unhide Columns, or right-click the selected column headers and choose Unhide.
Why is Unhide greyed out in Excel?
There may be no hidden column in the selected range, the sheet may be protected, or you may not have editing permission. Select the columns on both sides of the gap, check Review > Unprotect Sheet, and confirm that the workbook is not read-only. A password-protected sheet requires authorization from its owner.
Why do my column letters jump from B to E?
Columns C and D are hidden, have zero width, or belong to a collapsed group. Select B through E and use Unhide; if that fails, set a width through Home > Format > Column Width or click the outline plus sign to expand a group.
Can a filter make Excel columns disappear?
Ordinary filters hide rows that do not match the filter criteria; they do not hide worksheet columns. If column letters are missing, investigate hidden columns, zero width, or outline grouping. If the letters remain but records are missing, inspect the filter settings.
Can I recover columns that were deleted?
Unhide cannot recover deleted columns. Use Undo immediately if the deletion is still in the undo history, or look for an earlier version or backup of the workbook. Save a separate copy before restoring a previous version so you can preserve any newer work.
Related
- Excel Environmental Data Analysis: Methods and Examples
- Excel Solver Answer Report: Create and Read It
- How to Run Solver in Excel: Setup and Optimization
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Column Autofit: Fit Widths and Fix ProblemsTo autofit a column in Excel for Microsoft 365 on Windows, select the column or columns, then choose…
- TRIM and CLEAN Not Working in Excel? Fix the Hidden SpacesTRIM and CLEAN can seem broken because they do not remove every character that looks like a space.…
- Excel Freezing? Fix a Workbook That Stops RespondingIf Excel is freezing, first wait briefly to see whether it is finishing a calculation or loading a…
- Excel Not Responding After Copy and Paste? Fix ItIf Excel says “Not Responding” after you copy and paste, first give it a little time: a large…
- Circular Reference Error in Excel: How to Find It FastTo find a circular reference in Excel for Microsoft 365 on Windows, select Formulas > Error Checking >…
- Google Sheets: How to Wrap Text in Cells and Fix RowsTo wrap text in Google Sheets in a web browser, select the cell or cells, then choose Format…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.