Do you know how to freeze panes on the same column and row at the same time on multi sheets? I can do this in Lotus with a simple keystroke, but can't figure out how to do it in Excel. Thanks
I see that you froze both the row and the left column for scrolling horizontally and vertically, but what if you want to scroll diagonally like to the bottom right? When I scroll down and right the frozen panels vanish.
you rock!
I SPENT 2 hours trying to figure out how to freeze pane rows and columns.
Pretty simple explanation indeed. Now I'm equipped to pass any Excel 2007 test...NICE!
Thank you SOOOOO Much!!! This legitimately saved my job!!! Excel I now own you!!!
How could anyone give this a thumbs down? Thanks for the post!
Thank you so much for this video! It has helped me so much and I now totally understand how to freeze panes on excel :D
Thanks, always wanted to be able to do that! Spent years scrolling left and right.
I accidently saw the wrong video but this actually helped! xD thanks!
Muchas gracias.. Esta muy bien! Resolvió mis dudas
THANK YOU....... ye gods that's a strange way to arrange that function but you helped immensely.
Skip to @2:00
You're welcome.
This explanation was great! Thank you so much!!!!!!!!!!!!!
Thank you so much, Sir.
Do you know how to freeze panes on the same column and row at the same time on multi sheets? I can do this in Lotus with a simple keystroke, but can't figure out how to do it in Excel. Thanks
thank you so much for this tutor...very very useful!!!!!
Thanks, for this great tutorial.
Thanks a billion!
In what version of Excel did this feature stop working? I am using 2010 and it does not work for me?
I see that you froze both the row and the left column for scrolling horizontally and vertically, but what if you want to scroll diagonally like to the bottom right? When I scroll down and right the frozen panels vanish.
Thanks your tutorial
thanks for the help.
Thanks for the quick assist!
Thank You so much
Thanks. It's very easy to work in sheet
oh god, thank you! i couldn't freeze both first row and column... it kept doing weird things before
Great explanation...thanks!
Thanks
Thank u so much sir
I want to freeze a "SELECTED" piece of panes but I dont think there is a function for this.
well explained
Excellent!
thanks
Thanks very much bro. Cell C2 magic CELL.
It was useful, thank you
Important note is must be in normal view. Doesn't work if in page layout view
good its helpfull
Thanks!
very helpful thank you sir ...)
cool!!!
very nice to meat version of 10 excel
thanks!
thanks really good
Thank u ))
nice thanks
^_^
Thanks