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.

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.

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.