Share via

Excel(365) missing Freeze Pane option for Mac /Monterey

Anonymous
2023-03-23T19:08:45+00:00

On 'Freeze panes', click down arrow, there are only 3 commands—'unfreeze panes', 'freeze top row', and 'freeze first column'. 'Freeze Panes' command is missing so I am not able to freeze multiple rows or column.How can I handle this for a Mac - Monterey

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2023-03-23T21:56:26+00:00

    As Amit explained, the Freeze Panes button & the Unfreeze Panes button are one in the same. Yours currently reads as Unfreeze Panes because Freeze Panes already is applied.

    In order to apply the Freeze elsewhere you first need to turn the current Freeze off by selecting Unfreeze Panes [the labeling of the button will change to Freeze Panes], select the appropriate cell then turn Freeze Panes on again.

    9 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-03-23T20:13:30+00:00

    Hi,

    I am Amit, an Independent Advisor on Microsoft Support Community. For your security, please do not provide sensitive information such as product keys, passwords, email addresses and credit card information in this conversation.

    Sorry about the issue, I will try and help.

    • I am using Excel 365 on Ventura, so it’s a little different from what you said the way ‘Freeze Panes’ button appears for you. But for me here, the same button changes to ‘Freeze Panes’ and ‘Unfreeze Panes’ when I click on it.
    • To freeze multiple rows (starting with row 1), select the row below the last row you want frozen and click Freeze Panes.
    • To freeze multiple columns, select the column to the right of the last column you want frozen and click Freeze Panes.

    Please check out this link —> https://support.microsoft.com/office/b8eb717e-9d3e-4354-8c02-d779a4b404b2

    Kind regards, Amit

    3 people found this answer helpful.
    0 comments