Prev: Array Formula + Indirect Reference
Next: How do I prevent duplicate entry of a sku in a data table?
From: Glenda on 15 Dec 2009 05:41
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 15 Dec 2009 06:55
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 15 Dec 2009 16:40
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?

 | 
Pages: 1
Prev: Array Formula + Indirect Reference
Next: How do I prevent duplicate entry of a sku in a data table?