Printing

[ahmed]

I want to repeat a row on selected pages when I print. Is it possible.

For example, row should repeat from 1-3 and then 5.

Thanks

 

[Stan Brown]

Thu, 28 Feb 2008 03:06:07 -0800 from ahmed

I want to repeat a row on selected pages when I print. Is it possible.

For example, row should repeat from 1-3 and then 5.

File | Page Setup | Sheet | Rows to Repeat at Top:

 

[JLatham]

Rows to repeat must be contiguous, so 1-4 plus 5 won't work, but $1:$5 (1
thru 5) would work and he could hide row 4 before printing?

 

[ahmed]

Thanks Stan for your reply.

Maybe I got my question wrong. I want to print only 1 row, but not on all
the pages, but only on selected pages.

ahmed

 

[Bob I]

Then you will need to perform two print jobs one for the pages where you
use the repeated row(select the pages to print), and another for the
ones without(again select the pages to print).

 

[Stan Brown]

Thu, 28 Feb 2008 04:34:02 -0800 from JLatham <HelpFrom @
Jlathamsite.com.(removethis)>:
so 1-4 plus 5 won't work, but $1:$5 (1

Rows to repeat must be contiguous,

Whoops -- you're right! Thanks.