Split Windows

D

dhstein

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.
 
C

Chip Pearson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Text in note pane of "normal" display suddenly much larger 1
freeze and split at the same time? 1
Cumulative formula for word table 0
Problem with MS Word paragraph and character styles: format getting messed up 2
Split cells next to 1 cell 1
Migrated outlook to G Suite server showing wrong dates 0
How do I use freeze pane and split in the same excel spreadsheet 2
Can you freeze one side of the Excel window so the other side stay 1

Top