insert a table in excel

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

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

On Thu, 6 Jan 2005 09:43:09 -0800, "Phil1723"
<Phil1723@discussions.microsoft.com> wrote:

>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

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.

"Phil1723" wrote:

> 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

Fine !

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

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

"phil1723" <phil1723@discussions.microsoft.com> wrote in message
news:8BC69BCB-5F75-451C-AC2D-EC830506F858@microsoft.com...
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.

"Phil1723" wrote:

> 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