To hide columns in Excel for the web, select the column letter or letters, right-click the selection, and choose Hide. The columns disappear from the sheet without deleting their contents. You can bring them back later with Unhide. You need an editable workbook open in a browser; hiding columns changes the sheet’s layout, not the underlying data or who can access it.
What You’ll Need
- A workbook open in Excel for the web, signed in to an account with permission to edit it. If you only have view access, ask the owner for editing permission or request that they make the change.
- A mouse, trackpad, or other way to select column headings. The steps below use the column letters at the top of the worksheet.
- A clear idea of which columns to hide. If the workbook is shared, consider whether other editors rely on those columns being visible.
Excel for the web usually saves edits automatically, so you generally do not need to use a separate Save command. Wait for the workbook to finish saving before closing the browser tab, especially if your connection is unstable. The menu wording and placement can vary slightly as Microsoft updates the web interface, but the right-click Hide and Unhide commands are the practical route.
Step-by-Step
- Open the correct workbook and worksheet. Go to Microsoft 365 in your browser, open the workbook, and choose the worksheet tab that contains the columns you want to hide. If the file opens in view-only mode, you may be able to inspect it but not change its layout. Check the workbook’s sharing permissions before proceeding.
- Find the column headings. At the top of the grid, each column has a letter, such as A, B, or C. Click the letter for the column you want to hide. Clicking a cell in the column selects a cell, not the whole column, so make sure the highlighted selection includes the letter heading and the full column.
- Select more than one column if needed. For a continuous block, click the first column letter, hold the mouse button, and drag across the other column letters. You can also click the first heading, hold Shift, and click the last heading in the range. To select separate, nonadjacent columns, hold Ctrl while clicking each column heading on Windows; in a Mac browser, use Command-click where supported. If the browser or device handles that key differently, hide each column separately instead.
- Open the column menu. Right-click one of the selected column letters. On a touch device or trackpad without a right mouse button, use the device’s secondary-click gesture, such as a two-finger tap, or open the relevant menu using the available controls. Check that the menu belongs to the column heading, not to a cell or worksheet tab.
- Choose Hide. Select Hide from the context menu. The selected columns disappear, and the remaining columns close the visible gap. Their data, formulas, and formatting remain in the workbook; hiding only changes what is displayed on the sheet.
- Check that the intended columns were hidden. Look at the letters above the grid. The sequence will skip the hidden letters, and a small boundary or indicator may appear between the visible columns on either side. For example, if column C is hidden, you may see A, B, and then D. If the wrong area vanished, use Undo immediately or unhide the affected columns and repeat the selection carefully.
- Confirm the workbook has saved. Excel for the web normally saves changes as you work. Look for the saving or saved status near the workbook name, if shown, and allow it to finish before leaving the page. In a shared workbook, other editors may see the changed layout as well. Tell collaborators if the hidden columns are important to their work.
You can also use the ribbon if you prefer not to use a context menu. Select the column heading or headings, open Home > Format > Hide & Unhide > Hide Columns, and confirm that the selected columns disappear. If the ribbon is condensed, expand it or look for the Format control on the Home tab. The right-click method is often quicker, but both methods hide the selected columns rather than deleting them.
Common Mistakes
Selecting cells instead of column headings: If you click inside a cell and then choose a command, you may not have selected the whole column. Start by clicking its letter at the top of the grid. For a full-column selection, the column heading should be highlighted.
Choosing Delete instead of Hide: Delete removes cells or data and can affect formulas and the surrounding sheet. Hide simply conceals the selected columns. Read the context-menu choice before clicking, particularly when the workbook contains important records.
Assuming hidden means protected: Hiding a column is not a security measure. Someone who can edit or inspect the workbook may be able to unhide it, and formulas or charts may still use its contents. Do not use Hide to conceal confidential information from people who can access the file.
Hiding a column in the wrong worksheet: Each worksheet has its own columns and layout. Verify the worksheet tab before making a change, especially in workbooks with similarly named sheets such as Current, Archive, and Summary.
Expecting the hidden data to stop affecting results: A hidden column is still part of the workbook. Calculations, filters, charts, and references can continue to use its values. Hide columns to reduce visual clutter, not to remove data from calculations.
Tips
Hide only the columns that readers do not need for the current task. For example, a report might show product names and totals while hiding internal codes or intermediate calculation columns. Keep in mind that anyone with access may restore the hidden columns, so this is a presentation choice, not a way to create separate versions of the data.
When hiding a group, check both ends of the selection before you choose Hide. A common efficient approach is to select the first heading, Shift-click the last heading, and inspect the highlighted range. This is especially useful in wide sheets where a drag can stop one column too early or continue farther than intended.
If you expect to show the columns again, make a note of their letters or purpose before hiding them. This helps when the worksheet has many columns or several separate hidden ranges. You can also add a brief note in a visible cell or document the layout for coworkers, provided that doing so fits the workbook’s conventions.
For a temporary view, hiding is convenient because it leaves the data in place. If you only want to change what you personally see without affecting other editors, check whether your workbook offers a sheet view or personal view appropriate to your account and file. Shared-workbook features vary, so do not assume a hide action is private; it can change the worksheet layout for collaborators.
Use the Undo control or Ctrl+Z on Windows if you hide the wrong columns and have not made other changes since. In a Mac browser, the equivalent is typically Command+Z. Keyboard behavior can depend on the browser and settings, so the on-screen Undo control is a useful alternative. Undo reverses the most recent action, which may not be the hide command if you have already made other edits.
Troubleshooting
The Hide command is missing or unavailable: First confirm that you selected a column heading rather than a cell, and that you are not viewing the workbook in read-only mode. If you have view access, request edit permission. If the selection is valid but the context menu is limited, try the ribbon path Home > Format > Hide & Unhide > Hide Columns.
The columns did not disappear: Check whether the selection was actually a column selection and whether the Hide command was applied. Try selecting the letter headings again and use the ribbon command. If the workbook is still saving, wait a moment and check the sheet again. A browser refresh should be a last resort; first confirm that the changes have saved so you do not lose other edits.
You cannot tell which columns are hidden: Look for a jump in the column letters, such as B followed by E, or a narrow boundary between headings. The missing letters indicate the hidden range. If you are unsure, select the visible headings on either side and use Unhide; you can then hide only the columns you intended.
You cannot unhide a column at the far left or right: For a hidden column between visible columns, select the headings on both sides, right-click, and choose Unhide. At an edge, there may not be a visible heading on one side to select. Use the Name Box beside the formula bar to enter the column reference, such as A:A, press Enter, and then use Home > Format > Hide & Unhide > Unhide Columns. If the Name Box is not visible, expand the ribbon or formula-bar area.
A coworker still sees a different layout: Confirm that both of you are viewing the same workbook and worksheet, and allow time for the shared workbook to update. Also check whether the coworker is using a personal sheet view, if available, because a view setting may affect what that person sees. If visibility matters to a team, agree on the intended layout rather than assuming each editor has a private version.
Frequently Asked Questions
Can I hide several columns at once in Excel for the web?
Yes. Select a continuous range by dragging across its headings or by clicking the first and Shift-clicking the last. Then right-click the selected headings and choose Hide. You can hide separate columns one at a time if selecting them together is awkward.
How do I unhide columns 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 a hidden column is at the edge of the sheet, use the Name Box to select its column reference first.
Does hiding a column delete its data?
No. Hide changes the column’s visibility, not its contents. Values, formulas, and formatting remain in the workbook, and formulas may continue to use those values. Choose a delete command only if you intend to remove cells or data.
Can other people see columns I hide?
In a shared workbook, a hide action can affect the worksheet layout other editors see. It is not a private concealment or a permission control. If collaborators need different views, check whether a suitable personal sheet view is available and coordinate before changing the shared layout.
Can I hide columns in Excel for the web on a phone or tablet?
The web app can be used on some mobile browsers, but the ribbon and secondary-click controls may be more limited than on a computer. If you cannot access the column menu, try the Excel mobile app or open the workbook in a desktop browser, then select the column heading and use Hide.
Related
- Excel SUBTOTAL Count: Count Visible Cells Correctly
- Text Split in Excel: Polish Menus and Methods
- Text Split in Excel: How to Separate Data into Columns
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Freeze Panes: Unfreeze Rows and ColumnsTo remove frozen rows or columns in Excel for Microsoft 365 on Windows, select the worksheet, then choose…
- Automate Text to Columns in Excel: Methods and LimitsYes—but Excel’s Text to Columns command does not automatically repeat itself whenever new data arrives. For a one-time…
- How to Add Page Numbers in Word Documents, Step by StepTo add page numbers in Word for Microsoft 365 on Windows, open the document and select Insert >…
- How to Set Up Auto Forward in Outlook for MacTo automatically forward every new message from Outlook for Mac, open your mailbox in Outlook on the web,…
- Why Can’t I Add a Header in Word?You usually can’t add a header in Word because the document is not currently editable, editing is restricted,…
- Insert Outlook Email Into Excel: Methods That WorkYes. In Excel for Microsoft 365 on Windows, you can put Outlook email information in cells by copying…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.