Print column A on each page

  • Thread starter Thread starter cassy01
  • Start date Start date
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
 
Benn

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

Regards

Trevor
 
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
 
Back
Top