Re: How do I repeat the 1st column on the following pages in Excel

Tech-Archive recommends: Fix windows errors by optimizing your registry

$A:$A

The easiest way is to click inside the box and then select the column ... it
will fill it in for you.

Regards


"Penny Reynolds" <PennyReynolds@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:45CE5BCD-9F88-40B5-A7A3-670935C87AAD@xxxxxxxxxxxxxxxx
Thanks, Trevor, I did this earlier but I guess I don't know what value is
expected. I tried "A" (for column A) and also the title of my column but
got
the error that the it was not a valid reference or defined name. Is there
something else I need to set up first?

"Trevor Shuttleworth" wrote:

File | Page Setup | *** tab | Columns to repeat

Regards

Trevor


"Penny Reynolds" <Penny Reynolds@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
news:6D22742F-054F-43A5-8D1E-D1BE2BAF0736@xxxxxxxxxxxxxxxx
When I print my Excel spread*** I would like to show the first column
of
data on all the following printed pages. I can see how to freeze the
first
column so when looking at it online I can always see the first column -
is
there a way to print it this way?





.

Quantcast