On printing out a set of rows and columns at the beginning of every sheet.

[Don J]

I seem to remember that there is a way of specifying a set of rows and
columns that get printed out at the top and left of each sheet when printing
a worksheet that gets split into multiple sheets.

Don J

----------------------------------------------------------------

 

[Jim Cone]

File (menu) | Page Setup | Sheet (tab)
"Rows to repeat at top"
"Columns to repeat at left"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Don J" <[email protected]>
wrote in message
I seem to remember that there is a way of specifying a set of rows and
columns that get printed out at the top and left of each sheet when printing
a worksheet that gets split into multiple sheets.
Don J

 

[Ragdyer]

<File> <Page Setup> <Sheet> tab,

 

[Don J]

Thanks!

Don J

--------------------------------------------------------------------

<File> <Page Setup> <Sheet> tab,

 

[Don J]

Thanks!

Don J

 

[Don J]

Not OK!

I insert the numeral "3" for three rows, or just "A" to designate the first
row. In each case I get a message to the effect that the name is illegal.
Whats going on?

Don J

------------------------------------------------------------------

Thanks!

Don J

--------------------------------------------------------------------

 

[Ragdyer]

It's looking for *2* numbers, a start and an end!

You could choose to have 3 rows repeat at the top of each page.
So, you'd enter 1:3
Same for columns,
A:C

Now, for a single row or column,
3:3
OR
A:A

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

Not OK!

I insert the numeral "3" for three rows, or just "A" to designate the first
row. In each case I get a message to the effect that the name is illegal.
Whats going on?

Don J

------------------------------------------------------------------

Thanks!

Don J

------------------------------------------------------------------------- --

!

 

[Jim Cone]

Your syntax is wrong... $1:$3 and $A:$A works.
The easiest way is to just select the rows or columns.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Don J" <[email protected]>
wrote in message
Not OK!

I insert the numeral "3" for three rows, or just "A" to designate the first
row. In each case I get a message to the effect that the name is illegal.
Whats going on?
Don J