insert a table in excel

P

Phil1723

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
 
G

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
 
P

phil1723

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.
 
R

RagDyeR

Fine !

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