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.

Google Online Preview   Download