How to Hide a Column in Excel: Steps and Shortcuts

How-to basics · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, select the column by clicking its lettered header, right-click it, and choose Hide. You can also use Home > Cells > Format > Hide & Unhide > Hide Columns, or press Ctrl+0 after selecting the column. Hiding conceals the column on the worksheet without deleting its contents.

Hide a column using the ribbon or right-click menu

The right-click method is usually quickest when you can see the column heading. Column letters appear across the top of a worksheet; clicking one selects the entire column, including its cells, even those beyond the visible rows. Right-click the selected letter and choose Hide. The column disappears, and the neighboring column letters sit next to each other with a small boundary marking the hidden space.

If you prefer the ribbon, first select a column or several columns. On the Home tab, find the Cells group, open Format, point to Hide & Unhide, and choose Hide Columns. The command is useful when the right-click menu is unfamiliar or when you want to follow a consistent ribbon-based workflow.

For example, if a worksheet has customer names in column A, email addresses in B, and internal notes in C, select the C header and hide it to make the sheet easier to read during a presentation. The notes remain in the workbook; they are simply not displayed as a column in the current worksheet view.

Hide several columns at once

To hide adjacent columns, click the first column letter and drag across the headers to the last one. You can also click the first header, hold Shift, and click the last header. Once the whole range is selected, right-click any selected header and choose Hide, or use the ribbon command. For instance, selecting D through F hides all three columns in one action.

For columns that are not next to each other, select the first header, then hold Ctrl on Windows while clicking each additional header. When all intended columns are highlighted, use Hide. Be careful not to click a worksheet cell while building a non-adjacent selection, as that can clear the column selection. If it does, start again from the column letters.

You can select an entire contiguous range by clicking a header and dragging across the headings, or by clicking the first header, holding Shift, and clicking the last. Confirm the highlighted headers before hiding, especially in a wide sheet: hiding a mistaken column may make data appear missing even though it has not been removed.

Use the keyboard shortcut

On Windows, select one or more columns and press Ctrl+0 (zero, not the letter O) to hide them. This is convenient when you are working with the keyboard and already know which columns are selected. The ribbon and context-menu methods remain reliable alternatives if the shortcut does not work on a particular computer or keyboard setup.

On Excel for Mac, the corresponding hide-columns shortcut is generally Command+0. Shortcuts can vary with keyboard layout and system settings, so use the menu command if the key combination is intercepted or produces a different result. In Excel for the web, keyboard shortcuts may also depend on browser settings; the ribbon or header context menu is a straightforward option.

Do not confuse hiding a column with deleting it. The shortcut changes the display only. If you press a deletion command by mistake, use Ctrl+Z on Windows or Command+Z on Mac promptly to undo that action.

How to unhide a column

To reveal a hidden column between two visible columns, select the headers on both sides of the hidden space. For example, if column C is hidden, select B and D together by clicking B and then holding Ctrl while clicking D. Right-click either selected header and choose Unhide. You can instead open Home > Cells > Format > Hide & Unhide > Unhide Columns.

When multiple neighboring columns are hidden, select the visible headers on both outer sides of the hidden group and choose Unhide. To unhide every column on the worksheet, click the Select All button at the intersection of the row numbers and column letters, then use Home > Cells > Format > Hide & Unhide > Unhide Columns. This reveals columns throughout that sheet, so use it when you do not need to preserve other hidden columns.

The first column is a special case because there is no visible column to its left. Click the Name Box to the left of the formula bar, type A:A, and press Enter to select column A. Then use the ribbon’s Unhide Columns command. A similar approach works for other specific columns: enter a column reference such as D:D in the Name Box, then choose the unhide command.

If you cannot tell where a hidden column is, look for a skipped letter in the headers or for a narrow boundary between two columns. A hidden column has effectively zero display width, so dragging its boundary may be difficult; selecting neighboring headers and using Unhide is more dependable.

Hiding, filtering, and grouping are different

Use Hide when you want to conceal a whole worksheet column without changing which records are shown. It is a display choice, not a data operation. A filter, by contrast, hides selected rows that do not meet criteria, such as orders from a particular region. Filtering is better when the goal is to focus on matching records while keeping other records available through the filter controls.

Grouping is another option when people need to show and hide columns repeatedly. Select the columns, then choose Data > Outline > Group. Excel adds outline controls that can collapse or expand the grouped columns. This is useful in reports that offer detail and summary views—for example, a monthly sales summary with several underlying transaction columns. A plain hidden column has no dedicated expand/collapse control, so a reader may not notice that information is tucked away.

For occasional cleanup, simple hiding is faster than grouping. For a shared report with optional detail, grouping can make the hidden structure easier to discover and restore. Filtering does something else altogether: it controls visible rows based on data conditions rather than concealing selected fields.

What hiding changes—and what it does not

Hiding a column changes its width in the worksheet view; it does not clear its cells or remove the column from the workbook. Formulas that refer to cells in a hidden column continue to calculate. For example, a total formula can still include values in a hidden column, and a formula elsewhere can still display a value stored there. The formula bar, Name Box, and other worksheet features may also let a user navigate to or inspect the underlying cells.

Hidden columns are normally omitted from the worksheet’s printed output, which can help produce a cleaner report. Before distributing a printout or PDF, check File > Print and the print preview. Page breaks, scaling, print areas, and other layout settings affect the final pages, so previewing is safer than assuming that a particular layout will fit.

Hiding is not a privacy or security measure. Anyone who can edit or inspect the workbook may be able to unhide a column, and the underlying data remains in the file. If information must not be shared, remove it from the copy you distribute or use an appropriate access-control approach; do not rely on hidden columns to protect confidential data.

Excel for the web, Mac, and mobile

In Excel for the web, select a column header and use the header’s context menu or the available ribbon command to hide it. The exact placement of commands can look different from desktop Excel, but the basic idea is the same: select the worksheet column, then choose Hide. To restore it, select the neighboring headers and choose Unhide, or use the relevant ribbon command.

Excel for Mac also supports hiding and unhiding columns from the column-header context menu and the ribbon. The menu wording is similar, though the interface layout and keyboard shortcuts differ from Windows. On phones and tablets, select the column using its header and look in the context or formatting controls for the hide option; the available controls depend on the device and app layout. If a command is hard to locate on a small screen, opening the workbook in desktop Excel can make column selection easier.

Common problems and practical fixes

  • Unhide is unavailable or has no effect: Make sure the selection includes the visible column or columns on both sides of the hidden range. For column A, select it through the Name Box instead of relying on a left neighbor.
  • The column seems missing after a filter: Check whether rows are filtered, whether a column is hidden, or both. Clearing a filter will not unhide a column, and unhiding a column will not restore filtered-out rows.
  • You cannot hide or unhide on a protected sheet: Worksheet protection can restrict formatting changes. If you are authorized, use Review > Unprotect Sheet and provide the password if required. When protecting a sheet, the Format columns permission controls whether users can format columns, including changing their visibility.
  • The shortcut does not respond: Confirm that a column header is selected, use the zero key rather than O, and try the ribbon command. System or keyboard settings can affect shortcut behavior.
  • A saved workbook opens with columns hidden: The hidden state is part of the workbook’s current sheet layout. Unhide the columns before saving if recipients should see them by default.

In a shared workbook, it helps to leave a cue when a hidden column contains useful context. A brief note in a visible header, a grouped outline, or a clear handover message can prevent a collaborator from mistaking concealed data for deleted data. When you receive a workbook, check for skipped column letters before concluding that fields are absent.

Frequently Asked Questions

Can I hide a column without deleting its data?
Yes. Select the column header and choose Hide. The cells stay in the workbook, and formulas that use them continue to work.

How do I hide a column in Excel with a keyboard?
On Windows, select the column and press Ctrl+0. On Mac, try Command+0. If the shortcut is unavailable, use the ribbon or right-click the header.

How do I unhide column A?
Type A:A in the Name Box and press Enter. Then choose Home > Cells > Format > Hide & Unhide > Unhide Columns.

Can other people see a hidden column?
Yes. Hiding only changes what is displayed; another workbook user can usually unhide the column. Do not use this feature to conceal sensitive information.

Why can I not unhide a column?
Check that the correct neighboring headers are selected and that the sheet is not protected from column formatting. If the hidden column is at the edge of the sheet, select it by reference in the Name Box and run Unhide Columns.

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.