View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default What are the main benifits of using the Split function?

A split screen gives you two separate views of the same sheet, each view
scrollable independent of the other.

I prefer Freeze Panes personally.

If I need two views I would use WindowNew Window and WindowArrange.

That way you can see different sheets in same workbook or in other workbooks.

Each of those two windows can also have a split or freeze panes so you get a
whole lot of viewing options.


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 09:15:01 -0800, Krazy23848
wrote:

I'm trying to figure out when I might use the Widnow = Split Screen. I'm
just looking for examples of when someone might use this over say Window =
Freeze Panes.

Thanks