Freeze columns and rows doesnt seem to work

[colwise]

I am trying to freeze rows 1,2,3 and 4 along with columns a,b,c,d,e,and f. But for some reason it will only freeze a total block (a thru to n) and (1 thru to 26) any solution would be much appreciated. Just noticed that the row height on some of the rows needs resetting to 20. but this dont affect the freezing

[NeedForExcel]

Click on Cell G5 and then Freeze Panes..

[TMS]

As NeedForExcel has said, Unfreeze Panes, select cell G5, then choose View, Freeze Panes, Freeze Panes.

Works for me.


Regards, TMS

[colwise]

4 hours of messing about and you lot do it in 10 seconds - thanks very much

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[NeedForExcel]

Glad I could help..

And thank you for the Rep..