Fix Excel Text Boxes Disappearing When Clicked on Mac
Question details
The user experiences an issue where clicking on a single text box in an Excel workbook causes all text boxes to instantly disappear.

- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Interacting with or editing text boxes within an Excel spreadsheet.
- Observed behavior
- Clicking one text box causes all text boxes in the workbook to vanish. Restarting the Excel application does not restore them or resolve the problem.
Ensure your macOS and Excel application are updated to the latest versions, as graphical glitches and rendering issues are frequently patched in routine software updates.
Save the Workbook in an Alternative Format (.xlsb)
Converting the file to a binary format can resolve underlying file corruption that causes text boxes and graphical objects to glitch.
File corruption or compatibility issues within standard XML-based Excel files (.xlsx) can sometimes cause display anomalies on Mac. Resaving the workbook forces Excel to rewrite the file structure.
Launch Excel and open the spreadsheet where the text boxes are disappearing.
Navigate to the top menu bar, click on 'File', and select 'Save As'.
In the 'File Format' dropdown menu, select 'Excel Binary Workbook (.xlsb)'.
Save the new file to your Mac, completely quit Excel, and then reopen the newly saved .xlsb copy to test if the text boxes function normally.

Test the Mac in Safe Mode
Booting your Mac in Safe Mode helps determine if background applications or startup items are interfering with Excel's rendering engine.
Migrate Data to a New Blank Workbook
If the problem is isolated to a specific corrupted file, moving the data to a fresh workbook will bypass the document-level glitch.
Try WPS Office for a Bug-Free Spreadsheet Experience on Mac
If Microsoft Excel for Mac continues to suffer from rendering glitches like disappearing text boxes, consider switching to WPS Office. It provides a lightweight, highly compatible alternative that accurately renders graphical objects and spreadsheets without the hassle.
- 1. Download and Install: Get WPS Office for Mac from the official website and install the lightweight suite.
- 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx or .xlsb document directly.
- 3. Edit Without Glitches: Interact with your text boxes, shapes, and data smoothly without display dropouts.

Frequently Asked Questions
Why do shapes and text boxes suddenly disappear in Excel for Mac?
This is often caused by a combination of graphical rendering bugs in specific Excel version updates (like 16.41), document-level XML corruption, or conflicts with background macOS processes affecting the display.
Does reinstalling Microsoft Excel fix the disappearing text box bug?
Reinstalling might help if the application files themselves are corrupted, but the issue is typically rooted in the specific workbook file. Testing the file in Safe Mode or saving it as an .xlsb file is a faster and more effective first step.
Will saving my file as a Binary Workbook (.xlsb) lose any formatting?
No. An Excel Binary Workbook (.xlsb) supports all the same features, formatting, and macros as a standard .xlsx or .xlsm file, but it saves data in a binary format, which is often faster to load and less prone to standard XML corruption.




