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.


Posted in:
About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.