Forum Discussion

acroom's avatar
acroom
Copper Contributor
Jan 14, 2023

Freeze panes

Hi there,   I am using Excel for Mac Version 16.68 via a Microsoft 365 Subscription through my work. I was trying to freeze panes (columns and rows) in a spreadsheet and I noticed that I am no long...
Excel on Mac
mathetes's avatar
mathetes
Silver Contributor
Jan 14, 2023

acroom 

 

I'm also on a Mac, Excel version 16.70, same 365 Subscription

 

I see the ability to freeze panes. That icon in the tool bar (image below) shows only the top row and left most column, but that's just an icon. If you put your cursor in cell C6, for example, before clicking that tool bar icon, it freezes the rows above and columns to the left...... just as it always has.

 

  • Hollydays's avatar
    Hollydays
    Copper Contributor
    Dec 14, 2023
    Hi Mathetes, This had been so frustrating for me as well. Thank you!
  • acroom's avatar
    acroom
    Copper Contributor
    Jan 17, 2023

    Hi mathetes 

     

    Thank you for your response.

     

    Strangely, I definitely don't have that icon. I will have to do some more investigating to try and find out why..

     

    • acroom's avatar
      acroom
      Copper Contributor
      Jan 17, 2023
      Ah! I figured it out! Apparently I had a frozen pane somewhere in the spreadsheet that I didn't know about. Clicking 'Unfreeze Panes' has given me the option to 'Freeze Panes' again!

Resources