Center data on your printout (2003/2007)

Printouts look best when they're centered both vertically and horizontally. If you've been playing around with column widths and margins to center your data, try this easy shortcut instead:

1. Choose File | Page Setup from the menu bar to open the Page Setup dialog box. (In 2007, click the Office button, then select Print | Print Preview. Click on Page Setup.)
2. Click on the Margins tab.
3. Select both the Horizontally and the Vertically check boxes in the Center On Page panel.
4. Click OK to accept your changes.

When you look at your print preview, you’ll see that your data is now in the center of the page.