Fix Excel Freezing When Inserting a Table on Mac M1
Question details
Excel freezes or crashes on an M1 MacBook Pro when attempting to insert a table.
- Product
- Microsoft Excel
- Device & OS
- macOS (M1 Mac)
- Scenario
- Attempting to insert a table after selecting the entire worksheet.
- Observed behavior
- Excel becomes completely unresponsive or crashes, despite the worksheet containing only 1,116 cells. The same file works without issues on Windows.
Before applying these solutions, try to force quit the frozen Excel application and ensure you have enough free disk space available on your Mac to support memory swapping.
Select a Specific Cell Instead of the Entire Worksheet
Avoid selecting the entire worksheet, which attempts to format over 17 billion cells and instantly overloads Excel's memory on Mac. Instead, select a single cell within your data range.
When you click the top-left corner to select the whole sheet, Excel tries to convert every single row and column into a formatted table. Limiting the selection strictly to your active data prevents the application from freezing.
Click any single cell containing data (e.g., A1) inside your actual data range.
Navigate to the 'Insert' tab on the top ribbon and click on 'Table'.
A prompt will appear. Verify that the auto-detected range matches your actual data (for example, A1:L93).
Check the box for 'My table has headers' if applicable, and click 'OK'. The table will insert smoothly.
Update macOS, Office, and Disable Add-ins
Keep your system and Office applications updated to patch known Apple Silicon bugs, and disable conflicting third-party add-ins.
Check the Mac Disk with Disk Utility
Use macOS Disk Utility to scan and repair underlying file system errors that might be causing application instability and crashes.
Try WPS Office for Fast and Stable Spreadsheets on Mac
If Microsoft Excel continues to freeze or struggle with basic formatting on your M1 Mac, consider switching to WPS Office. It is highly optimized for Apple Silicon, completely free, and offers a smooth, crash-free experience for spreadsheet management.
- 1. Download and Install WPS: Visit the WPS website and download the Mac version. Follow the simple installation steps.
- 2. Open your Excel file: Launch WPS Spreadsheet, go to 'File' > 'Open', and select your existing .xlsx file.
- 3. Insert your table flawlessly: Select your data range and click 'Insert' > 'Table' to effortlessly create a table without performance lags.
Frequently Asked Questions
Why does Excel freeze when I select the entire worksheet to make a table?
Selecting the entire worksheet highlights over 17 billion cells. When you attempt to convert all of them into a table simultaneously, Excel tries to allocate memory for formatting every cell, which quickly exhausts your M1 Mac's memory and causes the app to freeze or crash.
How can I quickly select only my active data range?
You can simply click any single cell within your data set before clicking 'Insert Table' to let Excel auto-detect the borders. Alternatively, click inside your data and press 'Cmd + A' to highlight only the contiguous cells containing information.
Are there known compatibility issues with Excel on M1 Macs?
While Microsoft has updated Office to support Apple Silicon, some memory management issues or older third-party add-ins running via Rosetta 2 can still cause Excel to freeze during intensive rendering or formatting tasks.
What should I do if my Excel file still freezes after trying these fixes?
If the problem persists on a specific file, the workbook might be corrupted. Try copying the specific data (A1:L93) and pasting it as values into a brand new workbook, then try inserting the table again.
