Switch Excel Sheet View: Normal, Page Layout, and More

To switch an Excel worksheet’s display mode in Microsoft 365 for Windows, select View, then choose Normal, Page Break Preview, or Page Layout in the Workbook Views group. If you mean a personal view of a shared worksheet, use View > Sheet View > New instead; that feature can keep your sorting and filtering from changing what colleagues see.

Switch between Excel’s main worksheet views

The three main workbook views change how the sheet is displayed, not the worksheet’s underlying values. On the ribbon, open View and select a mode under Workbook Views. You can switch back and forth at any time, and the view you choose does not alter the data or formulas in cells.

Normal: The standard grid for entering, editing, and analyzing data.
Page Break Preview: A print-oriented view that shows how worksheet content is divided into pages.
Page Layout: A page-shaped view that helps you inspect margins, headers, footers, and the arrangement of content for printing.

For example, use Normal to update a sales table, switch to Page Break Preview to see whether the report will print across two pages, and return to Normal to continue working. These are display modes for the active workbook window; they do not create separate copies of the worksheet.

What each view shows

Normal is usually the best everyday choice. It gives you the familiar row-and-column grid and leaves room for working with large sheets. If the worksheet looks unusually small or large in this view, the cause may be the zoom setting rather than a different view. The zoom control on the status bar changes how large the sheet appears on screen, but it does not change the print scale.

Page Break Preview makes print pagination easier to understand. Excel marks page boundaries, and you can often drag a page-break line to adjust where a page ends. The shaded areas beyond the print area are not necessarily deleted data; they may simply be outside the current printable pages. Changing a break affects how the worksheet is divided for printing, so check the result in Print preview before distributing the document.

Page Layout displays the worksheet as pages and is useful when preparing a document for paper or PDF. Depending on the worksheet and settings, you can see page margins and header or footer areas, and use the rulers to judge placement. It can be less convenient for navigating a very wide or long dataset, so return to Normal when page-level layout is no longer the task.

Use Sheet View for a shared worksheet

Excel’s Sheet View feature is different from Normal, Page Layout, and Page Break Preview. It is designed for a worksheet that multiple people are using, so one person can sort or filter data without disrupting the view another person is using. It does not give you a private copy of the workbook or make edits to cell values private.

To start one in Microsoft 365 for Windows, open the shared workbook, select the worksheet, and choose View > Sheet View > New. Apply the sort or filter you need. If Excel labels the view as temporary, use the available Keep or save option to retain it; the precise controls can depend on the current Excel build. Use the Sheet View menu to return to the default view or exit the personal view.

Sheet View is most useful when a shared list has several legitimate ways to inspect the same records. For instance, a project team could keep a default task list while one person filters it to show overdue work and another sorts it by owner. A filter in a personal Sheet View can avoid changing colleagues’ displayed rows, but editing a task’s status still changes the shared workbook data and can be seen by others.

The feature is intended for supported Excel files stored in OneDrive or SharePoint and used in a collaborative setting. If the Sheet View controls are unavailable, check where the workbook is saved, whether it is a supported file, and whether you have a compatible Microsoft 365 version. Sheet View is not the same as saving a separate file or using a worksheet tab.

Choose the view that fits the task

Pick a view based on what you are trying to do. For data entry, formulas, and most analysis, use Normal. For checking page divisions or adjusting print breaks, use Page Break Preview. For checking page appearance, margins, or headers and footers, use Page Layout. When you are sorting or filtering a shared worksheet and want to avoid disturbing a colleague’s view, use Sheet View if the workbook supports it.

A practical sequence for a monthly report might be to edit and check the figures in Normal, review the page divisions in Page Break Preview, and inspect the finished pages in Page Layout or Print preview. If the report is a shared working list rather than a print document, a Sheet View may be more useful than switching among the three print-oriented display modes. You can change modes as the work changes; there is no need to choose one permanently.

Views, zoom, freeze panes, and worksheet tabs

Several Excel features can make a sheet look different, but they do not all switch its view. Zoom magnifies or reduces the grid on screen. Freeze Panes keeps selected rows or columns visible while you scroll. Filters hide rows that do not meet criteria, and hiding a worksheet row or column changes what is shown in the grid. None of those actions is the same as choosing Normal, Page Break Preview, or Page Layout.

A worksheet tab is also not a view. Tabs along the bottom of the window identify separate sheets, such as Sales, Inventory, and Summary. Selecting another tab switches to another worksheet; it does not switch the active sheet between Normal and Page Layout. On Windows, Ctrl+Page Up and Ctrl+Page Down move between worksheet tabs. On a Mac, the corresponding shortcuts are generally Control+Page Up and Control+Page Down; compact keyboards may require the Fn key. These shortcuts change sheets, not workbook view modes.

Check page settings when printing looks wrong

Switching to a print-oriented view can reveal a problem, but it may not fix the print settings that caused it. If a table is split awkwardly, first inspect the page breaks and the selected print area. In Page Break Preview, a misplaced boundary may explain why a group of columns starts on another page. You can adjust the break or review the page setup before printing.

Also check paper size, orientation, margins, and scaling in Excel’s print settings. A wide table might fit better with landscape orientation, while a long list may need a different page arrangement. Scaling a sheet to fit a chosen number of pages can make text very small, so preview the output at a readable size rather than assuming that fewer pages are always better. The view is a useful visual aid, but Print preview is the final check for the output you intend to create.

Common problems and quick fixes

The sheet looks like paper instead of a grid: Select View > Workbook Views > Normal.
Blue lines or page shading appear: You are likely in Page Break Preview. Switch to Normal, or adjust the breaks if you are preparing a printout.
The worksheet is tiny: Check the zoom control on the status bar. Zoom and view mode are separate settings.
A colleague’s rows changed after sorting: You may have sorted the shared sheet in its default view. If supported, use Sheet View for personal sorting and filtering; coordinate before making changes to shared data.
Sheet View is missing or unavailable: Confirm that you are using a compatible Microsoft 365 version and a supported workbook saved in OneDrive or SharePoint. Your organization’s setup or workbook format can also affect availability.

If the ribbon is simplified or the Excel window is narrow, some commands may be displayed differently or grouped into a compact menu. Expand the ribbon or widen the window, then look on the View tab for Workbook Views or Sheet View. Avoid confusing a hidden ribbon command with a missing worksheet feature: the active ribbon layout can change how controls are presented.

Excel for Mac and Excel for the web

Excel for Mac also offers worksheet display modes, but ribbon organization and keyboard behavior can differ from Windows. Look on the View tab for the available workbook view commands rather than relying on a Windows key sequence. For switching worksheet tabs, Mac keyboards without dedicated Page Up and Page Down keys may require Fn along with the shortcut.

Excel for the web has its own ribbon layout and supports collaborative work, but the exact controls and availability can differ from the Windows desktop app. If a command described for Windows is not visible, check the web app’s View tab or open the workbook in the desktop app. In either version, remember the distinction: display modes change how a sheet is presented, while Sheet View is intended to isolate a user’s sorting and filtering in a supported shared workbook.

Frequently Asked Questions

How do I get Excel back to the normal view?
Select View > Workbook Views > Normal. This returns the active worksheet to the standard grid view; it does not undo edits or change the worksheet’s data.

How do I switch to Page Break Preview in Excel?
Open the View tab and select Page Break Preview in the Workbook Views group. Use it to inspect page divisions, then return to Normal when you want the standard grid.

How do I change the view without affecting other people?
In a supported shared workbook, select View > Sheet View > New and apply your own sort or filter. This can separate your view of the rows from colleagues’ views, but edits to shared cell values are still visible to collaborators.

Does changing Excel’s view change how the worksheet prints?
Choosing Normal, Page Break Preview, or Page Layout is primarily a display change. Print output depends on settings such as page breaks, print area, margins, paper size, orientation, and scaling, so use Print preview to check the result.

Why can’t I find Sheet View?
Sheet View is intended for supported collaborative workbooks and may not be available in every file, storage location, Excel version, or organization setup. Check that the workbook is saved to OneDrive or SharePoint and open it in a compatible Microsoft 365 app.

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.