insert a table in excel

[Guest]

how do I put a table into excel that stays on screen even when you scroll up
or down i.e what you are scrolling scrolls behind or along side the table

 

[Gord Dibben]

Phil

Investigate the use of Window>New Window then Arrange>Vertical to have two
windows side by each.

Your table in one of them and whatever else in the other.

Only other thing I could think of would be a Modeless UserForm or similar.

Gord Dibben Excel MVP

 

[Guest]

This reply was helpful although whatever data I put in the first window also
appeared in the second window So at the minute I am still trying to find a
way around this.

 

[RagDyeR]

Fine !

SO, ... now just scroll one of the windows, and the other will remain
static!