Liann or anyone--Microsoft Excel Q

[LauraMax]

Jeez, even our IT guys can't answer this one for me.........

So I'm creating a pretty large spreadsheet & I'm trying to figure out how to make the first column & the first row static. When I highlight it & click on freeze panes it freezes like the entire top half of the doc. What the fudge? How can I freeze only one row or column? TIA.........

 

[SheWolf]

Laura - this just worked for me.

Lock rows and columns by freezing panes

1. To lock rows, select the row below where you want the split to appear.To lock columns, select the column to the right of where you want the split to appear.
   To lock both rows and columns, click the cell below and to the right of where you want the split to appear.
2. On the Window menu, click Freeze Panes.
3. To unlock rows, click Unfreeze Panes on the Window menu.

HTH!

 

[LauraMax]

Aw man, why am I having these techno glitches this week? That's exactly what I'm doing, yet for some reason it wants to lock the 2 columns to the left of the highlighted column, & 2 columns below the first row. AAAAAAAARRRRRRRGGGGGGGGHHHHHHHHH! I wanna go back to typewriters!

 

[Liann]

Laura - Only highlight the column to the right of where you want your split. Then go up to "Window" "Freeze Panes". That should do it.

Oops, I missed the part about you wanting to freeze the rows too. In that case, all you need to do is what the other poster said and only highlight the "cell" that is to the right of where you want your columns split and underneath where you want your 2 rows split. Then do the Windows, Freeze Panes.

 

[LauraMax]

OK wait, so do I need to create an empty column & row, & that's what I highlight? I am so confused! And frustrated!

 

[SheWolf]

Let's say you want to freeze just the top row and the first column. You should then highlight just the cell located in the second row in the second column. Then click freeze panes. That will freeze just the top row above and the one column to the left of your one highlighted cell.

 

[LauraMax]

It's still not working. I'm starting to think my Microsoft Office software must need an upgrade. This is the second problem this week & it's making me nuts!

Thanks guys for your help, I really appreciate it. Maybe I need to take some time off while they upgrade my 'puter.