Page Layout View In Excel. Click the advanced tab and then select the appropriate unit on the ruler units drop down menu in the display section. View the page layout of your spreadsheet in excel 2010 step 1.
Click the file tab and then click options. Page layout view is useful to enable you to get a good overall feel for the look of the page when it s printed. Things to remember about page setup in excel.
The excel options dialog box appears.
One of the slickest new features in excel 2007 is page layout view which shows your worksheet divided up into pages. You can change the ruler units. Choose the page layout menu. Print title prints the title of each column on multiple pages whereas the report header is the header of the report main title of the report.
