If you have a lot of information that will not print on a single page, then you will most likely want to print row and column labels on every page. In the Page Setup dialog box you can define which rows and columns will be repeated on every printed page, and then see a preview of what your printed page will look like.
To repeat rows and columns on every printed page:
Be sure to use the Print Preview button to see what your printed worksheet will look like. |
|
The Sheet tab on the Page Setup dialog box also includes options to print gridlines, change the print order, print cell errors, and adjust the quality of your printed worksheet. |
|
Click in the Rows to repeat at top: box or the Columns to repeat at left: box and then click the row or column in your worksheet that you want to repeat. |