Center Your Worksheet Data in Excel 2007

If you have created a small worksheet, you may want to center it on the page when you print it. By default, it will print in the upper, left corner of the page. For a very small set of data, this can detract from the effectiveness of your presentation.

Sample small worksheet

There is an easy way to center the data on the printed page. You can center the data horizontally, vertically, or both.

To see how your worksheet will display when printed, select Print | Print Preview from the Office menu.

Selecting Print Preview

When the sample worksheet above is previewed, you can see that it is placed in the upper, left corner of the page. This is how it will print.


To center the data on the printed page, click the Page Layout tab. Then, click the arrow button in the lower, right corner of the Page Setup section of the Page Layout tab.

Clicking the Page Setup dialog button

The Page Setup dialog box displays. Click the Margins tab. Under the Center on page heading, select the Horizontally check box if you want the information centered left-to-right between the margins of the page. Select the Vertically check box if you want the information centered top-to-bottom between the margins of the page. Select both check boxes if you want the data centered in the page both horizontally and vertically. Click OK.

Margins tab on the Page Setup dialog box

Now, when you view the Print Preview, you will see the data centered on the page.

Centered Print Preview

Centering data on a page is effective only for the currently selected sheet. Therefore, even if you have a full page of data on Sheet 2, you can center the smaller set of data on Sheet 1.

by Lori Kaufman

More posts from the Office Tips Category

Restrict Editing on Word 2007 and Word 2010 Documents

mswrd632 error word

Fix “Word Cannot Start the Converter MSWRD632.WPC” Error

outlook 2007 spell checker

Outlook 2007 Spell Checker Not Working

Connecting Excel to MySQL

Popular Posts This Month

windows defender

Windows Defender vs. Security Essentials vs Safety Scanner

youtube ie11 freezing

How To Fix Flash Crashes in Internet Explorer 11

bitlocker error

Fix “This device can’t use a Trusted Platform Module” When Enabling BitLocker

Leave a Reply