Page Layout View In Excel. At the custom views window click add. Click the advanced tab and then select the appropriate unit on the ruler units drop down menu in the display section.
Or the user can switch between views using the appropriate controls on the view tab. In other words you are able to visualize your printed output as you work. One of the slickest new features in excel 2007 is page layout view which shows your worksheet divided up into pages.
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.
Much like word excel now has view switchers on the status bar. Click the advanced tab and then select the appropriate unit on the ruler units drop down menu in the display section. In other words you are able to visualize your printed output as you work. Change the view from normal to page layout.