ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Printing (https://www.excelbanter.com/excel-discussion-misc-queries/178147-printing.html)

ahmed

Printing
 
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

Printing
 
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:

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

JLatham

Printing
 
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?

"Stan Brown" wrote:

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:

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...


ahmed

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

"Stan Brown" wrote:

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:

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...


Bob I

Printing
 
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).

ahmed wrote:

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

"Stan Brown" wrote:


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:

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...



Stan Brown

Printing
 
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

"Stan Brown" wrote:

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:


Rows to repeat must be contiguous,


Whoops -- you're right! Thanks.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...


All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com