Print column A on each page

C

cassy01

is it possible to print column A on each page as the first column ??

i have the name of the person in column A then i have about 3 pages o
figures and i was just wandering if there was a way to print the name
first on each page.

Many Thanks
Ben
 
T

Trevor Shuttleworth

Benn

File | Page Setup... | Sheets tab | Columns to repeat at left: $A:$A

Regards

Trevor
 
P

Peter Atherton

Benn

I thnk the easiest way is to use a formula. If the first
sheet is named Sheet1 then hold down the shift key and
select the second and last sheets in the book and enter
this formula. =Sheet1!A1 then copy it down.

With this method, if you delete a record (row) from the
first sheet you will get a REF error in the other sheets
so select all the sheets before deleting the row.

Regards
Peter
 
Top