Specify Repeating Rows and Columns
Excel's Print Titles enable you to print particular row and column headings on each page of the report. Print titles are important in multi-page reports where the columns and rows of related data spill over to other pages that no longer show the row and column headings on the first page.
Choose Page Layout> Page Setup> Print Titles. The Page Setup dialog box opens. On the Sheet tab, type a dollar sign ($) followed by the row numbers or column letters you want to print as titles in the Print Titles section. Entering $2:$2, excel repeats row 2 at the beginning of each page. Click ok.
Click the worksheet icon on the right to collapse the Page Setup dialog box so you can select the rows or columns you want to include. Click the button again to return to the Page Setup dialog box.
To clear print titles from a report if you no longer need them, open the Sheet tab of the Page Setup dialog box and then delete the row and column ranges from the Rows to Repeat at Top and the Columns to Repeat at Left text boxes. Click OK or press Enter.
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:
- 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.
- 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. - Click OK to close the Page Setup dialog box.