Ok I am creating a worksheet that is several pages long, on each page it has
name and other information, How do i set up my sheet so that I only have to
enter this information once?

In EXCEL 2007:-

- Page Layout

- Page Setup

- click on the arrow in the lower right hand corner

- Header / Footer tab

- Custom Footer (for example)

- enter information in the:-

Right section: (lower right hand corner)

- OK

- OK

Print Preview / and the information that you entered should appear in the
lower right hand corner of your Worksheet.

You can customize the above as you choose.

If my comments have helped please hit Yes.

Thanks.


"Glenda" wrote:

Ok I am creating a worksheet that is several pages long, on each page it has
name and other information, How do i set up my sheet so that I only have to
enter this information once?

When printing?

Rows to repeat at top will get you tahere.

On the worksheet itself say every 60 rows?

You will have to copy and paste or use links.


Gord Dibben MS Excel MVP

On Tue, 15 Dec 2009 02:41:01 -0800, Glenda
wrote:

Ok I am creating a worksheet that is several pages long, on each page it has
name and other information, How do i set up my sheet so that I only have to
enter this information once?