• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 9. Printing in Excel > Setting Page Margins

Setting Page Margins

When in Print Preview mode, if you have a page that displays some carryover data from another page, click the Margins button.

Excel activates Print Preview's margin lines. Press page up or page down to display the page in your worksheet on which you want to fit all the data.

INTRODUCTION

Margins affect where data is printed on a page. They also determine where headers and footers are printed. Occasionally, margins might need to be changed to make room for a letterhead or logo on preprinted stationery. When in Print Preview mode, Excel allows you to alter your column widths and margins simultaneously.


TIP

Print Preview Button

Click the Print button to open the Print dialog box (refer to the task “Printing Worksheets”).


Drag the Left Margin line from the default 1'' to 0.34'' (you can see the exact measurement in the bottom-left corner of the screen).

Click and drag the Right Margin line from the default 1'' to 0.34'' (again, you can see the exact measurement in the bottom-left corner of the screen).

Thanks to the margin change, the total number of pages to print is reduced from four to two.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint