Dynamic Headers within One Excel Worksheet

Question

Hello,

I'm looking for information about creating dynamic headers in one excel worksheet.

Currently I have multiple invoices for different clients that I need to print. Each Client receives there own  printed invoice for their billable items. I need the billable items headers to repeat across multiple printed pages. When I use the Print Title Rows to repeat at top functionality, the headers repeat across all the pages including on top of the 1st page of each Client Title.

I know I can put each Client invoice in a separate tab and that would solve the issue, but I have other formatting issues where they are easier and simpler to do in one sheet instead of multiple.

Is there a way I can have the Billable Items Header repeat across only certain pages automatically?

Thank you!

Example:

Client Title:

Business Name 1

Address 1

Total: 1

Billable Item Header 1	Billable Item Header 2	Billable Item Header 3	Billable Item Header 4

Client Title:

Business Name 2

Address 2

Total: 2

Billable Item Header 1	Billable Item Header 2	Billable Item Header 3	Billable Item Header 4

Answer 1

use Freeze Panes it will solve ur problem.

select the row line, View -> Freeze Panes ->