In the layout view of the report:
Adding Print Titles to a Worksheet
A long worksheet is often easier to read when the first column or row is repeated on every page. This can be accomplished by adding print titles to repeat row or column headings on each page of the document.
|To Repeat Row Titles At The Top Of Each Page: |
|Choose File ( Page Setup. |
|Click on the Sheet tab. |
|[pic] |
|In the Print titles area, click in the text box to the right of Rows to repeat at top. |
|Enter a range of rows. |
|E.g. $1:$2 prints the first two rows on each page; $1:$1 prints the first row on each page. |
|Choose OK. |
|To Repeat Column Titles On The Left Of Each Page: |
|Choose File ( Page Setup. |
|Choose the Sheet tab. |
|[pic] |
|In the Print titles area, click in the box to the right of Columns to repeat at left. |
|Enter a range of columns. |
|E.g. $A:$B prints the first two columns on each page; $A:$A prints the first column on each page. |
|Choose OK. |
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- the exact address of the ministry education
- in view of the foregoing
- the life history of the united states
- the major stages of the water cycle
- what s the longest day of the year
- find the sixteen books of the bible
- the longest day of the year
- axial view of the brain
- the strategic importance of the island of socotra
- live view of the moon
- a 35 years old female complains of acute belting pain in the right half of the
- current view of the moon