View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I repeat the 1st column on the following pages in Excel

Penny

Try A:A or just point to the column using the collapse button at right side of
the dialog box.

I call it the collapse button because no one ever told me the real name for it.


Gord Dibben MS Excel MVP

On Fri, 1 Sep 2006 11:06:02 -0700, Penny Reynolds
wrote:

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?