Printing

  • Thread starter Thread starter ahmed
  • Start date Start date
A

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
 
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.
Click to expand...

File | Page Setup | Sheet | Rows to Repeat at Top:
 
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?
 
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
 
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).
 
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,
Click to expand...

Whoops -- you're right! Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing very large spreadsheet 1
Row to repeat while printing 3
Help Reg Print 1
Repeat Rows at Top - Except Final Page 2
Dynamic Excel data into locked Word form 0
Print Landscape/Portrait based on level of grouped data selected 4
Print Page setup question 2
Insert automatic page numbering into a cell, not a header or foote 1

Back
Top