Microsoft Excel 2007 – Centering Your Worksheet Data

If you are working with smaller worksheets, they can look odd when printed. Why? Because Excel normally prints your worksheet data at the upper-left corner of a piece of paper. If the worksheet data is small enough, the placement of the data on the printed sheet can detract from what you are trying to convey.

To help offset this problem, Excel provides a way you can easily center your printed information. You can center the data horizontally, vertically, or both. Follow these steps:

1. Display the Page Layout tab of the ribbon.

2. Click the small icon at the bottom-right of the Page Setup group. Excel displays the Page Setup dialog box.

3. Select the Horizontally check box if you want the information centered left-to-right between the margins of the page. OR Select the Vertically check box if you want the information centered top-to-bottom between the margins of the page. You can check both so that your worksheet centered both horizontally and vertically.

4. Click OK.