Page Layout View In Excel. You still have all of the functions of the standard view but with the addition of a few extra tools such a rulers header and footer fields and layout adjustment to enable you to achieve a perfect finish to your page. One of the slickest new features in excel 2007 is page layout view which shows your worksheet divided up into pages.
At the view menu click the button for custom views. Page layout view is useful to enable you to get a good overall feel for the look of the page when it s printed. 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.
In excel there are some handy tools in the form of the page layout view that you can use to manipulate your data to look good on a page.
Page layout view is one of three worksheet views which are controlled by the three icons in the right side of the status bar. Things to remember about page setup in excel. Here is what the view tab looks like in current builds. In other words you are able to visualize your printed output as you work.
