Center Printed Excel 2010 Worksheets

0

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.

Page-SetUp-Margins

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

 

Share.

About Author

Rahat

Leave A Reply

Powered by themekiller.com