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 |
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 |
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 |
All times are GMT +1. The time now is 12:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com