Menu:
Printing
Repeating row headings or column descriptions when Printing
1. Go to Page Setup found under the File.
2. Click on the tab Sheet.
Highlight the rows or columns that you wish to
have repeated on each page when printing.
For example: If you want the
first row to be repeated on each page printed that highlight row one. The popup
box should be per the below diagram.
Setting the Print Area
There may be only a certain or specific area which you want to print. You can select the specific are by following the below diagram.
Fitting the size to one page in Width
1. Go to Page Setup found under the File.
2. Change the settings per the below diagram. Landscape is normally chosen for reports, as most reports are relatively wide. Select the button Fit to: and increase the wide by: XX tall field. You want to make the number excessively high to ensure that the print out remains as one page wide.
