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

Setting Page Margins

In Print Preview mode, if you find a page whose print area exceeds the page margins, click the Margins button.

Excel activates Print Preview's margin lines.

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 at the same time as the margins.


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).

Thanks to the margin change, the total number of pages to print is reduced from four to two. The column that exceeded the margins in the print area now fits on the page.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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