It’s 3:12 PM on a Tuesday. You’re reviewing a sales dashboard with your intern, and she says, ‘Can we save this temporary view so I can come back to it later?’ You pause. You’ve never seen ‘Temporary View’ in the ribbon. You search Help. Nothing. You type it into Google—and get 27 conflicting forum posts.
Quick Answer
‘Temporary view’ isn’t an official Excel feature or setting—it’s a misnomer people use when they mean one of three things: (1) a zoomed-in section of a worksheet they haven’t saved as a Custom View, (2) a filtered or sliced report state they assume persists automatically, or (3) a workbook opened in Protected View or Read-Only mode that *feels* temporary. Excel has no ‘Temporary View’ command, menu, or dialog box—ever.
All the Methods
| Method | Steps | Best For | Limitations |
|---|---|---|---|
| Custom Views | View → Custom Views → Add → name it → OK. Later: View → Custom Views → Show. | Saving specific zoom %, print area, hidden rows/columns, and filter states. | Doesn’t save cell selection, active sheet tab, or formula bar focus. Only works per worksheet. |
| Slicer + Timeline combos | Insert slicer → select fields → right-click → ‘Report Connections’ → link to multiple pivot tables. | Recreating consistent filtered states across dashboards without saving separate files. | Only works with PivotTables or Tables. Doesn’t persist if you close/reopen the file unless saved in the workbook. |
| Zoom + Freeze Panes combo | Select cell B5 → View → Freeze Panes → Freeze Panes → Zoom slider to 125% → Save. | Keeping a focused working area visible while navigating large datasets. | Zoom resets to 100% for new users opening the file. Freeze panes stays—but zoom doesn’t. |
| Workbook Views (Page Layout / Page Break Preview) | View → switch between Normal / Page Layout / Page Break Preview. No save needed. | Quickly checking margins, headers, or break lines before printing. | These views don’t store any user state—they’re just display modes. Switching away discards nothing, but saves nothing either. |
Method 1 Deep Dive
Let’s say you manage regional sales for Acme Corp. Your workbook has four sheets: Q1 Data, Q2 Data, Dashboard, and Summary. On Dashboard, you’ve hidden columns E–G (support metrics), set zoom to 110%, applied an AutoFilter to show only ‘West Region’, and frozen row 1 and column A.
You want to return to *exactly that state* tomorrow. Here’s how Custom Views saves you:
- Select any cell on the Dashboard sheet (say, C1).
- Go to View tab → Custom Views → Add.
- Name it “West Dashboard – Ready to Review”.
- Make sure all boxes are checked: Row and column headings, Hidden rows and columns, Filter settings, Print settings, and Window options (this includes zoom level).
- Click OK. Done.
Later, click Custom Views → select the name → Show. Excel restores everything—including that exact 110% zoom. (Yes, even zoom. That’s the part most people miss.)
Now test it: Close and reopen the file. Go to Custom Views. Your named view is still there. But here’s the counterintuitive bit: Custom Views don’t survive copy-paste to a new workbook. If you copy the Dashboard sheet to a blank file, the view vanishes. It lives with the workbook—not the sheet.
Sample data from Dashboard (A1:F10):
| Region | Rep | Sales | Qtr | Status | Date |
|---|---|---|---|---|---|
| West | Sarah Chen | $45,200 | Q1 | Closed | 2024-03-15 |
| West | Marcus Lee | $38,900 | Q1 | Pending | 2024-03-18 |
| East | Priya Rao | $52,100 | Q1 | Closed | 2024-03-12 |
| West | Jenny Park | $41,600 | Q1 | Closed | 2024-03-20 |
| North | Diego Mora | $33,400 | Q1 | Pending | 2024-03-19 |
Method 2 Deep Dive
Slicers behave like ‘temporary views’ because they let you toggle filters instantly—but unlike Custom Views, they’re tied to data models, not display states. And here’s the surprise: you can assign a keyboard shortcut to toggle a specific slicer. Yes—no macros needed.
Here’s how: Right-click the slicer labeled “Region” → Slicer Settings → check “Display header” → click OK. Then go to Formulas tab → Define Name → Name: ToggleWest → Refers to: =GET.CELL(46,Sheet1!$A$1) — wait, no. That’s outdated. Instead:
The real shortcut method: Select the slicer → press Alt + J + T (opens Slicer Tools → Options tab) → click More Slicer Options → under Layout & Properties, check “Show item labels on hover”. Not helpful? Fair. Here’s what *actually* works:
Press Alt + N + S to insert a new slicer. After inserting, click the slicer → Alt + J + T → Slicer Settings. Now, to quickly reset *all* slicers on the sheet: Alt + A + V + R. That’s Alt → A (Data) → V (Sort & Filter) → R (Clear). It clears filters—including slicer selections.
That’s your ‘temporary view reset’ button. Use it after lunch, before sending the file, or anytime you need to wipe the slate clean. It’s faster than hunting through dropdowns.
Cheat Sheet
| Action | Shortcut / Steps | Notes |
|---|---|---|
| Save current zoom, filters, freeze | View → Custom Views → Add → name → OK | Works per worksheet. Includes zoom level if ‘Window options’ is checked. |
| Restore saved view | View → Custom Views → select → Show | Doesn’t change active sheet—so make sure you’re on the right one first. |
| Clear all slicer filters | Alt + A + V + R | Only works if active cell is inside a Table or PivotTable. |
| Zoom to selection | Select range (e.g., B2:E15) → View → Zoom to Selection | No shortcut, but fast mouse path: Alt+V+Z+S (Alt→V→Z→S). |
| Switch to Page Layout view | Alt + W + P | Useful for checking headers/footers before emailing PDFs. |
