Yes. In Excel for Microsoft 365, create a Sheet View, then hide the columns while that view is active; other people can keep working with the worksheet’s normal view. Sheet Views are for changing how you see a shared sheet, not for making data private, and the workbook generally needs to be saved to OneDrive or SharePoint for the feature to work.
How hiding columns for yourself works
Ordinary column hiding changes the worksheet’s shared layout. If you select column C and choose Hide, colleagues opening the same worksheet can find column C hidden too. A Sheet View gives you a separate view configuration for that worksheet. You can hide columns, filter or sort data in your view without applying those display choices to everyone else’s current view.
The distinction is between the worksheet’s contents and the way those contents are displayed. Hiding a column does not delete its values or formulas. In a Sheet View, the hidden-column setting belongs to that view, while the underlying cells remain in the workbook. If another person edits a cell in the workbook, that edit is still a change to shared data; a personal view does not create a private copy of the cells.
Sheet Views are useful when a shared report contains columns you do not need for your task. For example, a sales worksheet might have Customer, Region, Rep, Revenue, Margin, and Internal Notes columns. You could hide Internal Notes and Margin in your own view while a manager keeps both visible in theirs. This is a convenience for reading and working, not a way to restrict access to sensitive information.
Create a Sheet View and hide columns
In Excel for Microsoft 365 on Windows, first open the shared workbook and go to the worksheet you want to adjust. The workbook should be saved in OneDrive or SharePoint. Then follow these steps:
- Choose View > Sheet View > New. Excel switches the active worksheet into a new Sheet View. The view controls may show that you are in a temporary view.
- Select the column or columns you do not want to see. Click a column letter to select one whole column; drag across column letters or use the selection keys to select a range of adjacent columns.
- Choose Home > Format > Hide & Unhide > Hide Columns, or right-click the selected column letters and choose Hide.
- To keep the view for later, use the Sheet View controls to keep or name it if that option is available in your Excel version. A temporary view may not be retained as a named view when you leave it.
- When you want to return to the worksheet’s regular view, choose View > Sheet View > Exit. Select your saved view again from the Sheet View menu when you want to use it.
The exact controls for keeping, naming, or selecting a view can vary slightly with Excel updates. Look for the Sheet View menu on the View tab, and check that the active view is the one you intend to change before hiding columns. If you hide a column before creating a Sheet View, you may change the ordinary shared view instead.
What coworkers can see in a shared workbook
When you create and use a Sheet View, other people can usually continue to see the worksheet in their own view, rather than having your hide, sort, or filter choices suddenly applied to their screens. They can create their own Sheet Views for their work. A Sheet View is saved as part of the workbook rather than as a secret setting tied only to your computer, so someone with access to the file may be able to see or select named views.
That difference matters for privacy. Hiding a column is not a security feature: a person with permission to use the workbook may be able to unhide the column or inspect its contents. Do not use a Sheet View to conceal salaries, customer details, or other restricted information from people who already have workbook access. Use appropriate file permissions or remove information from a shared copy when access must be limited.
Also keep in mind that not every workbook action is personal. Editing a cell changes shared workbook data. A Sheet View is intended for view-level choices, such as hiding columns and working with sorts or filters, rather than for separating edits or creating an isolated version of the worksheet. Before making a substantial change, check whether it is a display choice or a change to the actual data.
Using Sheet Views in Excel for the web and Mac
Excel for the web also supports Sheet Views for compatible workbooks. Open the workbook in a browser, choose the View tab, and look for Sheet View and its option to create a new view. Once the view is active, select the columns and use the Home tab’s formatting controls or the column context menu to hide them. The web interface can place controls differently from the Windows desktop app, but the principle is the same: create or enter the view first, then hide the columns.
Current Excel for Mac versions include Sheet View support for compatible cloud workbooks. Look on the View tab for the Sheet View controls; the names or placement can differ a little by update. If you do not see the feature, check that Excel is up to date and that the workbook is stored in OneDrive or SharePoint. Ordinary hide and unhide commands are available on Mac too, but using those commands outside a Sheet View can affect the shared worksheet view.
When people use different Excel versions, they may see different menus or may not have the same Sheet View support. If collaborators need to preserve separate views, ask them to open the workbook in a current supported Excel app or Excel for the web. If that is not possible, use a separate copy or a separate worksheet for the alternate layout instead of assuming a normal hide operation will be personal.
If Sheet View is missing or columns still affect others
The most common reason the option is unavailable is that the file is not stored in a supported cloud location. A workbook saved only on your computer, a network drive, or another unsupported location may not offer the collaborative Sheet View controls. Save a copy to OneDrive or SharePoint if that is appropriate for your organization, then reopen it and check the View tab. Your organization’s sharing or account settings can also affect what features are available.
If the columns appear hidden for everyone, check whether you created the Sheet View before hiding them. If you did not, the hide command may have changed the default worksheet view. You can unhide the columns in the ordinary view, then create a Sheet View and hide them again there. If you are not sure whether the current view is temporary, named, or the default, use the Sheet View menu to inspect or exit the active view before making further changes.
Another source of confusion is that hiding a column does not make it disappear from the workbook for good. A narrow line between column letters, a gap in the sequence of letters, or a selection that spans the hidden column can indicate that it is still there. In the view where it is hidden, select the columns on both sides and use Home > Format > Hide & Unhide > Unhide Columns, or use the column-header context menu. If the hidden column is at the edge of the sheet, selecting the neighboring column and using the ribbon command may be easier.
Alternatives when you do not have Sheet Views
If you only need a personal arrangement and cannot use Sheet Views, choose an alternative that does not accidentally change the shared sheet:
- Use a separate copy. Save or download a copy and hide columns in that copy. The copy will not automatically reflect later edits to the shared original, so treat it as a snapshot unless you refresh it deliberately.
- Ask for a separate worksheet. A colleague or workbook owner can create a clearly labeled view or report sheet with only the relevant fields. Agree on how it will be updated so it does not become stale.
- Use a filter or a different layout. If your goal is to focus on particular records rather than remove columns from sight, a Sheet View can also hold a filter or sort. Without Sheet Views, remember that ordinary filtering and sorting in a shared sheet may affect other users’ view.
- Leave columns visible and navigate around them. Freeze Panes can keep selected rows or columns in view while you scroll, but it does not hide columns and is not a personal substitute for a Sheet View.
Grouping columns with the outline controls is another possible layout aid, but it is not a reliable personal-view workaround in a shared worksheet. Collapsing a group changes the sheet’s displayed state and can be visible to other users. Choose the method according to whether you need a private working copy, a separate report, or simply a different view of shared data.
Frequently Asked Questions
Can I hide a column in Excel without affecting other users?
Yes, if you create or enter a Sheet View first and hide the column inside that view. Using the regular Hide command in the worksheet’s default view can affect what other users see.
Do I need OneDrive or SharePoint to use Sheet View?
For the collaborative Sheet View feature, the workbook generally needs to be stored in OneDrive or SharePoint. A workbook saved only locally may not show the Sheet View option.
Can coworkers see a Sheet View I create?
They can keep their own view, but a saved Sheet View is part of the workbook and may be available for other people with access to select. It is not a way to hide data from collaborators.
Does hiding a column delete its data?
No. Hiding changes whether the column is displayed in the active view. The cell contents remain in the workbook and may be revealed by unhiding the column.
Why did my hidden columns disappear for everyone?
You may have hidden them in the default worksheet view rather than in a Sheet View. Unhide them in the default view, create a Sheet View, and repeat the hide command while that view is active.
Can I use this for a workbook saved on my computer?
Usually not with the collaborative Sheet View feature. If the option is missing, use a separate copy for your personal layout or move an appropriate copy to OneDrive or SharePoint, subject to your organization’s rules.
Related
- Excel Continually Not Responding? Causes and Fixes
- Excel Named Range to Table: What Works and What Doesn’t
- Excel Consolidated Sum: Combine Data Across Sheets
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Header in ExcelTo add a printable header in Excel for Microsoft 365 on Windows, select the worksheet, choose Insert >…
- IFERROR in Google Sheets: Meaning and How to Use ItIn Google Sheets, IFERROR checks whether a formula produces an error and lets you show a different value…
- Excel Shortcut to the End of Data: Keys and LimitsIn Excel for Microsoft 365 on Windows, press Ctrl+Down Arrow to jump to the edge of the current…
- Indent Within the Same Cell in Excel: Step-by-StepTo indent only one line within an Excel cell, insert a line break with Alt+Enter on Windows, then…
- Excel Data Validation: What Ignore Blank Really MeansYes. In Excel, the Ignore blank checkbox in Data Validation allows an empty cell to pass the rule;…
- How to Remove Data Validation Rules in Google SheetsTo remove data validation in Google Sheets, select the affected cells, open Data > Data validation, then remove…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.