view different parts of sheet - split view

[mami]

I want to do the following:

I have one sheet that mainly has tables with data and tables with totals
from these data etc.
I would like to have something like the "split" function", i.e. half window
shows the data-tables whereas the other half window shows the totals-tables
of the same sheet. The difference with the split function, is that I would
prefer that these "half" windows show only parts of the same sheet, i.e.
half-window shows ONLY the data-tables and the other half-window shows ONLY
the totals-tables.
Is that possible?

 

[TheExcelAddict]

I want to do the following:

I have one sheet that mainly has tables with data and tables with totals
from these data etc.
I would like to have something like the "split" function", i.e. half window
shows the data-tables whereas the other half window shows the totals-tables
of the same sheet. The difference with the split function, is that I would
prefer that these "half" windows show only parts of the same sheet, i.e.
half-window shows ONLY the data-tables and the other half-window shows ONLY
the totals-tables.
Is that possible?

Mami,

1) Create a new window, (Window, New Window)
2) Tile both windows (Window, Arrange. Tiled, Windows of Active
Document)

Francis Hayes (The Excel Addict)
http://www.TheExcelAddict.com

 

[mami]

Isn't it a little bit boring and time consuming to do this every time you
want to work with the specific excel????

Open same sheet in new window, arrange view e.g. horizontal, arrange views
in each open window e.g. in one window groups are collapsed whereas in the
other one they are expanded etc etc

An apart from that.... I would like best that even in this case, the second
window-sheet shows only a part of the first window-sheet....

Asking too much ??????