Keeping Cells on top when printing

B

Byers

I've seen it done, I have a two page long table with people's names i
the far left column, I would like to have those go on to the secon
page too, I already have my worksheet set up so when you scroll you ca
see them, but it doesn't carry over to printing. Is there an easy wa
to set it up to do this
 
R

RogerT

I've seen it done, I have a two page long table with people's names in
the far left column, I would like to have those go on to the second
page too, I already have my worksheet set up so when you scroll you can
see them, but it doesn't carry over to printing. Is there an easy way
to set it up to do this?
Click to expand...
 
R

RagDyeR

<File> <PageSetUp> <Sheet> tab,
Where you'll find:
"Columns To Repeat At Left"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I've seen it done, I have a two page long table with people's names in
the far left column, I would like to have those go on to the second
page too, I already have my worksheet set up so when you scroll you can
see them, but it doesn't carry over to printing. Is there an easy way
to set it up to do this?
 
J

Jacques Brun

Try the following
File >Page set up >Sheet Tab
Click to expand...
Column to Repeat at left : $A:$A

Column A will be repeated on each page
You should print from column B to avoid to have column A
twice on on page One : on Sheet Tab, field PrintArea give
a range starting on column B
 
Top