MS 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.
 |
| Sheet Options |
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 & 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 & 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.
-
