When you add a new sheet, Excel
by default shows the newly created sheet in Normal mode (as opposed to Page Layout view or Page Break view). If
you want to change this behaviour and let Excel opens in the mode you want,
change the default setting as below.
Excel 2010 and later:
File tab > Options
> General > When creating new workbooks segment >
select mode you like in the Default view
for new sheets drop down. Options available are Normal View (default), Page
Break Preview, and Page Layout View.
Excel 2007:
Click the Microsoft Office button > Excel
Options > Popular tab > When creating new workbooks segment >
select mode you like in the Default view
for new sheets drop down. Options available are Normal View (default), Page
Break Preview, and Page Layout View.
This feature was introduced in
Excel 2007. Users of earlier versions are out of luck here.
