Freeze at the top & split the side in Excel97?

S

SlickRCBD

Is it not possible to freeze the titles at the top of the screen
(always show row 1 at the top of the screen) AND then split the screen
so that I can view one column on the left side independantly of the
section I'm working on on the right side?

It seems that splitting the screen cancels the freeze command, and it
won't let me freeze a row. I don't recall having this problem in Excel
2003, but it's been a while since I've used 97.

What am I doing wrong, or more properly what is the proper way to lock
the first row at the top of the screen, and let me split the screen so
that I can view one column on the side separately from the others?
 
B

Bernard Liengme

Move to B2, use command Window | Freeze Pane
Now as you scroll vertically or horizontally, row 1 and column A are always
visible
This is from Excel 2003 but I seem to recall doing the same in Excel 97
best wishes
 
G

Gord Dibben

No version of Excel has allowed a split and a freeze panes together so your
recollection is faulty.

The freezing rule is..........everything left of and above the selected cell
will be frozen.

Select B2 and freeze panes to get row 1 and column A frozen.


Gord Dibben MS Excel MVP
 

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

Any way to get Freeze Panes to work with Split View? 2
how can i see the headings at the bottom of the sheet 0
Indenting every other paragraph in Word at the same time? 0
Move Drop Down List to the Top of the Cell 0
Keep Headers at top of page 5
Margins on Word document which will not let me move them using the ruler arrows 2
Freeze the side column/top row & scroll others 2
Freeze top 2 rows - how 3

Top