buttons that don't work in the 365 version of excel

Question

I have a brand new version of 365 excel that I have to pay ransom on but not all the buttons work. How do I get the freeze button to work when it's grayed out and inoperable in any way?

Answer 1

To make the Freeze Panes button work when it is grayed out in Excel for Microsoft 365, switch the workbook to Normal view first.

1. Open the workbook in Excel.
2. Go to the View tab on the ribbon.
3. In the Workbook Views group, click Normal.
4. Still on the View tab, the Freeze Panes options should now be enabled:
   • Click Freeze Top Row to lock the first row, or
   • Click Freeze First Column to lock the first column, or
   • Select the cell below and to the right of what needs to stay visible, then click Freeze Panes.

If the Freeze commands remain disabled after switching to Normal view, an administrator policy or file protection mode may be disabling some ribbon commands; in that case, contact the administrator for the device or Microsoft 365 account.

---

References:

• Freeze panes to lock the first row or column in Excel for Mac
• Commands on the Ribbon are disabled by the administrator