Set Up Margin For Printing In Excel

Let’s see how to leave margin in excel sheet.

Step 1

Go to Margins under PAGE LAYOUT tab in excel as shown below.

Capture

Step 2

Depending on your print area requirement, adjust the right, left, top and bottom margin of your sheet, by default its set to Normal.




I will set the margin from Normal to Narrow and if you observe closely the margins which indicated with a very light dashed line will change.

Below is the margin which appears in Normal mode that is there at column I.

Capture

And below is the margin that appears if I change it to Narrow Mode, you can see it has shifted to column J.

Capture

Step 3

Apart from the defined margins mode in excel, you could also customise the margins by using the Custom Margins at the bottom of the Margins tab as shown below.

Capture

Step 4

Click the Custom Margins to manually set up you margins in sheet.




Capture

You could manually set your margins from here and also set your page to Horizontal and Vertical by using the checkbox at the below left.

When you are done with margins, click on print preview t the bottom to see how your sheet is going to look while printing.

You could also set header and footer from here.

Hope this helped.




Share The Knowledge

Random Posts

Leave a Reply