Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
Printing | Excel Discussion (Misc queries) | |||
Printing by row | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |