How to Hide Columns in Excel Only for You Using Sheet Views

How-to basics · Updated November 18, 2026

To hide columns in a shared Excel workbook only for yourself, create a personal Sheet View first, then select the column headers and choose Home > Format > Hide & Unhide > Hide Columns. The hidden columns stay out of your view without changing the layout coworkers see in their own views. This works best with a workbook saved to OneDrive or SharePoint and opened in a current version of Excel.

What You’ll Need

  • A version of Microsoft Excel that supports Sheet Views, such as Excel for Microsoft 365 on Windows, Mac, or the web.
  • A workbook saved in OneDrive or SharePoint. Sheet Views are designed for cloud-based workbooks, particularly when people are coauthoring.
  • Permission to edit the workbook, so you can create a view and change its display settings. You do not need permission to change other people’s personal views.

Hiding columns is a display choice, not a way to protect information. Anyone with access to the workbook may still be able to unhide the columns or open another view that displays them. If the workbook is stored only on your computer, you can hide columns normally, but there is no shared-workbook benefit to making the change personal.

Step-by-Step

  1. Open the cloud copy of the workbook. Open the file from its OneDrive or SharePoint location rather than an older download or a separate local copy. If you are unsure which copy is current, check the file location shown in Excel or open it from the shared link. Sheet Views apply to the workbook in the cloud, so changing a downloaded duplicate will not change the shared file.
  2. Open the worksheet you want to adjust. Sheet Views are specific to a worksheet. Select the tab at the bottom of the Excel window that contains the columns you want to hide. If your workbook has several sheets, you will need to set up a view on each sheet where you want a different personal layout.
  3. Create a Sheet View before hiding anything. In Excel for Microsoft 365 on Windows, select View > Sheet View > New. Excel switches the active worksheet into a view separate from the default sheet view. The Sheet View controls should indicate that you are no longer simply working in the default view. Do this before hiding columns; otherwise, the hide action may change the shared default layout.
  4. Save or keep the new view if Excel offers that option. Some versions initially label a new view as a temporary view and show a Keep button on the View tab. Select Keep and, if prompted, give the view a useful name such as “Compact view” or “Review without notes.” If your version saves the view automatically, check the Sheet View menu to confirm that it is listed. A named view is easier to find again than a temporary one.
  5. Select the columns by their lettered headers. Click the letter at the top of the first column you want to hide. To select a block of adjacent columns, hold the mouse button and drag across the column letters, or click the first letter and Shift-click the last. For example, selecting D through F highlights all three full columns. Selecting the headers is more reliable than selecting cells within the columns, which may not give you the intended whole-column result.
  6. Hide the selected columns while the Sheet View is active. Choose Home > Format > Hide & Unhide > Hide Columns. You can also right-click one of the selected column letters and choose Hide. The selected columns disappear from the worksheet. Because you created a Sheet View first, this is a change to that view’s layout rather than a request to hide them in the default view.
  7. Check the result in the view you created. Confirm that the intended columns are gone and that the columns on either side remain visible. Then open the View > Sheet View menu and check that your personal view is selected. If you need a broader or narrower selection, unhide or adjust the columns while you are still in that view.
  8. Exit the view when you want to return to the shared layout. Use View > Sheet View > Exit, or select the Exit control if it appears on the ribbon. The worksheet returns to its default view, where the columns should be visible unless someone has hidden them in that shared view. To use your personal arrangement later, select it from the Sheet View menu again.

Excel for Mac and Excel for the web also provide Sheet Views in supported Microsoft 365 workbooks. The precise ribbon layout can differ, but look under View > Sheet View for New, the active view, and the option to exit. If you do not see Sheet View, confirm that you opened the cloud-hosted workbook in a supported Excel version. The ordinary hide command may still be available, but using it without an active personal view can affect the default layout.

Common Mistakes

Hiding columns before creating a Sheet View: This is the main reason the columns disappear for everyone. If you are in the default view, using Hide can change the shared layout. Create and select your personal view first, then hide the columns.

Assuming a hidden column is private or protected: Hiding affects what is displayed; it does not remove data, restrict access, or encrypt the workbook. Do not use it to conceal confidential information from people who can open the file. Use appropriate access controls or remove information that should not be shared.

Editing the wrong copy or worksheet: A downloaded copy may not be the live shared workbook, and each worksheet has its own view settings. Check the file location and active sheet tab before making changes.

Leaving a temporary view unsaved: If Excel labels the view as temporary or offers a Keep button, do not assume it will remain available indefinitely. Keep it and give it a recognizable name, then confirm that it appears in the Sheet View list.

Tips

Name views for the task they support, not just for the columns they hide. “Monthly review” or “Data entry” is more useful than “View 2” when you return to the workbook later. If several coworkers create views, a clear name also helps you distinguish yours from theirs.

Hide only columns that are distracting or unnecessary for your current task. For example, you might hide internal reference notes while reviewing a wide sales table, or hide calculation columns while entering information. Keep in mind that another user may still see those columns in their own view, and you may need to unhide them when comparing the full dataset.

Before closing the workbook, make sure the view is kept or saved and that you can select it again from View > Sheet View. If you often switch between a personal layout and the shared default, learn where Exit is in your Excel version. This avoids mistaking the default view for a failed personal view.

Sheet Views separate display changes, such as hiding columns, from the layout other collaborators use. They do not make ordinary workbook edits private. Changes to cell contents are still changes to the shared workbook, so treat edits to values and formulas as collaborative edits.

Troubleshooting

Sheet View is missing or unavailable: First confirm that the workbook is saved in OneDrive or SharePoint and that you are signed in to the account with access to it. Then try opening it in a current version of Excel for Microsoft 365 or Excel for the web. If you opened a read-only copy, an attachment, or a local download, open the cloud-hosted file instead. Your organization may also manage which Excel features are available.

The columns disappeared for coworkers too: You may have hidden them while the default view was active. If you have permission, restore them in the default view by selecting the columns on either side of the hidden range, right-clicking the selected headers, and choosing Unhide. Alternatively, use Home > Format > Hide & Unhide > Unhide Columns. Then create or select your personal Sheet View and hide them there. If coworkers are actively editing the workbook, coordinate before changing the shared layout back.

The columns are still visible in your view: Check that the correct Sheet View is active, that you selected the column letters rather than a few cells, and that the intended worksheet is open. Select the headers again and use the Hide command. If the view was temporary, keep it before leaving so the change is available when you return.

You cannot find the hidden columns to restore them: Hidden columns are indicated by a break in the sequence of column letters. Select the headers on both sides of that break, right-click, and choose Unhide. If the hidden range is at the left or right edge of the sheet, select the whole worksheet using the triangle above row 1 and to the left of column A, then use the Unhide command. This may reveal other hidden columns on that sheet too, so check the layout afterward.

Your view seems to have vanished: Reopen the same cloud workbook and worksheet, then look under View > Sheet View for the saved name. Check that you did not open a duplicate file or switch to another worksheet. If the view was temporary and was not kept, create a new one and repeat the hide steps.

Frequently Asked Questions

Can I hide columns just for myself in a workbook I share?
Yes, if the workbook and your Excel version support Sheet Views. Create your own view, hide the columns while that view is active, and keep the view if Excel asks. This changes your displayed layout, not the default layout coworkers use.

Will coworkers see the columns if they open my Sheet View?
A Sheet View is a personal view, but views can be available to other people using the workbook. Do not treat it as a privacy barrier: someone with workbook access may be able to select a view or unhide columns. The key benefit is that your hide action does not change the default layout for everyone.

Do changes to cell values stay personal too?
No. Sheet Views make certain display and analysis settings personal, but they do not create a private copy of the data. Editing a cell in a shared workbook changes the workbook itself and may be visible to collaborators.

Can I hide several columns at once?
Yes. Select multiple column headers, including a continuous range such as D through F, and choose Hide Columns. For separate ranges, select the headers while holding Ctrl on Windows or Command on Mac if your Excel version allows the multi-selection, then use the hide command. If that selection is difficult, hide one range at a time within the same active view.

How do I make the columns visible again only in my view?
Select your personal Sheet View, select the column headers on both sides of the hidden columns, and choose Unhide. Do not exit to the default view before doing this, or you may change the shared layout instead.

Can I do this in Excel for the web or on a Mac?
Yes, when Sheet Views are available for the workbook. Look for View > Sheet View and create or select a view before hiding columns. Ribbon placement and labels can vary slightly by platform and update, so verify that your personal view is active before using Hide.

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.