To unhide columns in Excel Online, select the visible column headers on both sides of the hidden column, right-click the selection, and choose Unhide Columns. You can also use Home > Format > Hide & Unhide > Unhide Columns when that command is available in the ribbon.
How to unhide one or more columns
Column headers are the letters across the top of a worksheet. If column C is hidden, for example, the visible headers may jump from B to D, often with a narrow double line between them. Selecting the headers around the gap tells Excel which hidden column you want to reveal.
- Find the gap in the column letters. For a hidden C, look for B and D next to each other.
- Select a continuous range of headers that includes the gap, such as B through D. You can drag across the headers, or select one header and then extend the selection to the other side.
- Right-click a selected header and choose Unhide Columns. If you prefer the ribbon, open Home > Format > Hide & Unhide > Unhide Columns.
The hidden column should appear in its original position, with the data and formulas it contained. Unhiding changes its visibility, not its contents. If several columns are hidden together, select headers on either side of the whole hidden span. For instance, if C through E are hidden, select B through F before choosing the command.
Unhide every column in a worksheet
If you do not know which columns have been hidden, you can reveal all of them at once. Click the Select All button at the intersection of the row numbers and column letters, above row 1 and to the left of column A. Then right-click a column header and choose Unhide Columns, or use the Home ribbon command if it is available.
This applies to the current worksheet, not automatically to every sheet in the workbook. Repeat the operation on other sheets as needed. Be aware that showing every column can make a worksheet wider and expose information that someone intentionally kept out of view, such as working notes or helper calculations. If the workbook is shared, check with its owner before changing the layout.
There is a practical difference between revealing a specific span and revealing everything. The targeted method preserves other hidden columns, while Select All followed by Unhide Columns makes all columns visible on that sheet. Neither operation deletes data, but either can change how other people see the worksheet.
What if column A is hidden?
The first column is awkward because there is no visible column header to its left. If A is hidden, the letters may begin at B, so selecting the headers on both sides of the gap is not possible in the usual way. The simplest method is to select the whole worksheet and choose Unhide Columns, as described above.
You can also try selecting the hidden column by its reference. Click the Name Box, the small field beside the formula bar that normally shows a cell address, enter A:A, and press Enter. Then use Home > Format > Hide & Unhide > Unhide Columns, if available. The Name Box can select a range even when its column is not visible. If the command is unavailable or you are unsure which columns are hidden, use Select All instead.
The same issue can occur when the first several columns are hidden. Selecting the full worksheet and unhiding columns is often more straightforward than trying to locate a boundary that is off the visible edge. If the sheet is protected, however, Excel may prevent the change even when you can select the sheet.
Hidden columns, narrow columns, and grouped columns
A column that appears missing is not always hidden. Someone may have reduced its width until the data is difficult or impossible to see. Check the boundaries between the visible column letters: if the boundary is unusually narrow, drag it to the right to widen the column. You can also select the relevant column headers and use Home > Format > Column Width to set a width, where that option is offered.
Grouped columns work differently from columns hidden with the Hide command. A worksheet with an outline may show level buttons or plus and minus symbols above the headers. Click a plus sign to expand a collapsed group. If the columns remain missing after using Unhide Columns, look for an outline control nearby; expanding the group may be the action that restores them.
Also distinguish hidden columns from rows hidden above or below the visible area. Column headers run across the top, while row numbers run down the left. If the missing information is in rows, select the row numbers around the gap and choose Unhide Rows, or use the corresponding row command in the Format menu. Choosing the column command cannot reveal hidden rows.
Filters and other features that can look similar
Filters hide rows from view; they do not hide columns. If records seem to be missing but the column letters are continuous, check whether a filter is active in the header row. In Excel for the web, use the filter dropdown in a table or filtered range to clear the selected criteria, or use the Data tab’s filtering controls. Clearing a filter can reveal records, but it will not change column visibility.
Freeze panes can also make a worksheet behave unexpectedly while you scroll. Frozen columns stay in place as other columns move, but they are still present and visible. If a column seems to be in an unexpected position, check whether the sheet has frozen panes and try scrolling horizontally. Freeze panes are a navigation aid, not a way of hiding data.
Finally, hidden columns can make formulas appear to skip letters. A formula may refer to a cell in a hidden column, and that reference continues to work while the column is hidden. Unhiding the column displays the cells again; it does not recalculate the formula differently just because the layout changed.
Excel Online compared with the desktop app
Excel for the web provides the core operations needed to show hidden columns: select the relevant headers, right-click, and use Unhide Columns, or look under the Home tab’s Format menu. Exact ribbon presentation can vary as Microsoft updates the web interface, and some commands may be placed in a compact menu when the browser window is narrow. Widen the window or expand the ribbon if you cannot see the option.
In Excel for Microsoft 365 on Windows, the equivalent ribbon path is Home > Format > Hide & Unhide > Unhide Columns. The header right-click method is also available. Excel for Mac has corresponding commands in the Home tab’s Format menu, although the ribbon layout can differ. Right-clicking a column header is a useful alternative across these versions.
A workbook opened in the browser may also offer an option to open it in the desktop app. That can help when the web interface does not expose a command you need or when you need more control over the workbook. Changes must still be saved to the file, and a shared workbook may update for other collaborators as edits are saved.
Why Unhide Columns may not work
If the command does not appear or the columns stay hidden, check these common causes:
- The selection misses the hidden span. Select visible headers on both sides of the gap, including the columns that form the boundary.
- The sheet is protected. Protection can restrict formatting changes such as hiding or unhiding columns. If you have permission, use the sheet’s protection controls to remove protection; otherwise ask the workbook owner to make the change.
- The columns are grouped. Expand the outline with its plus control rather than relying only on Unhide Columns.
- The width is nearly zero, not hidden. Drag the header boundary wider or set a column width.
- You are looking at the wrong sheet. Unhiding columns on one worksheet does not affect another. Check the sheet tabs at the bottom.
- You have view-only access. A person without editing permission may be able to inspect the workbook but not change its layout. Request edit access or ask an editor to reveal the columns.
When working in a shared file, confirm that you are editing the intended workbook and sheet. A collaborator may make another layout change while you are working. If the columns reappear and then disappear again, ask whether someone else is hiding them or whether a saved view, outline, or protection setting is affecting what you see.
Before you change a shared worksheet
Hiding columns is a presentation choice, not a security measure. A hidden column’s data remains in the workbook and may be revealed by someone who has suitable access. Do not rely on hiding columns to protect private or confidential information; use appropriate file permissions and remove sensitive data from copies that should not contain it.
In a shared workbook, unhiding columns can make helper data or internal calculations visible to collaborators, and it changes the worksheet layout for people viewing the same file. If you only need to inspect a value, consider asking the owner first. If you make the change, communicate what you changed so collaborators understand why the worksheet looks different. For an important workbook, make a copy before substantial layout edits; simple unhiding is usually reversible by hiding the columns again.
Frequently Asked Questions
Can I unhide columns in Excel Online without a mouse?
You can use the ribbon if you can navigate to Home > Format > Hide & Unhide > Unhide Columns. Keyboard navigation and shortcuts can differ between Excel for the web, the browser, and your operating system, so the ribbon is the more dependable route when a shortcut is intercepted.
Why does Excel skip a column letter?
A gap such as B followed by D usually means column C is hidden, though an extremely narrow column can look similar. Select the headers around the gap and choose Unhide Columns; if that does not help, widen the boundary or check for a collapsed group.
Will unhiding a column restore its data?
Unhiding reveals data that remains in the workbook. It does not recover content that was deleted, and it does not change formulas simply because a column becomes visible.
Can I unhide columns if the worksheet is protected?
Not if the protection settings prevent that layout change. Ask the workbook owner or an authorized editor to unprotect the sheet or reveal the columns. Do not try to bypass protection you are not authorized to change.
Does unhiding columns remove a filter?
No. Column visibility and filtering are separate. Unhide Columns reveals hidden columns; clearing a filter reveals rows excluded by filter criteria.
Related
- Data Validation Studio: Excel Rules, Setup, and Limits
- Power Query Circular Reference: Causes and Fixes
- Excel Data Validation Source: Lists, Ranges, and Rules
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Double-Click Column Width Not Working?If double-clicking an Excel column boundary does not resize the column, first double-click the right edge of its…
- SUMPRODUCT Formula Not Working? Fix the Common CausesIf SUMPRODUCT is not working in Excel, first check that every range in the formula has the same…
- VLOOKUP Not Working Across Workbooks? Fix Common ErrorsVLOOKUP can search a range in another workbook, even when that workbook is closed, as long as the…
- COUNTIFS Not Working With Multiple Criteria? Fix ItIf COUNTIFS is not working with multiple criteria, check that every criteria range is the same size, that…
- Excel Value Filter Not Working? Fix the Common CausesIf an Excel value filter is not working, first clear the current filter and check that the column…
- Excel Solver Too Many Variable Cells? Fix the 200-Cell LimitExcel’s built-in Solver add-in allows up to 200 changing variable cells in a model. If your model needs…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.