Your Excel spreadsheet may suddenly look zoomed in, show no gridlines, or appear as a single page. This happens because Excel has different view modes for editing, printing, and page layout. The display changes when you accidentally switch from the default Normal view. This article explains how to identify your current view and return to the standard Normal view for editing.
Key Takeaways: How to Switch Back to Normal View in Excel
- View tab > Workbook Views > Normal: This is the primary method to return to the standard editing view from any other mode.
- Status bar view buttons: Click the Normal icon on the bottom-right of the Excel window for a one-click switch.
- Alt + W, L keyboard shortcut: Use this key combination to instantly activate Normal view without using the mouse.
Understanding Excel’s Workbook View Modes
Excel provides several view modes, each designed for a specific task. Normal view is the default for most data entry and formula work. Page Layout view shows margins, headers, and footers as they will print. Page Break Preview displays blue lines for page breaks, which you can drag to adjust. If your sheet looks wrong, you are likely not in Normal view. The zoom level may seem extreme, gridlines might disappear, or you might see white page boundaries. These are visual cues of an active alternative view.
You need an open workbook to change views. The steps are identical in Excel for Microsoft 365, Excel 2021, Excel 2019, and Excel 2016. The interface for changing views is consistent across Windows 11 and Windows 10.
Steps to Return to Normal View in Excel
Use one of these methods to switch back. The ribbon method is the most comprehensive.
- Use the View tab on the ribbon
Click the View tab at the top of the Excel window. In the Workbook Views group, click the Normal button. Your spreadsheet will immediately revert to the standard editing view. - Use the status bar shortcuts
Look at the bottom-right corner of the Excel window, to the left of the zoom slider. You will see three small icons: Normal, Page Layout, and Page Break Preview. Click the first icon, which looks like a simple rectangle, to activate Normal view. - Use the keyboard shortcut
Press Alt + W, then press L. This keyboard command directly selects the Normal view option from the View tab.
If Normal View is Grayed Out or Unavailable
Sometimes the Normal button may be unavailable. This occurs if the workbook is protected, shared, or if a particular sheet type like a macro sheet is active. First, check if the sheet is protected. Go to Review > Unprotect Sheet. If the workbook is shared, you must stop sharing it first via Review > Share Workbook, then uncheck the sharing box.
Common Display Issues After Switching Views
Gridlines Are Still Missing in Normal View
Returning to Normal view does not automatically restore gridlines if they were turned off. To fix this, go to the View tab. In the Show group, ensure the Gridlines checkbox is selected. Also check Page Layout > Gridlines > View.
The Zoom Level Still Looks Wrong
Views like Page Layout often use a different zoom setting. After switching to Normal view, adjust the zoom manually. Use the zoom slider on the status bar or go to View > Zoom and select 100%.
Page Breaks Still Appear as Dotted Lines
Dotted lines indicate manual page breaks that were set. To remove them, switch to Page Break Preview, drag the blue lines to the edges of the sheet, then switch back to Normal view. Alternatively, go to File > Options > Advanced, and under Display options for this worksheet, uncheck Show page breaks.
Excel View Modes Comparison
| Item | Normal View | Page Layout View | Page Break Preview |
|---|---|---|---|
| Primary Use | Data entry, formulas, standard editing | Designing page setup, headers, footers | Adjusting where pages break for printing |
| Gridlines Display | Shows default gray gridlines | May hide gridlines, shows page margins | Shows page breaks as blue lines |
| Zoom Behavior | Standard zoom control | Often zooms to show whole page | Zooms out to show all page breaks |
| Keyboard Shortcut | Alt + W, L | Alt + W, P | Alt + W, I |
You can now confidently switch Excel back to Normal view when the display changes unexpectedly. Use the status bar button for the fastest correction. If you often work with page setup, learn the Alt + W, P shortcut to toggle into Page Layout view quickly. For advanced control, customize the Quick Access Toolbar by adding the Normal View command from All Commands.