printing 1st column on all pages

[[email protected]]

How can one print the contents of the 1st column to each subsequent
pages?

If this require macros.... um, I don't know how to do that yet :-(

cheers

day

[RJL0323]

Printing the first column on each page does not require a macro. You need to go to File, Page Setup, Sheet Tab and then under the "Columns to repeat at left" box simply choose which column you want to appear on each page, in this case, column A:A.

[Bill Kuunders]

Page setup.....sheet.........column(s) to repeat at left

Greetings from New Zealand
Bill K
<[email protected]> wrote in message
news:[email protected]...
> How can one print the contents of the 1st column to each subsequent
> pages?
>
> If this require macros.... um, I don't know how to do that yet :-(
>
> cheers
>
> day
>

[David McRitchie]

and if you want to do the same thing for display you would select B1 to freeze
left column only or B2 to freeze left column and top row, and then use
Window, freeze panes.
Freeze Panes for view and Repeat row/col headings for printing
http://www.mvps.org/dmcritchie/excel/freeze.htm