Microsoft Excel provides various sheet options for printing purpose like generally cell gridlines aren’t printed. If you want your printout to include the gridlines, Choose Page Layout » Sheet Options group » Gridlines » Check Print.
Options in Sheet Options Dialogue
Print Area − You can set the print area with this option.
Print Titles − You can set titles to appear at the top for rows and at the left for columns.
Print
Gridlines − Gridlines to appear while printing worksheet.
Black and White − Select this check box to have your color printer print the chart in black and white.
Draft Quality − Select this check box to print the chart using your printer’s draft-quality setting.
Rows and Column Heading − Select this check box to have rows and column heading to print.
Page Order
Down, then Over − It prints the down pages first and then the right pages.
Over, then Down − It prints right pages first and then comes to print the down pages.
Margins
Margins are the unprinted areas along the sides, top, and bottom of a printed page. All printed pages in MS Excel have the same margins. You can’t specify different margins for different pages.
You can set margins by various ways as explained below:
Choose Page Layout » Page Setup » Margins drop-down list, you can select Normal, Wide, Narrow, or the custom Setting.
These options are also available when you choose File » Print.
If none of these settings does the job, choose Custom Margins to display the Margins tab of the Page Setup dialog box, as shown below.
Center on Page
By default, Excel aligns the printed page at the top and left margins. If you want the output to be centered vertically or horizontally, select the appropriate check box in the Center on Page section of the Margins tab as shown in the above screenshot.
Print Area − You can set the print area with this option.
Print Titles − You can set titles to appear at the top for rows and at the left for columns.
Black and White − Select this check box to have your color printer print the chart in black and white.
Draft Quality − Select this check box to print the chart using your printer’s draft-quality setting.
Rows and Column Heading − Select this check box to have rows and column heading to print.
Over, then Down − It prints right pages first and then comes to print the down pages.
Margins
Margins are the unprinted areas along the sides, top, and bottom of a printed page. All printed pages in MS Excel have the same margins. You can’t specify different margins for different pages.
You can set margins by various ways as explained below:
Choose Page Layout » Page Setup » Margins drop-down list, you can select Normal, Wide, Narrow, or the custom Setting.
By default, Excel aligns the printed page at the top and left margins. If you want the output to be centered vertically or horizontally, select the appropriate check box in the Center on Page section of the Margins tab as shown in the above screenshot.
0 Comments