View Single Post
  #4   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?

Same as earlier version.

To find the 2007 Commands see Ron de Bruin's site for illustrations.

http://www.rondebruin.nl/0307commands.htm


Gord

On Fri, 15 Aug 2008 09:01:03 -0700, Ben More <Ben
wrote:

How can I freeze the first two rows (both have headings information) in Excel
2007?

"Gord Dibben" wrote:

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