Center Printed Excel 2010 Worksheets

When you work with small worksheets they sometimes look out of kilter when you print them. The reason for this is that Excel prints worksheet data from the upper left-hand corner.

To make your worksheet more pleasing to the eye, you can center your data horizontally, vertically or both if you like.

Follow the steps below to learn how:

  1. Click the Page Layout tab of your Ribbon.
  2. In the Page Setup group, click the small icon at the bottom right-hand side to display the Page Setup dialog box.
  3. Click the Margins tab if it is not already selected.


  1. Select the Horizontally check box if you would like your data centered left-to-right between your margins.
  2. Select the Vertically check box if you would like your data centered top-to-bottom between your margins.
  3. Click OK.


Scroll to Top


Get great content like this delivered to your inbox!

It's free, convenient, and delivered right to your inbox! We do not spam and we will not share your address. Period!