How to Hide Columns in Excel for the Web: Steps & Tips

How-to basics · Updated November 18, 2026

To hide columns in Excel for the web, select the column letter or letters, right-click the selection, and choose Hide. You can also use Home > Format > Hide & Unhide > Hide Columns. The columns disappear from the worksheet without being deleted, and you can unhide them later. Before you begin, make sure you have editing access if you want the change saved to the shared workbook.

What You’ll Need

  • A workbook open in Excel for the web in a supported browser.
  • Edit permission for the workbook if you need to save the hidden-column change for other collaborators. If you only have view permission, ask the owner to grant editing access or hide the columns in a copy you can edit.
  • The column letters or range you want to hide. Check the selection carefully, especially if the sheet contains sensitive or important data.

Step-by-Step

  1. Open the workbook. Go to Microsoft 365 or OneDrive, open the workbook, and choose to edit it in Excel for the web if prompted. Wait for the sheet to load and for any existing edits to finish saving. If the workbook opens in read-only mode, you may be able to view its contents but not save a layout change to the original file.
  2. Find the columns you want to hide. Column letters appear across the top of the worksheet, such as A, B, and C. Identify the exact column or group by checking its header and a few cells beneath it. Hiding a column changes only what is displayed; it does not remove its data.
  3. Select one column. Click its letter at the top of the sheet. The entire column should become selected, rather than just one cell. For instance, click the letter D to select column D. Avoid clicking a cell in the grid if your goal is to hide the whole column, because the ribbon command may then behave differently or be unavailable.
  4. Select multiple columns if needed. For columns next to each other, click the first letter and drag across the column headings, or click the first heading and Shift-click the last. To select separate columns, use Ctrl-click on Windows where supported by your browser. If Ctrl-click changes the selection unexpectedly, hide each separate column individually instead. Confirm that every selected heading is highlighted before continuing.
  5. Hide the selection with the context menu. Right-click one of the selected column letters and choose Hide from the menu. If you selected several adjacent columns, the command hides all of them together. The headings and their contents disappear, and the visible column letters will jump over the hidden range; for example, the sheet may show C followed by F when D and E are hidden.
  6. Or use the ribbon. Keep the column or columns selected, open the Home tab, choose Format, point to or open Hide & Unhide, and select Hide Columns. Ribbon layouts can vary slightly with window size, so maximize the browser or use the Home tab’s search box if you cannot see Format. The menu route is useful when a right-click menu is unavailable.
  7. Check the result. Look at the column letters on either side of the hidden range. A small gap or paired boundary lines between headings can indicate that one or more columns are hidden. If the target data is still visible, check whether you selected the column heading rather than a cell, then repeat the hide command.
  8. Let Excel save the change. Excel for the web usually saves workbook edits automatically, but allow the save indicator to finish before closing the tab or moving to another task. If other people are using the same workbook, remember that hiding columns changes the workbook’s shared view; it is not a private display setting. Tell collaborators if the change could affect their work.

Common Mistakes

Hiding a cell instead of a whole column: Clicking inside the grid selects a cell, not the full column. Select the letter heading at the top, then check that the column is highlighted from top to bottom before choosing Hide.

Assuming hidden means deleted or protected: Hidden cells remain in the workbook. Formulas can still refer to their values, and another editor can unhide the columns. Hiding is useful for simplifying a view, but it is not a way to secure confidential information. Do not share a workbook with data that recipients should not be able to access.

Selecting the wrong range: A drag across headings can start or end one column away from the intended range. Verify the highlighted letters before hiding, particularly if the columns contain identifiers, dates, or figures used elsewhere on the sheet.

Expecting the change to stay private: In a shared workbook, hiding a column can affect what collaborators see, and their actions may change the workbook layout too. If you need a personal view, consider making a separate copy, provided you have permission to do so, rather than changing the shared file.

Confusing hidden columns with narrow columns: A column can look missing because its width is extremely small. If there is no clear gap in the column letters, drag the boundary between headings to widen it, or select the neighboring headings and use Unhide Columns.

Tips

  • Use hiding for temporary decluttering. It works well when a worksheet has supporting calculations, reference codes, or notes that are not needed in the current view. Keep the information available without letting it take up screen space.
  • Record what you hid. If you hide several ranges in a complex sheet, add a note in an appropriate visible area or keep a list of the column letters. This makes it easier for you or a teammate to restore the worksheet later.
  • Hide adjacent columns together. Selecting one continuous range and hiding it in one action is quicker than repeating the command for every column. For separate ranges, work one range at a time and verify each result.
  • Use clear headers and workbook notes. A visible note such as Supporting calculations are hidden can help collaborators understand why the column letters skip. Do not put private information in the note if the workbook is shared.
  • Consider whether grouping is a better fit. If users will repeatedly show and hide a set of detail columns, a collapsible outline or group may be more convenient than hiding the range manually. The available grouping controls can depend on the workbook and Excel for the web features enabled for your account.
  • Remember that hiding does not change the data. It does not remove values from formulas or turn them into blanks. If a total or other result seems unexpected after hiding a column, inspect the formula and its referenced cells rather than assuming the hidden data stopped counting.

Troubleshooting

The Hide command is missing or disabled. First click a column letter so an entire column is selected. If you selected a cell, the menu may not offer the expected column command. If the workbook is in view-only mode, request edit access or use an editable copy. A protected sheet can also restrict structural changes; if you are authorized, ask the workbook owner to adjust the protection or make the change.

The columns do not disappear. Check that the selection includes the column headings, then use either the right-click Hide command or Home > Format > Hide & Unhide > Hide Columns. If the column still appears, look for a very narrow width rather than a hidden state. You can drag the column boundary to make it wider and check whether its contents return.

You cannot find the hidden columns to restore them. Select the visible column heading immediately to the left and right of the hidden range, right-click the selection, and choose Unhide. Alternatively, use Home > Format > Hide & Unhide > Unhide Columns. If the first column is hidden and there is no left-hand heading to select, select the worksheet using the corner button above row 1 and left of column A, then use the ribbon’s Unhide Columns command. This may reveal every hidden column, so check the sheet afterward.

The change seems to disappear or does not reach collaborators. Wait for Excel’s save status to complete and confirm you are editing the intended workbook, not a downloaded copy or a read-only view. Refresh only after checking that your latest edits have saved. For a shared workbook, ask a collaborator whether they have changed the view or restored the columns; simultaneous editing can account for a layout change.

The ribbon looks different. Excel for the web may rearrange commands when the browser window is narrow. Expand the window, open the Home tab, and look under Format for Hide & Unhide. You can also use the context menu by right-clicking the selected column letter. If a browser intercepts right-click, use the ribbon route instead.

Frequently Asked Questions

Can I hide more than one column at once?
Yes. Select a continuous range by dragging across its column letters or using Shift-click, then choose Hide. For nonadjacent columns, Ctrl-click may work in your browser; otherwise, hide each range separately.

How do I unhide a column in Excel for the web?
Select the visible column headings on both sides of the hidden range, right-click, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Columns. If the first column is hidden, select the whole worksheet and use the ribbon command.

Will hiding a column change formulas or totals?
No. Hiding a column changes its visibility, not its contents. Formulas that reference its cells can continue to use those values, so check the calculations before interpreting a result.

Can other people see columns I hide?
Yes. Hidden columns are still part of the workbook, and editors can unhide them. In a shared file, the layout change may also be visible to collaborators. Hiding is not a security or privacy control.

Can I hide columns without edit access?
Typically, you need permission to edit the workbook to save a layout change to the shared file. If you have view-only access, ask the owner for permission or use a copy you are allowed to edit.

Does this method work in desktop Excel too?
The basic idea is the same: select column headings and choose Hide or use the ribbon. This guide gives the Excel for the web menu path; desktop ribbon placement can vary slightly by version.

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.