How to Fix Backspace Deleting the Entire Cell in Excel for Mac
Question details
The user is trying to delete individual characters within a cell but finds that pressing the Backspace key clears the entire cell's contents instead.

- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Editing text and data inside a spreadsheet cell using the keyboard.
- Observed behavior
- Pressing the Backspace key removes all text and data within the active cell rather than deleting a single character.
Ensure your current workbook is saved to prevent accidental data loss before modifying your application preferences.
Enable Edit Directly in Cells
This is the primary solution to allow character-by-character editing inside a cell using the Backspace key.
By default, if you simply click a cell once to select it, pressing Backspace clears the entire cell. To delete individual characters, Excel requires you to enter 'Edit Mode'. If 'Edit directly in cells' is disabled in your preferences, you will be forced to use the formula bar for granular edits.
Click on 'Excel' in the top Mac menu bar and select 'Preferences' (or 'Settings' on newer macOS versions).
In the Preferences window, locate and click on the 'Edit' icon under the Authoring section.
Check the box next to 'Double-click to edit directly in cells' (or similar wording depending on your Excel version) and close the Preferences window.
Double-click the cell you want to modify, place your text cursor next to the character you wish to remove, and press the Backspace key.

Restart Excel and Update Microsoft AutoUpdate
If the preference is already enabled but the issue persists, a software glitch may be responsible. Restarting and updating can resolve this.
Experience Hassle-Free Spreadsheets with WPS Office for Mac
If you are tired of troubleshooting settings and unexpected software behaviors in Microsoft Excel for Mac, consider switching to WPS Office. It provides a lightweight, highly compatible, and user-friendly spreadsheet environment where features work intuitively right out of the box.
- 1. Download WPS Office: Get the free WPS Office suite for Mac from the official website.
- 2. Open Your Excel Files: Launch WPS Spreadsheet and seamlessly open any existing .xlsx or .xls files without losing formatting.
- 3. Edit Intuitively: Double-click any cell to immediately begin editing your data character by character with the Backspace key.

Frequently Asked Questions
Why does pressing Backspace clear the whole cell instead of one letter?
If a cell is only highlighted (selected) but not in 'Edit Mode', pressing Backspace or Delete signals the application to clear the cell's entire contents. You must enter Edit Mode by double-clicking the cell or pressing F2 to delete individual characters.
Can I edit cell contents without enabling 'Edit directly in cells'?
Yes. Even if direct in-cell editing is disabled, you can single-click the cell to select it, and then click inside the formula bar at the top of the Excel window to edit, add, or delete individual characters.
Where is the Edit menu located in Excel for Mac preferences?
You can find it by clicking on 'Excel' in the main Apple menu bar at the top left of your screen, selecting 'Preferences' (or 'Settings'), and then clicking on the 'Edit' option located under the Authoring section.




