Worksheet several pages, Want name to show up on each page

  • Thread starter Thread starter Glenda
  • Start date Start date
G

Glenda

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