Printing Gridlines and Row and Column Headings

The Sheet Options group contains two very useful Print check boxes (neither of which is automatically selected), the first in the Gridlines column and the second in the Headings column.

Choose Page Layout => Sheet Options and then choose from the following options:

Gridlines => Print:
Check this option to print the gridlines surrounding each cell in the worksheet.

Headings => Print:
Check this option to print the row numbers or column letters around the worksheet. You can see illustrates a worksheet printed with gridlines and row and column headings.

Select both check boxes (by clicking them to put check marks in them) when you want the printed version of your spreadsheet data to match as closely as their on-screen appearance. This is useful when you need to use the cell references on the printout to help you later locate the cells in the actual worksheet that need editing.

Selecting miscellaneous sheet printing options

Excel provides some worksheet print options that you might use occasionally. Follow these steps to access these options:

1. Click the Page Layout tab on the Ribbon and click the dialog launcher button on the bottom right of the Sheet Options group container. Excel displays the Page Setup dialog box with the Sheet tab selected.
   
   
2. Select among these options:
   
   Black and White:
   If you have a colorful worksheet but your printer is stuck in a monochrome world, you may discover that the worksheet colors don't translate well to black and white. In this case, you can use this option to instruct Excel to ignore the colors while printing.
   
   Draft Quality:
   Printing in Draft mode doesn't print embedded charts or drawing objects, cell gridlines, or borders. This mode usually reduces the printing time and is handy for getting a quick printout. Comments: If one or more cells in your worksheet have a cell comment, you can print these comments along with the worksheet by choosing an option from the Comments drop-down list. By default, comments are not printed.
   
   Errors:
   Excel gives you the option to print error values as they appear on your worksheet or to replace each of the error values with a predefined character in the printed output. Error values include #NUM!, #DIV/0!, #REF!, #N/A, #VALUE!, #NAME?, and #NULL!. Choose an option from the Cell Errors As drop-down list. By default, errors are printed as displayed.
   
   Page Order:
   If you have a worksheet that spans across several columns and down several rows, your worksheet is likely to end up with multiple vertical page breaks, horizontal page breaks, or both. In this case, you have the choice of printing your worksheet pages from left to right or from top to bottom. In the Page Order area, click the Down, Then Over radio button or the Over, Then Down radio button. By default, Excel prints down, then over.
   
   
3. Click OK to close the Page Setup dialog box.