To return a worksheet to Normal view in Excel, click the View tab and click Normal in the Workbook Views group, or click the Normal button on the status bar. View settings apply to one worksheet at a time, so to switch a whole workbook, group the sheets first or run a short macro that switches every sheet.
These steps are for Excel for Microsoft 365 on Windows (also Excel 2024, 2021, 2019 and 2016). On a Mac, the View tab has the same Normal button, and you can also choose View > Normal in the menu bar. The Alt shortcuts and the File > Options paths below are Windows only.
The steps come from Microsoft’s page breaks and Group worksheets articles.
How to Return One Worksheet to Normal View
- Click the sheet tab you want to change.
- Click the View tab.
- Click Normal in the Workbook Views group.

The sheet goes back to the regular editing grid, without the page outlines, margins and rulers of Page Layout view or the shaded areas and page numbers of Page Break Preview. Your data, formulas and print settings don’t change; only the way the sheet is displayed does.
Use the Status Bar or a Shortcut Instead
Microsoft notes you can also click Normal on the status bar. It’s the first of the three small view icons at the bottom right of the window, just left of the zoom slider.
From the keyboard, press and release Alt, then press W, then L. Microsoft’s Excel keyboard shortcuts list includes all three view shortcuts:
| View | Shortcut (press one key at a time) |
|---|---|
| Normal | Alt, W, L |
| Page Layout | Alt, W, P |
| Page Break Preview | Alt, W, I |

Still Seeing Dotted Page-Break Lines?
After you use Page Break Preview or print, page breaks can stay visible in Normal view as dotted lines. They don’t print. To get rid of them:
- If you haven’t saved since they appeared, close the workbook without saving and open it again.
- To hide them for good, click File > Options > Advanced, scroll to Display options for this worksheet, clear Show page breaks, and click OK.
A solid line in Normal view is usually a manual page break, or a frozen pane (see the troubleshooting section below).
If the printed pages look lopsided once you are back in Normal view, you can center the worksheet horizontally and vertically on the page.
How to Put Every Worksheet Back in Normal View
Although the view buttons sit in the Workbook Views group, they only change the sheet you’re on. Here are two ways to handle a whole workbook.
Option 1: Group the Sheets
- Right-click any sheet tab and choose Select All Sheets. The title bar then shows Group after the workbook name.
- Click View > Normal.
- Right-click a sheet tab and choose Ungroup Sheets.
- Click through the tabs to confirm each one switched.
Ungroup right away. While sheets are grouped, any change you make on one sheet is made on all of them. When every sheet is selected, clicking another tab also ungroups them. If some sheets don’t switch, use the macro below.

Option 2: Use a Macro
This VBA code loops through every visible worksheet in the workbook you’re looking at, sets each one to Normal view, and then returns you to the sheet you started on. It skips hidden sheets, which can’t be selected and would stop the macro with an error.
- Save a copy of your workbook first.
- Press Alt + F11 to open the VBA editor.
- Click Insert > Module.
- Paste the code below into the empty module window.
- Press F5 to run it, then close the VBA editor and check your sheet tabs.

Sub ReturnNormalView()
Dim startSheet As Object
Dim ws As Worksheet
Set startSheet = ActiveSheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Visible = xlSheetVisible Then
ws.Activate
ActiveWindow.View = xlNormalView
End If
Next ws
startSheet.Activate
End Sub
To keep the macro in the file, you’ll need to save it as a macro-enabled workbook (.xlsm). If Excel blocks it the next time you open the file, enable macros in Excel. If you’d rather use it on any workbook, store it in your Personal Macro Workbook instead.
What Are the Other Views?
- Normal: the regular editing view for data entry and formulas.
- Page Layout: shows pages with margins, headers and footers, and rulers. You can set column widths in inches here.
- Page Break Preview: shows where each printed page starts and ends. Dashed lines are automatic page breaks and solid lines are ones you added, and you can drag them to move them.
Page Layout and Page Break Preview are useful while you set up printing. Switch back to Normal when you go back to entering data, because some tools, such as Freeze Panes, don’t work in Page Layout view.
Cell gridlines are a separate print setting, and you can print gridlines in Excel when you want them on paper.
When the Sheet Still Doesn’t Look Normal
If the sheet is already in Normal view but something still looks off, one of these is the likely cause:
- The ribbon is gone. Press Ctrl+F1 to show or hide the ribbon. Ctrl+Shift+F1 is the full screen toggle, which also hides the ribbon, so press it if Ctrl+F1 doesn’t bring everything back.
- Rows or columns won’t scroll. The panes are frozen. Click View > Freeze Panes > Unfreeze Panes. There’s more on freezing and unfreezing panes in Excel if you need it.
- The sheet is cut into two or four sections. Click View > Split to turn the split off. The button works as an on/off switch.
- There’s an eye symbol next to the sheet tab. You’re in a Sheet View, a personal view for shared files stored in OneDrive or SharePoint. Microsoft’s Sheet Views article says to click View > Sheet View > Exit to return to the default view.
- Everything is tiny or huge. Click View > 100%, or drag the zoom slider on the status bar.
- The grid lines are missing. Check Gridlines in the Show group on the View tab.
- The Normal button is greyed out. You may be typing in a cell. Press Enter or Esc and try again. The view buttons also aren’t available on a chart sheet, a tab that holds only a chart.
Related Setting: Default View for New Workbooks
In Excel for Windows, open File > Options > General. Under When creating new workbooks, choose the Default view for new sheets setting, such as Normal, Page Layout or Page Break Preview, then select OK. Microsoft’s General options guide describes this default-view setting.
Create a new blank workbook to check it. This preference affects new workbooks only; it does not change worksheets already saved in an existing file, so use the View controls above for those. Choose Normal in the same setting to undo it.
Excel View Questions
Why did Excel open in Page Layout or Page Break Preview?
Views are set per sheet and stay with the workbook. If someone switched a sheet to another view and saved the file, that sheet opens that way until you change it back.
Is there a keyboard shortcut for Normal view?
Yes. Use Alt, W, L: press and release Alt, then press W, then L. It switches the current sheet only.
Does switching to Normal view change how the sheet prints?
No. The view only changes what you see on screen. Margins, page breaks, headers, footers and scaling stay the same, so the printout looks the way it did before.
How do I make the file open in Normal view for everyone?
Switch each sheet to Normal view, then save the workbook. The view is saved with each sheet, so the next person who opens the file sees Normal view.
Why does my sheet still show page outlines after I click Normal?
Those are the dotted page-break lines left over from printing or Page Break Preview. Close the file without saving and reopen it, or clear Show page breaks in File > Options > Advanced.
More Excel Guides
- How to fit a spreadsheet on one page in Excel
- How to repeat rows on every printed page
- How to show the ruler in Excel
- How to put Excel column A on the right side or back on the left

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.