ExcelBanter - Heading from first row to follow all pages

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Heading from first row to follow all pages (https://www.excelbanter.com/setting-up-configuration-excel/189856-heading-first-row-follow-all-pages.html)

Smilen2day

Heading from first row to follow all pages

I have the heading of my worksheet on row 1 and I want this same heading to
follow on every page. The rows on a page can change so I don't want to do a
page break and then copy and paste the row.

So, is there a way to have the heading row floating so it will be listed on
the top row of every page printed?

Gord Dibben

Heading from first row to follow all pages

See reply in other group you multi-posted to.

Gord Dibben MS Excel MVP

On Tue, 3 Jun 2008 09:43:02 -0700, Smilen2day
wrote:

I have the heading of my worksheet on row 1 and I want this same heading to
follow on every page. The rows on a page can change so I don't want to do a
page break and then copy and paste the row.

So, is there a way to have the heading row floating so it will be listed on
the top row of every page printed?

All times are GMT +1. The time now is 07:29 AM.