View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TheExcelAddict TheExcelAddict is offline
external usenet poster
 
Posts: 5
Default view different parts of sheet - split view

On Nov 10, 7:51*am, mami wrote:
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