Hide Column Shortcut in Excel Online: Keys and Steps

In Excel Online (Excel for the web), select a column or columns and press Ctrl+0 (zero) to hide them. If that shortcut does not respond in your browser, use Home > Format > Hide & Unhide > Hide Columns, or right-click a selected column header and choose Hide.

The shortcut and what it does

Ctrl+0 hides the selected column or columns; it does not delete their contents. The hidden columns remain in the worksheet, so formulas can still refer to their cells and you can reveal the columns later. The same shortcut is familiar to many Windows Excel users, but a browser can sometimes reserve or interfere with keyboard combinations. That is why the ribbon and context-menu commands are useful fallbacks in Excel Online.

Use the number-row zero key, not a letter O. Start by selecting at least one full column using its letter heading at the top of the sheet, then press Ctrl+0. For example, select the C heading to hide column C. If you select a cell inside C instead, Excel may still apply the command to its column, but selecting the heading makes your intention clear and reduces mistakes.

Hiding changes what is displayed, not the underlying data or the workbook’s security. It is best understood as a way to make a sheet easier to read, rather than a way to protect confidential information.

Select the right columns first

Column selection determines what the hide command affects. Click a column letter to select the entire column. To select a continuous range, click the first heading and drag across the headings, or select the first heading, hold Shift, and select the last heading. For example, selecting D and then Shift-clicking F selects D, E, and F.

To select columns that are not next to each other, select one heading, then hold Ctrl while selecting additional headings on Windows. After confirming the intended headings are highlighted, use Ctrl+0 or a menu command. On a Mac using Excel for the web, modifier-key behavior can depend on the browser and keyboard setup; use the ribbon or right-click menu if multi-select with Ctrl is not behaving as expected.

One column: click its letter heading.
A range: select the first and last headings, using Shift to include the columns between them.
Separate columns: add individual headings to the selection with the platform’s multi-select modifier, then check the selection before hiding.

Be careful when selecting a range: hiding a column in the middle of a table can make it less obvious which values belong to the visible headings. If other people use the sheet, consider whether a note or a separate summary view would make the layout clearer.

Use the ribbon or right-click menu

The ribbon is the most dependable option when a keyboard shortcut conflicts with browser controls. Select the column headings, open the Home tab, then choose Format > Hide & Unhide > Hide Columns. Depending on the available window space, Format may appear in the Cells area of the Home ribbon or within a compact menu. If the full path is not immediately visible, widen the browser window or open the relevant ribbon menu.

You can also right-click one of the selected column headings and choose Hide. This is often the quickest mouse-based method because the command appears beside the selection. Make sure you right-click the letter heading, rather than a cell with data: the context menu can differ according to where you click.

These commands are alternatives to Ctrl+0, not different kinds of hiding. They produce the same basic result: the selected columns are concealed from the current worksheet view while their data remains in the workbook.

Hide several columns for a cleaner view

Hiding columns can help when a worksheet contains supporting details that are useful for calculations but distracting during routine review. For example, a sales tracker might show customer, order date, and total on screen while hiding internal reference codes and calculation notes. Select the headings for the columns you want to tuck away, then use the shortcut or menu. You can hide adjacent columns together or select separate columns when the layout calls for it.

Think about how the sheet will be used before hiding a large block. If a reader needs the hidden information to understand a visible total, hiding it may create confusion. It can help to leave a clear visible label or add a short note explaining that additional detail is concealed. Also check formulas and charts after changing the view: hiding data does not automatically remove its role in calculations, but a chart’s display of hidden data can depend on the chart settings.

For recurring, expandable sections, grouping may be more convenient than hiding columns manually. In Excel for the web, look for the grouping controls on the Data tab. Grouping adds an outline control that lets a reader expand or collapse a section. It is a different feature from Hide: it makes the presence of a collapsible section more apparent and is useful when people need to switch between summary and detail views.

Unhide columns when you need them again

To reveal a hidden column, select the visible column headings on both sides of it, right-click the selection, and choose Unhide. For instance, if C is hidden between visible B and D, select B and D together, then use Unhide. You can also use Home > Format > Hide & Unhide > Unhide Columns after making an appropriate selection.

If the first column, A, is hidden, there is no visible column heading on its left to select. Use the Name Box near the formula bar to enter a range such as A:A and press Enter to select column A. Then use the ribbon’s Unhide Columns command. If the Name Box is not obvious in the web layout, look near the formula bar, where it normally displays the address of the active cell.

When you are unsure which columns are hidden, selecting the entire worksheet and choosing Unhide Columns can reveal them all. This changes the view for every hidden column in that sheet, so avoid it if some sections were intentionally kept out of sight. Unhiding a column does not restore a previous custom width in every situation; if a column appears to be missing even after you choose Unhide, check whether its width has been set very small and adjust the column boundary.

When the shortcut does not work

First check that the workbook is in an editable state and that the intended column headings are selected. A protected worksheet may restrict formatting or structural changes, and a view-only workbook will not let you change the sheet. If you have permission to edit but the keyboard command appears to do nothing, try the Home ribbon path or the heading’s right-click menu. A browser may use a key combination for its own interface, and browser behavior can vary.

It zooms the browser instead: use the ribbon command instead of repeatedly pressing Ctrl+0.
Nothing is selected: click the column letter, not just a cell, and try again.
The command is unavailable: check whether you have edit access and whether sheet protection limits changes.
The column still looks missing: look for a narrow column boundary or a hidden neighboring column, then use Unhide.
You are using a Mac: web shortcuts can vary with the browser and keyboard. The ribbon path is a reliable alternative to guessing a desktop Mac shortcut.

Excel Online autosaves changes to a workbook stored in a supported cloud location, but collaborators may see layout changes while working in the same file. If you are changing a shared sheet, consider telling teammates that columns have been hidden so they do not mistake the altered view for deleted data.

Hiding, filtering, and protecting are different

Hide is a display choice: the column remains present, and formulas can still use its values. Filtering changes which rows are shown according to criteria; it does not conceal columns. Grouping creates an expandable outline for columns or rows. Freeze Panes keeps selected rows or columns in view while you scroll; it does not hide anything. Choosing the right feature depends on whether you want to simplify the layout, narrow a list, collapse details, or keep labels visible.

Most importantly, hiding a column is not a privacy or security measure. People with access to the workbook may be able to unhide it, and the data can remain available to formulas, charts, or other workbook features. Do not use Hide as a substitute for removing sensitive information or managing access permissions. If a column should not be shared, use an appropriately restricted copy or workbook, following your organization’s sharing rules.

There is usually no cost or add-in required for this basic worksheet command; it is part of Excel for the web. Access to editing features depends on the account, file permissions, and the workbook’s location. If you cannot edit the sheet, ask the owner for access rather than trying to work around the restriction.

Frequently Asked Questions

What is the hide column shortcut in Excel Online?
On Windows, select the column heading and press Ctrl+0 (zero). If your browser intercepts the shortcut, use Home > Format > Hide & Unhide > Hide Columns.

Does Ctrl+0 delete a column in Excel Online?
No. It hides the selected column from view. The cells and their values remain in the worksheet, and formulas can continue to refer to them. Use Delete or the delete-column command only when you actually intend to remove data and shift the sheet structure.

How do I unhide a column in Excel Online?
Select the visible headings on either side of the hidden column, right-click, and choose Unhide. If column A is hidden, select A:A in the Name Box and use the ribbon’s Unhide Columns command.

Can I hide multiple columns at once?
Yes. Select multiple column headings, including a continuous range or separate columns, and then use Ctrl+0 or the Hide Columns command. Check that the selection includes only the columns you mean to conceal.

Is hiding a column the same as protecting its data?
No. Hiding changes what is visible, not who can access the information. Someone who can edit or inspect the workbook may be able to reveal the column, so use permissions or a separate sanitized file for confidential data.

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.