Trouble Freezing Panes in Excel 2003


M

Meenie

Hi!
I recently upgraded from Office 2000 to Office 2003. I just discovered a
problem in freezing rows in Excel in 2003. I never had a problem with this in
2000.
Here's what's happeining. I have different headers for several columns. I
want to freeze the headers so as I move down the page I can see them.
I select the row all the way across under the headers. Then I go to
"windows" and click on "freeze panes" But instead of the headers being
frozen, the frozen part starts several rows below the headers AND the first
two columns are also frozen.
Why is it doing this?
Also... The first time I tried to freeze the headers, I started on the first
cell below the first header and dragged to the last cell below the last
header to select the row below the headers. When I clicked "freeze panes"
then, the first two columns disappeared entirely... I couldn't scroll to
them!
So I undid that and then I tried going to the last cell under the last
column I wanted to freeze and dragged back to the first cell, then clicked
"freeze panes" then I didn't lose any columns, but got what I described
above.
Why is my 2003 excel acting weird? Or am I acting weird? lol. Please help me!
Thanks!!
 
Ad

Advertisements

S

sephiroths816

It has everything to do with what cell you have selected. Assume you
only want the first row to be your consistent header, select cell A2
and choose the freeze panes. If you want both the first row and the
first column as consistent header and column, select B2. If you don't
select any cell, it'll do the "several rows below and etc.
 
M

Meenie

Thank you so much! That worked like a charm :D
Now I can stop being frustrated and get on with work, lol :D
 
Ad

Advertisements

Joined
Nov 15, 2021
Messages
1
Reaction score
0
It's a miracle that 14 years later, I'm still using this ancient version of Microsoft Office, the last one that uses menus instead of that abomination that's the ribbon, and finally understood how the Freeze Pane worked for rows, thank you sephiroths816!
 

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

Top