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

D

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

----------------------------------------------------------------
 
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
 
D

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

------------------------------------------------------------------
Don J said:
Thanks!

Don J

--------------------------------------------------------------------
Click to expand...
 
R

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 !
---------------------------------------------------------------------------
Don J said:
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

------------------------------------------------------------------
Don J said:
Thanks!

Don J
Click to expand...
------------------------------------------------------------------------- --
Click to expand...
!
Click to expand...
 
Top