How do I return an Excel spreadsheet to normal view?

Note: if you switch to another view and return to Normal view, Excel displays page breaks. Close and reopen the Excel file to hide these page breaks. To always hide page breaks for this worksheet, click File, Options, Advanced, scroll down to Display options for this worksheet and uncheck Show page breaks.

Page Break Preview

Page Break Preview gives you a nice overview of where pages break when you print the document. Use this view to easily click and drag page breaks.

1. On the View tab, in the Workbook Views group, click Page Break Preview.


Note: click and drag the page breaks to fit all the information on one page. Be careful, Excel doesn't warn you when your printout becomes unreadable. By default, Excel prints down, then over. In other words, it prints all the rows for the first set of columns. Next, it prints all the rows for the next set of columns, etc. (take a look at the page numbers in the picture above to get the idea). To switch to Print over, then down, click File, Print, Page Setup, on the Sheet tab, under Page order, click Over, then down.

1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you


With Microsoft's introduction of Excel 2007, users had to abandon their previous habits and relearn Excel's menu structure. The familiar menu bar vanished in lieu of the "ribbon," which categorizes options in groups on separate menu tabs. As an example, the traditional View menu resides on a separate View tab in Excel 2007. This tab houses several view modes, such as Normal, Page Layout and Full Screen. However, Full Screen view conceals the ribbon, so other methods are necessary to return to Normal view from Full Screen view.

  1. 1.

    Right-click anywhere in on the screen while in Full Screen view and select "Close Full Screen." This will exit the mode and return you to the previously used mode. Alternatively, press "Esc" on your keyboard.

  2. 2.

    Click the top "View" tab and click "Normal" from the Workbook Views group to return to Normal view.

  3. 3.

    Click the appropriate sheet name at the bottom-left of Excel 2007 to return to a specific sheet. Some shortcuts automatically create and focus on a chart that resides in its own lower tab. While viewing the chart tab, you are in a chart editing mode, rather than a normal sheet view. Clicking the sheet tab will return you to the normal sheet view.

    Excel 2013 has a few different view options that you can select from to help you format your spreadsheet properly. The view setting is an independent trait of each worksheet in a workbook, so it is entirely possible for you to have a single Excel workbook that contains multiple different view settings.

    Fortunately there is an option in Excel 2013 that allows you to quickly select all of the worksheets within your workbook, then apply a change to all of those worksheets simultaneously. So if you are in a situation where you need all of your worksheets in the same view, and you don’t want to go through every worksheet and adjust that setting manually, then our steps below will show you how to return all of your worksheets back to the Normal view.

    Microsoft Word similarly allows you to switch between different views. Our guide on how to do I get my Word document back to normal view can show you how to change views in that application.

    How to Change the View Setting for All Worksheets at Once in Excel 2013

    The steps in this article will show you how to quickly select all of the worksheets in a workbook, then apply the same view setting to all of them. While this guide will focus on changing the view setting to the Normal View option, you could select any of the other view options instead.

    Step 1: Open your workbook in Excel 2013.

    Step 2: Right-click one of the worksheet tabs at the bottom of the window, then click the Select All Sheets option.

    Step 3: Click the View tab at the top of the window.

    Step 4: Click the Normal option in the Workbook Views section of the ribbon.

    Note that this will work regardless of the individual view settings of each worksheet.

    Are you having trouble getting your worksheets to print properly? Read our Excel printing guide to see some of the more common print settings that you can use to make your spreadsheets print better.

    Matthew Burleigh

    Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.

    After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.

    His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.