I see there is on Page layout an area to select what cells are wanted to
repeat on ALL pages. Is there a way to select non-contiguous rows.
Example...A1-A4 and A7-A9. Thanks for any assistance.

David

Hide..?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"116" wrote in message
...
I see there is on Page layout an area to select what cells are wanted to
repeat on ALL pages. Is there a way to select non-contiguous rows.
Example...A1-A4 and A7-A9. Thanks for any assistance.

David

On the "Sheet" tab of the Page Setup dialog, click in the "Rows to repeat at
top:" box. You must select a contiguous block of rows (meaning "$1:$10" and
not "$1:$3,$7,$9"). After you select the block of rows you want included at
the top of each page, select those rows you don't want to show and Hide them
("Format/Row/Hide"). The rows you hide will not print at all, but the other
rows you selected for repeating on each page will. This simulates a
non-contiguous selection of rows.

HTH,

Eric

"116" wrote:

I see there is on Page layout an area to select what cells are wanted to
repeat on ALL pages. Is there a way to select non-contiguous rows.
Example...A1-A4 and A7-A9. Thanks for any assistance.

David