$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" wrote in message
...
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 | Sheet tab | Columns to repeat

Regards

Trevor


"Penny Reynolds" <Penny wrote in
message
...
When I print my Excel spreadsheet 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?