Fix Excel for Mac Freezing When Opening Format Cells
Question details
The user is experiencing a complete system freeze on their Mac when attempting to open the Format Cells dialog in Microsoft Excel.
- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Right-clicking a cell and selecting 'Format Cells' to adjust data formatting in a spreadsheet.
- Observed behavior
- Excel version 16.74 completely freezes, causing the entire Mac system to hang and requiring a hard restart. This persists even after standard application reinstalls.
Before troubleshooting, ensure you save any open work in other applications, as testing these solutions may require a forced system shutdown if your Mac hangs.
Update macOS and Disable Faulty Add-ins
Keeping your software up to date and disabling problematic add-ins like 'Money in Excel' can resolve deep formatting crashes.
Software conflicts between specific Excel builds (like 16.74) and macOS can cause memory loops resulting in complete freezes. Disabling unnecessary add-ins removes potential third-party interference.
Open Excel, navigate to the 'Insert' tab on the ribbon, and select 'My Add-ins'.
Look for the 'Money in Excel' add-in or any newly installed extensions. Temporarily disable or remove them.
Click 'Help' > 'Check for Updates' in the top Apple menu bar to ensure you are running the latest version of Excel.
Open 'System Settings' > 'General' > 'Software Update' to check if a newer macOS patch is available to fix system-level hangs.
Test Excel in a New macOS Standard Account
Creating a new user account helps determine if the freezing is caused by background software or corrupted user profile preferences.
Contact Microsoft Support for Deep Investigation
If basic troubleshooting and a clean Mac profile do not stop the freezing, the issue requires deep log analysis from Microsoft engineers.
Avoid Mac Freezes with WPS Office
If Microsoft Excel continues to crash or freeze your Mac during simple tasks, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative that seamlessly handles all your spreadsheet formatting needs without bogging down your system.
- 1. Download WPS Office: Download and install the free WPS Office suite for Mac from the official website.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets and click 'Open' to browse for your existing .xlsx file.
- 3. Format Cells Smoothly: Right-click any cell and select 'Format Cells' to edit your data instantly, free of system crashes.
Frequently Asked Questions
Why does Excel freeze my entire Mac when I click Format Cells?
This is typically caused by corrupted application preferences, conflicts with specific add-ins (like Money in Excel), or a known memory leak in specific Office builds (such as version 16.74) that disrupts macOS management.
Will reinstalling Excel for Mac fix the Format Cells crashing issue?
A standard reinstall may not resolve the issue if the root cause lies in leftover corrupted hidden files in the Mac Library folder or system-level profile conflicts. A complete, clean uninstall is usually required.
How do I completely remove Microsoft Office from my Mac to fix freezing?
Completely removing Office requires dragging the applications to the Trash and also manually deleting specific hidden cache and preference folders (like UBF8T346G9.Office) from the macOS ~/Library/Group Containers directory.
Can I format cells without right-clicking to avoid the freeze?
You can try using the keyboard shortcut Command+1 or navigating to the Home tab on the ribbon and clicking the 'Format' dropdown. However, if the underlying dialog component is bugged, these methods may still trigger the freeze.
