Hide Columns in Excel on SharePoint Without Deleting Them

How-to basics · Updated November 18, 2026

To hide columns in an Excel workbook stored on SharePoint, open the workbook in Excel for the web or the desktop app, select the column letter or letters, then choose Home > Format > Hide & Unhide > Hide Columns in desktop Excel. In Excel for the web, right-click a selected column heading and choose Hide. Hiding keeps the data in the workbook but removes those columns from the current sheet view; it does not protect the data from people who can access the file.

SharePoint stores and shares the workbook, while Excel supplies the editing tools. The steps below cover Microsoft 365 on Windows and note where the web and Mac experiences differ. If your goal is to keep information confidential rather than make a sheet easier to read, use appropriate file permissions or remove the information instead of relying on hidden columns.

What You’ll Need

  • Access to the Excel workbook in SharePoint. To save a change for everyone, you generally need permission to edit the file.
  • A supported browser for Excel for the web, or Excel for Microsoft 365 on Windows. You can also open the file in Excel for Mac; the basic column commands are similar.
  • The name of the worksheet and the columns you want to hide. If the workbook is important, confirm that you can restore a previous version before making broad changes.

Step-by-Step

  1. Open the workbook from SharePoint.

    Go to the SharePoint site or document library that contains the file, then select the workbook. It may open in Excel for the web in your browser. If you prefer desktop Excel, use the available Open in Desktop App command. The exact wording or location can vary with the SharePoint layout and your organization’s settings. Check that you have opened the right workbook, especially if the library contains similarly named copies.

  2. Choose the worksheet that contains the columns.

    Use the sheet tabs at the bottom of the workbook to open the correct worksheet. Hiding a column affects the active sheet, not every sheet in the workbook. If you are not sure which sheet is correct, check the labels and nearby headings before changing anything. In a workbook with several related sheets, you may need to repeat the process on each one.

  3. Select the column or columns.

    Click the letter at the top of a column, such as C, to select that entire column. To select a continuous group, click the first column letter and drag across the headings, or select the first heading and Shift-click the last. For example, selecting D through F targets three adjacent columns. If you only select cells inside the grid, the hide command may not apply to the whole column as intended, so use the column letters.

  4. Hide the selected columns in Excel for the web.

    Right-click one of the selected column letters and choose Hide from the context menu. The selected columns should disappear, and the column letters on either side will no longer be consecutive. If your browser does not show the menu on a standard right-click, try a two-finger click or the equivalent context-menu gesture for your device. You can also open the workbook in desktop Excel and use the ribbon path in the next step.

  5. Hide the selected columns in desktop Excel for Windows.

    With the columns selected, choose Home > Format > Hide & Unhide > Hide Columns. You can also right-click the selected column heading and choose Hide. In Excel for Mac, select the column headings and use the same right-click menu where available, or look under Home > Format for the hide command. Ribbon labels can differ slightly by app version, so the column-heading context menu is a useful alternative.

  6. Confirm the change is saved and visible as expected.

    In Excel for the web, changes usually save automatically; wait for the save status to finish before closing the tab. In desktop Excel, check that AutoSave is on for the SharePoint file or save the workbook with Ctrl+S on Windows. On Mac, use Command+S. If other people are editing at the same time, give the workbook a moment to sync, then check the sheet again. Ask a collaborator to refresh or reopen the file if they do not see the updated layout.

  7. Unhide the columns when they are needed again.

    Select the column headings on both sides of the hidden group. For example, if D and E are hidden, select C and F, right-click the selected headings, and choose Unhide. In Windows desktop Excel, you can instead select the neighboring columns and choose Home > Format > Hide & Unhide > Unhide Columns. If the hidden columns are at the edge of the sheet, or you cannot tell which letters are missing, select the whole worksheet using the small triangle above row 1 and left of column A, then choose the unhide command.

Common Mistakes

Assuming hidden means private. Hiding changes what is displayed, not who can access the underlying values. Someone with access to the workbook may be able to unhide the columns, copy the sheet, or inspect the data in another way. Do not use this feature to conceal payroll, personal details, passwords, or other sensitive information from workbook readers. Use SharePoint permissions to limit access to the file, or remove data that should not be included.

Selecting cells instead of column headings. The lettered headings identify whole columns. Selecting a few cells and choosing a hide command can produce a different result or leave the rest of the column visible. Confirm that the entire column is highlighted before hiding it.

Changing the wrong sheet or workbook. A hidden column can be easy to miss, particularly when several similar files are open. Check the filename and sheet tab before editing, and tell collaborators what you changed if the workbook is shared. Also check whether a filter, grouped columns, or a frozen pane is affecting what you see; those features are not the same as hiding a column.

Forgetting that the change may affect collaborators. A standard hide or unhide is a workbook layout change, not a personal display setting. Other editors may see the changed layout after it syncs. If you only need a personal way to inspect data, check whether Sheet View is available under the View tab and use a separate view where appropriate; do not assume a normal hide command is private to you.

Tips

  • Keep a record of hidden fields. Add a short note in a separate documentation area or team instructions naming the hidden columns and explaining why they are hidden. This is helpful when a colleague later needs to restore them.
  • Hide only what improves the reading experience. For a report, columns containing helper calculations or secondary identifiers may be distracting. Leave the columns needed to interpret visible totals and labels in view, so readers do not have to guess what a number represents.
  • Use grouping when readers should expand details themselves. If people regularly need to switch between a summary and its detail columns, consider grouping columns with Excel’s outline controls instead of repeatedly hiding and unhiding them. In desktop Excel, select the columns and look under Data > Group. Confirm that the feature is available in your web editing experience before relying on it there.
  • Make a copy before a large layout change. For a small, reversible hide operation, a copy is usually unnecessary. For a complex workbook or a change affecting many sheets, use SharePoint’s version history or save a separate working copy first. This gives you a recovery option if you change the wrong columns.
  • Coordinate with people editing the file. If collaborators are entering data or presenting the sheet, let them know before changing the layout. A hidden column can make a form-like worksheet confusing if users expect to see every field. After hiding columns, review the sheet at the same zoom level and window width your team commonly uses.

Troubleshooting

The Hide command is missing or unavailable. Make sure you selected a column heading, not a cell, and check that the workbook is not in a read-only state. If you have view-only permission, ask the file owner for edit access or ask them to make and save the change. In the browser, try opening the workbook in Excel for the web rather than a preview pane; previews may not offer the full editing commands.

The columns disappear but return after reopening. Check that the workbook finished saving before you closed it. In desktop Excel, confirm AutoSave is enabled for the SharePoint workbook or press Ctrl+S on Windows (Command+S on Mac). If you lack editing permission, the change may not be saved. Reopen the file from the SharePoint library and check its current state rather than relying on an older browser tab.

You cannot find or restore a hidden column. Look at the letters above the grid for a gap, then select the headings on either side and use Unhide. If the first column is hidden, selecting only the visible neighbor may not be obvious; select the whole sheet using the corner button above row 1 and left of column A, then use the unhide command. If columns remain missing, check whether a group is collapsed or the worksheet has a filter, since those can make data appear absent without the columns being hidden.

A collaborator sees a different layout. Allow time for sync, then ask them to refresh or reopen the workbook. Check that both people are looking at the same file and worksheet. If the workbook is open in multiple sessions, one person’s unsaved changes or another editor’s later action may affect the result. Coordinate edits and review the saved workbook in SharePoint to confirm the final layout.

The sheet is protected. Worksheet protection can prevent users from changing column visibility. If you are authorized to edit the layout, ask the workbook owner to unprotect the sheet or provide the required password. Do not try to bypass protection; the owner should decide whether to change the protection settings and then save the workbook.

Frequently Asked Questions

Does hiding a column delete its data?
No. Hiding changes the display only. The cells and their values remain in the worksheet and may still be included in formulas, charts, or other workbook features.

Can other people unhide columns in a SharePoint workbook?
People with suitable access may be able to unhide them, particularly if they can edit the workbook. Hiding is not a security control. Use SharePoint access permissions to control who can open the file.

Can I hide several columns at once?
Yes. Select the headings for all the columns you want to hide, then use the Hide command. For a continuous range, select the first and last headings with Shift. To hide separate, nonadjacent columns, select each heading while holding the multi-select key supported by your Excel version, or hide each column separately.

Will hiding a column affect formulas?
Usually, formulas continue to calculate using cells in hidden columns. Hiding does not remove a reference or change a formula. However, a formula or chart may behave differently if you edit or delete the underlying cells, so hide rather than delete when you want to keep the data available.

Can I hide columns for just myself?
A normal hide command changes the workbook’s layout and may be seen by collaborators. If your Excel version offers Sheet View, check the View tab for that feature and use a separate view for personal analysis where supported. The exact behavior depends on the available Excel version and workbook settings.

Can I do this in a SharePoint list?
A SharePoint list is not an Excel worksheet, even if you export its data to Excel. In a list, change the view or list-column settings instead. To hide columns in an Excel workbook, open the workbook itself in Excel for the web or desktop Excel and follow the steps above.

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.