Excel 07 Page Layout View

on Tuesday, August 4, 2009

Microsoft Excel 07 - the latest version of Excel - offers a solution to one of the most vexing aspects of Excel: print formatting. In older versions of Excel, to format the printed version of a spreasdsheet, you needed to go to File, then Page Setup, then Print Preview, and then sort of hop back and forth between Page Setup and Print Preview and tweak the layout to get the correct printed page. Getting the rows and columns to break at just the right spot was a cumbersome and time-consuming process.

Excel 07 has a Page Layout view as the center icon at the lower righthand corner of the page (it's circled in the illustration to the right). It changes the view on the document screen (below) to how it will look when printed so that you can tweak it and see your changes enacted immediately. The row and column heading bars are moved to just outside the document, so you can resize rows and columns, hide columns, etc., just by working with the row and column bar options. You can also use the Ribbon commands to change font size and styles, hide or show gridlines, add border styles, all on the document pane, until you get the exact printed document you want. You can even add headers and footer by clicking directly on the page and typing. Page breaks, both horizontal and vertical, automatically readjust as you make changes to the document.


Post a Comment