Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What are the main benifits of using the Split function?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What are the main benifits of using the Split function?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
How can I use Excel to solve an equation? | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |