How Can I make page breaks and colapsable cells 3

[TRHorn]

I need to add a permanent header in rows 1 through 7, how can this be achieved? Also how can I make a hierarchy of cells so that I can expand and collapse rows or columns?

 

[Gavona]

(Multi-line headers can be a problem if you are using excel as a database, using Autofilter etc. Consider having a zero height blank row above your last title row.)
Put the macro recorder on.
Header Row:
1.Window,FreezePanes
2.File,PageSetUp,Sheet Rows to repeat at top
Expand, collapse rows/columns:
Data, Group and Outline

Post the recorded code back if you need help manipulating it



Gavin

 

[TRHorn]

Thanks that was exactly what I needed.

 

[SkipVought]

TRHorn,

Don't forget to
[blue]
Thank Gavona
for this valuable post![/blue].

The [purple]little purple Stars[/purple] accomplish several important things.

First, it gives positive feedback to contributors, that their posts have been helpful.

Second, it identifies threads as containing helpful posts, so that other members can benefit.

And third, it identifies the original poster (that's YOU, BTW), as a grateful member, that not only receives, but is willing to give tokens of thanks.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}