Freeze a column and a row at the same time
Solved
Nanie
-
Yugs -
Yugs -
Hello,
I work with EXCEL 2000 (yeah, I know it's old ...) and I would like, if possible, to be able to freeze my first row and my first column in my table.
I can do one or the other but not both at the same time ....
Does anyone have a solution?
Thanks a lot in advance
Configuration: Windows XP / Internet Explorer 7.0
I work with EXCEL 2000 (yeah, I know it's old ...) and I would like, if possible, to be able to freeze my first row and my first column in my table.
I can do one or the other but not both at the same time ....
Does anyone have a solution?
Thanks a lot in advance
Configuration: Windows XP / Internet Explorer 7.0
3 réponses
Hello,
If you place your cursor just below the row to be frozen and just to the right of the column to be frozen, then go to the menu and choose "Window" and then "Freeze Panes," it should work.
Did God create the brain, or is it the other way around?
Blessed are the simple-minded, for theirs is the kingdom of heaven.
If you place your cursor just below the row to be frozen and just to the right of the column to be frozen, then go to the menu and choose "Window" and then "Freeze Panes," it should work.
Did God create the brain, or is it the other way around?
Blessed are the simple-minded, for theirs is the kingdom of heaven.
I had the same question, there are dozens of posts about it but this one is the only clear one.
Place the cursor and click on the cell below the row to freeze and to the right of the column to freeze. That's it! Thank you.