Setting and Changing Print Margins

Margins define the white boundary area of the page and provide a visual border around your printed data. Changing a worksheet’s margins increases or decreases the amount of data displayed on a page, which allows you to make room for one last column of data, to divide your columns evenly between two pages, or to allow for enough room at one edge for the page to be bound in a report or three-ring binder. In Print Preview mode, margins appear as dark gray lines, which you can drag to the desired position.

Set Page Margins

  1. Click the Page Layout tab.

  2. Click Margins and either click the desired margin settings or click ...

Get Microsoft® Office Excel® 2007 Plain & Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.