Click File. Choose Options. Select the General tab. Click Default view for new sheets, then choose Page Layout.
- What is the default view when opening Excel?
- Why is Page Layout locked in Excel?
- How do I change the view to Page Layout view?
What is the default view when opening Excel?
The default view in Excel is Normal View.
Why is Page Layout locked in Excel?
In Excel, page setup properties are only available when you print or preview one or more sheets in a workbook. Because of this, you cannot change or return most page setup properties unless at least one printer driver is installed as the default printer.
How do I change the view to Page Layout view?
To view a page in Page Layout View, first you need to click the worksheet that you want to change in this view and then on the 'View' tab click 'Page Layout View' which is found under the 'Views' group.