Excel provides two views of worksheet content:
Normal view. This view displays the content in each worksheet as one large cell grid. The ruler is not available in Normal view.
Page Layout view. This is the default view for a new workbook. This view displays worksheet pages as they will appear when printed. Headers and footers are visible. Pages that do not contain content appear gray.
To change the default view, display the Excel Preferences dialog box and then, under Authoring, click View. On the View page, in the Settings area, choose the view you want from the Preferred View For New Sheets list. Then click OK.