From: Glenda on
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?
From: trip_to_tokyo on
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?
From: Gord Dibben on
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
<Glenda(a)discussions.microsoft.com> 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?