How to Make Page Layout the Default View in Excel 2010

Excel 2010 has a handful of different views that you can select between when viewing the data in a spreadsheet. We have previously shown you how to switch to the “Page Layout” view in the program, but that method will only allow you to change the view for the current sheet. If you create a new workbook, or a new sheet, in the future, then it will use the default “Normal” view.

But this is not a setting that you need to live with, as it is possible to change to a different default view. Our guide below will walk you through the steps necessary to switch to the Page Layout view as the default option in Excel 2010.


Set “Page Layout” as the Default View in Excel 2010

The steps in our article below will change the default view for new worksheets only. This means any new workbook that you create, or new worksheet that you add to an existing workbook, will use the Page Layout view by default. Existing worksheets will use whichever view was active when the file was last saved.


  1. Click the File tab at the top-left corner of the window.
  2. click the file tab



  3. Click the Options button in the column at the left side of the window.
  4. open the excel options window



  5. Confirm that the General tab is selected at the left side of the window, then click the drop-down menu to the right of Default view for new sheets and click the Page Layout View option. You can then click the OK button at the bottom of the window to save your changes and close the window.

set page layout view as default in excel 2010



Any future new worksheets will use this view by default.


Do you only need to print part of your worksheet, but are having difficulty accomplishing what you need to do? Learn about setting print areas in Excel 2010 to see one of the more effective changes you can make to your worksheet that will improve the quality of your printed sheets. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.