Centering Your Worksheet

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. Choose the Page Setup option from the File menu. Excel displays the Page Setup dialog box.
2. Make sure the Margins tab is selected. (Click here to see a related figure.)
3. Select the Horizontally check box if you want the information centered left-to-right between the margins of the page.
4. Select the Vertically check box if you want the information centered top-to-bottom between the margins of the page.
5. Click on OK.