Pages

MS Excel Sheet Options, Adjust Margins

Sheet Options in Excel Tutorial

Sheet Options

Microsoft Excel offers a number of sheet options which help you control certain printing options like if you may choose to print grid lines along with the sheet. This can be done by ticking the Print option under the Page Layout Tab as shown in the screenshot below.

You can also go to Page Setup where you will find following Options under Sheet Tab:

Print Area: This option allows you to define the area to be printed.

Print Titles: This option allows you to define titles on top of every column and one left of every row.

Print :

Gridlines: This option allows you to print gridlines in the Excel Sheet.

Black & White: This option directs the color printer to print everything in black and white.

Draft quality: This option allows you to set print quality according to the draft settings of the printer.

Rows & Column Heading: This option allows you to print the headings of the rows and columns.

Page Order :

Down, then Over: It directs the printer to first print all the pages downwards and then move to the page on the right.

Over, then Down: This option directs the printer to print all the pages from left to right and then move to the page down.

Adjust Margins in Excel Tutorial

Margins

Microsoft Excel allows you to set the Margins for the Excel Sheet, which defines the portion of the page from the top, bottom, and sides that should be left unprinted. However, you do not have the facility to set different margins for the different sheets in a single file. Here are the different ways through which Margins can be set.

You can set the margins for the sheet by clicking the “Margin” option listed under the Page Layout Tab on the top. The drop down list will consist of four options: Normal, Wide, Narrow and Custom Margins as shown below.

You can also access these options by selecting Print in the File menu.

If none of the options: Normal, Wide and Narrow, are according to your liking, you can customize the margins within limits by using the fourth option of “Custom Margins”.

Center on Page

Microsoft Excel aligns the area to be printed with the top and left Margins. However, you can set the print area at the center by horizontally or vertically or both by selecting the appropriate option as shown in the above screenshot.