To unhide columns in Excel for Microsoft 365 on Windows, select the column headers on both sides of the hidden column, then press Ctrl+Shift+0. If that shortcut is unavailable, use Home > Format > Hide & Unhide > Unhide Columns. The key is selecting a range that includes the hidden column; if the first or last column is hidden, select the whole sheet or enter a column range in the Name Box.
What You’ll Need
- An Excel workbook with the worksheet containing the hidden columns open.
- Permission to change the worksheet. A protected sheet may prevent you from unhiding columns unless the relevant formatting permission is allowed or the sheet is unprotected.
- A keyboard, if you want to try the shortcut. The ribbon command is a practical alternative when a keyboard setting intercepts the shortcut.
You do not need to install an add-in or change the workbook file type. Unhiding a column changes its visibility, not the values or formulas stored in it. If the workbook is important, save a copy before making broader layout changes, especially if you are unsure which columns were hidden.
Step-by-Step
- Open the correct worksheet. Select the sheet tab at the bottom of the Excel window. Column visibility is controlled separately for each worksheet, so unhiding columns on one tab will not automatically change another tab.
- Look for a sign that a column is hidden. Check the letters across the column headers. If the sequence jumps from, for example, A to C, column B may be hidden. A pair of close-together header boundaries or a small gap can also indicate a hidden column. If the letters appear in sequence but a column seems missing, it may instead have a very narrow width or be outside the current horizontal view.
- Select the headers around the hidden column. For one hidden column B, click the A header, hold the mouse button, and drag across to C so both A and C are selected. You can also click A, hold Shift, and click C. For several consecutive hidden columns, select the visible headers immediately before and after the hidden group. For instance, if C through E are hidden, select B through F.
- Use the Windows keyboard shortcut. With the surrounding column headers selected, press Ctrl+Shift+0 (Control, Shift, and zero). Excel should reveal the hidden column or columns within the selection. Press the keys together; do not type the characters into a worksheet cell. If nothing happens, use the ribbon method in the next step rather than repeatedly pressing the shortcut.
- Or use the ribbon command. Keep the relevant headers selected, then choose Home > Format > Hide & Unhide > Unhide Columns. In desktop Excel for Windows, you can also press Alt, then H, O, U, and L in sequence to follow the English ribbon KeyTips. These are sequential key presses, not a chord. KeyTips can differ if your Excel display language or ribbon configuration differs.
- Check the result. Confirm the missing column letters and data are visible, then verify that the revealed values look as expected. If multiple columns were hidden, inspect the whole selected range; Excel can reveal more than one column in a single operation.
- To unhide every column on the worksheet, select the entire sheet first. Click the small triangle at the intersection of the row numbers and column letters, above row 1 and left of column A. Then use Home > Format > Hide & Unhide > Unhide Columns. This is more reliable than trying to drag across a long range of headers. It reveals hidden columns throughout the selected sheet, so use it only when that is what you want.
- To handle a hidden first or last column, select by reference. If column A is hidden, there may be no visible header to click on its left. Click the Name Box to the left of the formula bar, type A:B, and press Enter. That selects columns A and B even though A is hidden. Then use the ribbon command to unhide columns. For a hidden final column such as XFD, select the entire sheet using the corner triangle and use the same command.
- Use the ribbon on Mac or Excel for the web. The Windows Ctrl+Shift+0 shortcut does not apply universally across operating systems and keyboard settings. On a Mac, select the surrounding column headers and choose Home > Format > Hide & Unhide > Unhide Columns. In Excel for the web, select the surrounding headers and use the corresponding Home > Format > Hide & Unhide > Unhide Columns command if it is available in your ribbon. The ribbon route avoids relying on a shortcut that may be different or intercepted by the browser or operating system.
After unhiding, you can adjust the column width if the data is still hard to read. Select the column, then choose Home > Format > Column Width and enter a suitable value, or use AutoFit Column Width from the same Format menu. Unhide restores visibility; it does not necessarily set an ideal width for the contents.
Common Mistakes
- Selecting only the visible column beside the gap. Excel needs a selection that includes the hidden column. Select the headers on both sides of the gap, or select the whole worksheet.
- Using the shortcut as if it were a menu command. Ctrl+Shift+0 is a key combination, not text to type into a cell. On some Windows systems it may be unavailable because Windows or a keyboard layout uses that combination. The ribbon command performs the same task.
- Confusing hidden columns with filtered rows. A filter hides rows, not columns. If records are missing vertically, check the filter arrows in the header row and the row numbers instead of using Unhide Columns.
- Assuming a narrow column is hidden. A column may still be present but have a very small width. If the letters do not skip, select the column and set a width or use AutoFit Column Width.
- Unhiding the wrong worksheet. Each sheet has its own hidden columns. Check the active tab before changing visibility, particularly in workbooks with similarly named sheets.
- Selecting the whole sheet without considering the effect. The whole-sheet method can reveal many columns, including ones intentionally hidden for presentation. If you only need one column, select a smaller range around it.
Tips
- Use the header letters, not the cells. Clicking and dragging across the column letters selects whole columns, making it clear to Excel which hidden columns you want to reveal. Selecting cells in the grid can work in some cases, but the headers are the most straightforward target.
- Remember that hidden columns still contain data. Unhiding does not edit or delete values, formulas, or formatting. It simply makes the columns visible again, which is useful when a workbook has been arranged to hide supporting calculations.
- Try a broader selection if the first attempt fails. When it is unclear where a hidden group begins or ends, select the entire sheet and use Unhide Columns. If that works, you can then hide any columns that should remain out of view.
- Use the Name Box for hard-to-select ranges. The Name Box accepts column references such as A:B or D:H. This is especially helpful when column A is hidden, when headers are very narrow, or when the sheet has many columns.
- Distinguish hiding from grouping. Grouped columns have outline controls, often shown as plus or minus buttons above the column headers. Click the plus button to expand a collapsed group. The ordinary Unhide Columns command may not expand a group that is simply collapsed by outlining.
- On Mac, prefer the ribbon if a shortcut is uncertain. Keyboard behavior can vary with the Excel version, macOS settings, and keyboard layout. The visible Home and Format menus provide a dependable route without changing system keyboard preferences.
Troubleshooting
The shortcut does nothing. First confirm that the column headers on both sides of the hidden area are selected. Then use Home > Format > Hide & Unhide > Unhide Columns. Windows settings or the active keyboard layout can intercept Ctrl+Shift+0, so a failed shortcut does not necessarily mean the workbook is damaged. In Excel for the web, a browser or operating system may also capture keyboard combinations.
Column A is still missing. Select columns A:B through the Name Box, even though A is not visible, and run Unhide Columns. Another option is to click the worksheet corner triangle to select all cells, then use the ribbon command. Selecting only the first visible column, B, may not include the hidden A column in the selection.
The command is unavailable or Excel will not change the sheet. The worksheet may be protected. Open Review > Unprotect Sheet if you are authorized to do so. If Excel requests a password, ask the workbook owner or administrator; there is no legitimate way to bypass a password-protected sheet through the Unhide command. If the sheet must remain protected, its owner may need to allow column formatting when setting protection.
The column appears after unhiding but its contents are not readable. It may have a zero or very small width, or the contents may be clipped by the current width. Select the column header and choose Home > Format > AutoFit Column Width, or set a width using Home > Format > Column Width. Check merged cells as well, since they can affect how AutoFit behaves.
Unhide Columns has no visible effect. Check whether the columns are grouped and collapsed; use the outline plus button to expand the group. Also confirm that the gap is actually a hidden column rather than a filtered row, a frozen-pane boundary, or a different worksheet view. Frozen panes change what stays on screen while scrolling, but do not hide columns. If the header letters skip and the sheet is not protected, select the entire sheet and try the ribbon command again.
Frequently Asked Questions
What is the shortcut to unhide columns in Excel for Windows?
With the hidden column and its surrounding columns included in the selection, press Ctrl+Shift+0. If Windows captures the shortcut or it does not work, use Home > Format > Hide & Unhide > Unhide Columns.
How do I unhide a column when column A is hidden?
Type A:B in the Name Box and press Enter to select both columns, then choose Home > Format > Hide & Unhide > Unhide Columns. Selecting the whole worksheet first also works.
Can I unhide all columns at once?
Yes. Click the worksheet corner triangle to select the entire sheet, then choose Home > Format > Hide & Unhide > Unhide Columns. This reveals every hidden column on that worksheet, not on every sheet in the workbook.
Does unhiding a column restore its previous width?
It makes the column visible, but the width may still be too small to display its contents comfortably. Use AutoFit Column Width or set a width manually if needed.
Why can I see a plus sign above some columns?
The columns may be grouped with Excel’s outline feature and collapsed. Click the plus sign to expand the group. This is different from a column being hidden individually.
Does the Windows shortcut work in Excel for Mac or the web?
Do not assume Ctrl+Shift+0 will work there. Keyboard shortcuts can differ or be intercepted, so select the column headers and use the Unhide Columns command in the Home and Format menus.
Related
- How to Superscript in Excel: Format Text in a Cell
- Sum in Excel in Different Rows: Quick Methods
- How to Sum in Excel Using the Keyboard: Quick Steps
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets IFS Formula: Syntax, Examples, and FixesIn Google Sheets, the IFS function checks conditions in order and returns the value paired with the first…
- How to Read an Excel Box and Whisker Plot Step by StepTo read an Excel box and whisker plot, match each box to its category, read the median line…
- Highlight in Excel Without a Mouse: Keyboard StepsTo highlight cells in Excel without a mouse, select them with the keyboard, then press Alt, H, H…
- Circular Reference Settings in Excel: How They WorkIn Excel for Microsoft 365 on Windows, turn on circular-reference calculations at File > Options > Formulas by…
- Google Sheets Daily Schedule Template: Build Your OwnA Google Sheets daily schedule template is a reusable spreadsheet for organizing the day by time, activity, priority,…
- Excel Hide Text Under the Next Column?In Excel for Microsoft 365 on Windows, text spills into the next column when that neighboring cell is…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.