Hide Columns in Excel: How to Hide and Unhide Them

How-to basics · Updated November 18, 2026

To hide a column in Excel for Microsoft 365 on Windows, select its lettered heading, right-click it, and choose Hide. To bring it back, select the column headings on both sides of the hidden column, right-click, and choose Unhide. Hiding changes what is displayed; it does not delete the column or its contents.

What hiding a column does

Excel columns are identified by letters above the worksheet grid. When you hide one, Excel reduces its displayed width to zero, so its cells and heading are no longer visible. The other columns move together on screen: for example, after hiding column C, the visible headings appear as A, B, D, and E. The column has not been removed, and the worksheet’s other data does not shift into its place.

Values, formulas, formatting, and references in a hidden column remain in the workbook. A formula elsewhere can still use a value from that column, and the formula can continue to calculate normally. This makes hiding useful when you want a cleaner view without changing the underlying worksheet. It is also reversible, unlike deleting a column, which removes its contents and can affect formulas or layouts.

Hiding is a display choice, not a way to protect confidential information. Someone who can work with the sheet may unhide the column or inspect the workbook in other ways. If information must be restricted, do not treat a hidden column as a security measure.

Hide a column with the mouse or ribbon

The right-click method is the quickest for a single column. In Excel for Microsoft 365 on Windows:

  1. Find the letter at the top of the column you want to conceal, such as D.
  2. Click the column heading to select the entire column. The heading and cells below it should be highlighted.
  3. Right-click the selected heading and choose Hide from the context menu.

You can also use the ribbon. Select the column, then choose Home > Cells > Format > Hide & Unhide > Hide Columns. This route is useful when you prefer ribbon commands or cannot easily open the context menu. The same Hide & Unhide commands are also used to restore columns.

To hide adjacent columns, select their headings together. For example, click B and drag across to D, or click B and Shift-click D, then right-click the selected heading area and choose Hide. To hide separate columns, hold Ctrl while clicking each heading on Windows, then right-click one of the selected headings and choose Hide. On a Mac, use Command instead of Ctrl to select separate headings. Take care not to click inside individual cells if your intention is to select whole columns.

Use keyboard shortcuts

On Windows, select one or more columns and press Ctrl+0 to hide them. The shortcut operates on the selected columns, so select their lettered headings first if you want to hide the full columns. In Excel for Mac, Command+0 is the corresponding hide-columns shortcut in versions that support it. If a shortcut is intercepted by the operating system or does not work in your Excel setup, use the right-click or ribbon method instead.

Excel for Windows also has Ctrl+Shift+0 for unhiding columns in some configurations, but this shortcut may not work because Windows keyboard or regional settings can reserve it. It is not the most dependable way to restore a column. The ribbon’s Unhide Columns command works without relying on that shortcut. On Excel for the web, shortcut behavior can also depend on the browser, so the column-heading context menu is a practical alternative.

Keyboard shortcuts are most convenient when the selection is already correct. Before pressing Ctrl+0 or Command+0, confirm that the column headings you intend to hide are selected. If a cell range is selected instead, the result may not match what you meant to do.

Unhide columns, including column A

For a hidden column between two visible columns, select the visible headings on either side. If C is hidden, select B and D together by clicking B, then holding Ctrl while clicking D on Windows (Command on Mac). Right-click one of the selected headings and choose Unhide. You can also use Home > Cells > Format > Hide & Unhide > Unhide Columns.

If several adjacent columns are hidden, select the visible columns on both sides of the hidden block and choose Unhide. If the hidden columns are at the far right of the worksheet, select the visible column immediately to their left and extend the selection across the hidden area using the Name Box or a broader selection; then use Unhide Columns. When the location is unclear, selecting the whole worksheet and using the ribbon command is a straightforward way to restore hidden columns throughout that sheet.

Column A can be awkward to restore because there is no visible column heading to its left. Click the Name Box to the left of the formula bar, enter A:A, and press Enter to select column A. Then choose Home > Cells > Format > Hide & Unhide > Unhide Columns. The Name Box can also select a known range such as A:D when you need to work with a specific group of columns.

To unhide every hidden column on a worksheet, click the Select All button at the top-left corner of the grid, where the row numbers and column letters meet. Then use Home > Cells > Format > Hide & Unhide > Unhide Columns. This affects the active worksheet, not every sheet in the workbook. Repeat on other sheets if needed. Unhiding all columns may reveal helper data or make a carefully arranged report wider, so consider whether you want to restore everything before doing so.

Hide several columns and manage selections

Hiding multiple columns at once is often easier than repeating the command. For a continuous block, select the first column heading and drag to the last. For separate columns, hold Ctrl on Windows or Command on Mac while selecting each heading. Then use Hide from the context menu or the ribbon. For instance, a report might keep the customer name and final total visible while hiding internal code, intermediate calculation, and notes columns.

If a column is already hidden inside a selection, selecting visible headings around it and choosing Hide will hide the selected visible columns as well. It will not delete any of them. When selections are nonadjacent, inspect the highlighted headings before issuing the command; it is easy to include a column unintentionally when clicking or dragging across the header row.

For repeated use, Excel’s grouping feature can be more convenient than manually hiding and unhiding columns. Select the columns, then choose Data > Group. Excel adds an outline control that can collapse or expand the grouped columns. Grouping is designed for sections users may need to show and conceal repeatedly, such as detail columns beneath a summary. It is different from ordinary hiding: the outline controls make the collapsed area more apparent and easier to expand.

Common problems and what to check

If Unhide appears unavailable or seems to do nothing, first check that your selection includes the hidden column. For a hidden column between two visible ones, selecting only one neighboring column may not be enough; select both sides. You can also select the whole worksheet and run Unhide Columns to rule out a selection problem.

A column can look hidden even when it was not hidden with the Hide command. Its width may have been set extremely narrow or to zero. Select the columns around the gap, then choose Home > Cells > Format > Column Width and enter a positive width. Alternatively, use Home > Cells > Format > AutoFit Column Width after selecting the relevant columns. If the heading letters skip from B to D, that is a useful sign that C is hidden or has zero width.

Worksheet protection can restrict formatting actions, including hiding or unhiding columns, depending on the protection settings. If Excel does not allow the change, check whether the sheet is protected and whether you have permission to alter its layout. Do not remove protection from a shared or controlled workbook without confirming that you are authorized to do so.

Hidden columns are normally omitted from the worksheet’s printed output and from a PDF made from that sheet. If a report is missing information on paper, inspect the worksheet for hidden columns and check the print area and page layout as well. Restoring a column can make the sheet wider and affect page breaks, so review Print Preview before distributing the report.

When hiding is useful—and when it is not

Hiding helps when a worksheet contains supporting detail that is not needed for the current task. Examples include hiding internal identifiers in a presentation view, temporarily concealing calculation columns while reviewing results, or narrowing a wide worksheet so readers can focus on the key fields. Because the data remains available, this approach is generally less disruptive than deleting columns or moving data to another sheet.

It is less suitable when readers may not realize that information is hidden, or when the workbook needs a clearly guided summary. Consider adding a note that supporting columns are hidden, using Group to provide expand-and-collapse controls, or creating a separate report sheet with only the intended fields. For a clean printout, check page layout and print settings rather than assuming that hiding columns will automatically make every page readable.

Hiding also differs from filtering. A filter hides rows that do not meet criteria; it does not hide the columns themselves. Freezing panes is different too: it keeps selected rows or columns visible while you scroll, rather than concealing them. Choose the feature that matches the problem—hide a column to remove it from the current view, filter rows to narrow records, and freeze panes to keep headings in sight.

Frequently Asked Questions

How do I hide a column in Excel without deleting it?
Select the column heading, right-click it, and choose Hide. The contents and formulas remain in the worksheet; only the column’s display is concealed.

How do I unhide the first column in Excel?
Enter A:A in the Name Box to select column A, then choose Home > Cells > Format > Hide & Unhide > Unhide Columns. The ribbon command avoids needing a visible heading to the left of A.

Can I hide multiple non-adjacent columns?
Yes. Select their headings while holding Ctrl on Windows or Command on Mac, then choose Hide from the context menu or ribbon. Check the selected headings before applying the command.

Does hiding a column affect formulas?
Hiding a column does not delete its values or change references merely because it is hidden. Formulas can continue to use its contents, although functions or charts may have their own rules for handling hidden data.

Can someone see a hidden column?
Yes. Hiding is not a security control; a person with access to the worksheet may unhide the column. Do not store information in a workbook on the assumption that hiding it keeps it private.

Why can’t I unhide a column?
The selection may not include the hidden column, the column may have zero width, or worksheet protection may restrict changes. Select the surrounding columns or all cells, use Unhide Columns, and check the column width and protection settings if it remains invisible.

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.