Why Can't I Freeze Panes in Excel for Mac? (2011)

Are you having trouble freezing panes (rows and columns) in Excel for Mac?
I was too, until I found the solution... it's so simple too lol!
Set View to Normal
(freeze panes doesn't work in 'Page Layout' view).

[@StevePeterson]

DUDE!!! this is the thing I've been looking for for a few weeks... casually looking. I was selecting the row index and column headers not the cell I wanted to freeze!
THANK YOU!

[@yowkers]

thank you, thank you !! that was my 'greyed out Freeze Pane issue'

[@bowesman1000]

I was going bonkers trying to freeze the top 4 rows and you just cured me ! I had page layout checked and don't know why.
Thanks for this video !!!!!!!! like like like

[@modaluxe7765]

Great video. Easy to follow and very helpful. Thank you. :)

[@WinnablePanda]

Thank you!!!! So appreciate that you did this :-)

[@thinker2729]

Thank you for this! saved me a lot of time!

[@Directionerforeva123]

Thank youuuuu I was crazy trying to find out!

[@marshallsimon5354]

THANKS! for being so to the point!

[@rkonigs]

Thank you so much! You just made my day :)

[@melanietikasingh749]

Worked! Thanks.

[@alisaklein6722]

Worked perfectly, thank you

[@ryanhegarty2936]

This is great!!!!!

[@ular48]

Thanks a lot!

[@danielalba5456]

Thanks!!!

[@cserr000]

hahaha freaked me out! I thought it was my cat meowing lol

[@kristibasinger4287]

Hi! Thought your video was great. I'm in NORMAL layout. I can freeze the top row but cannot free the leftmost A date column. Did that solution happen to pop into your head since you made the vid? Thanks!

[@ctldesign939]

Thank you! I was about to rip my hair out 😂

[@REDHEADSARETOPS]

you scroll over right away to a "freeze panes" icon on the toolbar, I don't have that icon showing at all. Of course everybody is fixing the simple I WANT THE COLUMN HEADER ROW TO STAY FIXED SO I CAN SCROLL DOWN AND ADD DATE WITHOUT HAVING TO SCROLL BACK UP TO SEE WHAT COLUMN I"M IN. I did this myself about 10 years ago, but I bumped my head on a cat meowing and I[m amnesia.