Rows to Keep at Top...

  • Thread starter Thread starter 116
  • Start date Start date
1

116

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
 
Back
Top