Excel Custom Views Explained: Save & Switch Settings

What You'll Be Able to Do, and One Thing to Check Before You Create Excel Custom Views

You're two minutes from a screen share with your director. Your spreadsheet is wide open: formula columns visible, row 1 filtered to a subset you were debugging, gridlines on, zoom at 80%. You start manually hiding columns, clearing filters, fixing the zoom. You've done this exact routine fourteen times this month. By the end of this article, you won't do it again. Excel custom views let you save a named snapshot of your display settings (hidden rows and columns, filter settings, zoom level, print settings, frozen panes) and switch back to it with three clicks. Build the view once. Apply it forever.

Before you touch anything, check this. If any worksheet in your workbook contains an Excel Table (the kind you create with Insert > Table or Ctrl+T), the Custom Views option will be completely grayed out, not just on that sheet, but across the entire workbook. The fix is to convert your tables to ranges first. Select the table, go to Table Design > Convert to Range, and confirm. Once every sheet is table-free, Custom Views becomes available. I'd rather you know this now than discover it mid-tutorial.

---

Step 1: Save a Custom View in Excel (Capture Exactly the Settings You Want)

The sequence matters here. You have to configure the worksheet the way you want it before you save the view. Excel captures a snapshot of whatever state you're currently in, not a set of rules you define after the fact.

Set everything up first: adjust your column widths, hide the rows and columns your audience doesn't need, apply any filters, set your zoom level, and if this view is going to print, configure your print settings now too. Page orientation, print area, margins, all of it. Once the sheet looks exactly right, do this:

1. Go to the View tab on the ribbon. (If you're new to navigating the ribbon, the View Tab and Workbook Display Options guide covers what's in there.)
2. Click Custom Views in the Workbook Views group.
3. Click Add.
4. Name the view and choose whether to include print settings and hidden rows/columns.
5. Click OK.

Which settings get saved (and which ones don't)

Custom Views save display and print settings tied to the active worksheet: zoom level, row and column visibility, frozen panes, gridline visibility, filter state, and your full print configuration. They do not save cell values, formatting, or formulas. If you change the data after saving a view, the view won't restore the old data, only the visual configuration.

How to name your views so you can actually find them later

Don't name them "View1." I've seen workbooks with six views named "View1" through "View6" and zero documentation. Months later, nobody remembers which was which. Use names that describe the audience and the purpose: Executive_Summary_Print, Working_Detail_AllColumns, Client_Presentation_NoFormulas. Every view name should be defensible. If you can't explain in the name itself who it's for or what it shows, rename it before you forget.

I now maintain two saved views in every client-facing file I build: a "build mode" view with all my working columns visible and filters active, and a "presentation mode" view that's clean, zoomed correctly, and print-ready. Switching between them takes seconds. This habit came directly from a 2016 incident where a report went to a VP with debugging columns still visible. Never again.

---

Step 2: Switch Between Excel Custom Views Without Losing Your Place

Now that you've saved at least one view, applying it is the same path you just used to create it.

1. Go to View > Custom Views.
2. Select the view name from the list.
3. Click Show.

Excel immediately applies every setting captured in that view: filters, hidden columns, zoom, print configuration, all of it. The data hasn't changed. The audience's experience of the data has.

One place this breaks down is shared workbooks. If multiple people are working in the same file and someone changes a filter, your custom view with filters can conflict with what they're doing. That's where Sheet View comes in. Sheet View is a separate feature on the same View tab. Look for it in the Sheet View group, to the left of the Workbook Views group. It lets each user save their own display preferences in a shared file without overwriting anyone else's. The tradeoff: Sheet Views aren't private. Other users can see and apply them. For a private analyst view in a shared workbook, Sheet View is the better tool. For a standalone file you control, Excel custom views give you more complete control over print settings and visibility.

---

Step 3: Delete or Update a Custom View (and Keep Your List Clean)

Excel doesn't have an "edit" button for existing views. If your layout changes and a saved view is out of date, the correct workflow is to reconfigure the sheet the way you want it, go to View > Custom Views, delete the old view, then re-add it with the same name.

To delete: open Custom Views, select the view name, click Delete, and confirm. That's permanent. There's no undo. Worth pausing before you click confirm, especially in a shared file, because a deleted view is gone for every user in the workbook, not just you.

---

Common Mistakes When Using Custom Views in Excel (and How to Sidestep Them)

The grayed-out menu is the most common one, and we covered it up top. Excel Tables anywhere in the workbook kill the option entirely. Convert to ranges first.

The second stumbling point is forgetting that custom views are workbook-wide. When you delete a view, it's gone for everyone who uses that file. If you're working in a shared Excel workbook, coordinate before you start reorganizing the view list.

The third one catches people who are moving fast. If you accidentally leave a filter active that you didn't mean to include (say, you were mid-analysis and saved the view without clearing it), that filter state is now baked into the view. Every time you apply it, that unintended filter comes with it. The fix is simple: clear filters before saving a view unless the filter is specifically part of what that view is supposed to show.

One more thing worth knowing: if keyboard efficiency matters to your workflow, a short Excel interface navigation macro using ActiveWorkbook.CustomViews("ViewName").Show can apply any saved view programmatically. You can even set up a simple Excel VBA loop to cycle through all your views and print each one, useful for batch reporting scenarios where you'd otherwise apply and print manually six times in a row.

Custom Views are underused because most people don't know they exist. Every view you save is a deliberate decision about what your audience needs to see, and what they don't. That's not a convenience setting. That's design thinking. If you're building reports for multiple stakeholders, this feature belongs in your standard workflow. It's covered in the Excel for Beginners starter guide as a foundational display skill, and once you've built it into your process, you'll wonder how you managed without it.

---