See/work with multiple sheets at the same time
 

I want to show multiple sheets in the screen, without removing excel's menus
and toolbars and without displaying their's title bars. My intention is to
show many information on the screen at the same time, without leting the user
know i'm using many sheets to do that and with every kind of information
scrolling in its own place. Like this:
- On the left of the screen i'll have one sheet, using 1/4 of the screen,
where i can scroll up and down without changing the appearance of the center
and right sheets i'll explain later;
- At the center of the screen, i'll have another sheet with it's own
scrolling too;
- On the right of the screen, i'll have another sheet with it's own
scrolling and information.
It will be like a dashboard with many information in the screen, but letting
the user scroll through some of them, change them and see what happens to the
other sheet.
What i'm trying to do is replicate the almost the same functionality we have
at www.mvelopes.com in excel.

Can somebody help me?
Thanks.

See/work with multiple sheets at the same time
 

If the sheets are all in the same book try selecting windownew window and
then windowarrange windowvertical
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Glauco" wrote:

I want to show multiple sheets in the screen, without removing excel's menus
and toolbars and without displaying their's title bars. My intention is to
show many information on the screen at the same time, without leting the user
know i'm using many sheets to do that and with every kind of information
scrolling in its own place. Like this:
- On the left of the screen i'll have one sheet, using 1/4 of the screen,
where i can scroll up and down without changing the appearance of the center
and right sheets i'll explain later;
- At the center of the screen, i'll have another sheet with it's own
scrolling too;
- On the right of the screen, i'll have another sheet with it's own
scrolling and information.
It will be like a dashboard with many information in the screen, but letting
the user scroll through some of them, change them and see what happens to the
other sheet.
What i'm trying to do is replicate the almost the same functionality we have
at www.mvelopes.com in excel.

Can somebody help me?
Thanks.

See/work with multiple sheets at the same time
 

Same method can be used even if they are in separate workbooks.


Gord Dibben MS Excel MVP

On Wed, 14 Mar 2007 06:23:03 -0700, John wrote:

If the sheets are all in the same book try selecting windownew window and
then windowarrange windowvertical