| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split Windows
How can I split the worksheet - columns A - C in left pane and the rest in
the right pane - and freeze the left pane while allowing scrolling in the right pane? This used to be easy, but in Excel 2007 I can't figure it out. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split Windows
I don't use 2007, but wouldn't that require two windows rather than two panes?
Tom "dhstein" wrote: How can I split the worksheet - columns A - C in left pane and the rest in the right pane - and freeze the left pane while allowing scrolling in the right pane? This used to be easy, but in Excel 2007 I can't figure it out. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Split Windows
Choose the View ribbon tab, and there select Freeze Pane.
Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Sat, 27 Mar 2010 11:50:01 -0700, dhstein wrote: How can I split the worksheet - columns A - C in left pane and the rest in the right pane - and freeze the left pane while allowing scrolling in the right pane? This used to be easy, but in Excel 2007 I can't figure it out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
| cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
| can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
| how do i work on both workbook when using split windows | Excel Discussion (Misc queries) | |||
| Excel and split windows | Excel Discussion (Misc queries) | |||
Linear Mode
