Office for Mac Issues

How to Fix Backspace Deleting the Entire Cell in Excel for Mac

Jason MillerJason Miller Oct 28, 2026 870 views

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.

How to Fix Backspace Deleting the Entire Cell in Excel for Mac
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.
Before you start

Ensure your current workbook is saved to prevent accidental data loss before modifying your application preferences.

Solution 1Recommended

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.

1
Open Excel Preferences

Click on 'Excel' in the top Mac menu bar and select 'Preferences' (or 'Settings' on newer macOS versions).

2
Navigate to Edit Settings

In the Preferences window, locate and click on the 'Edit' icon under the Authoring section.

3
Enable In-Cell Editing

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.

4
Edit the Cell

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.

Enable Edit Directly in Cells
Quick Tip: You can also press the F2 key (or Fn + F2) on your Mac keyboard to quickly enter Edit Mode for the currently selected cell.
Free Microsoft Office alternative

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. 1. Download WPS Office: Get the free WPS Office suite for Mac from the official website.
  2. 2. Open Your Excel Files: Launch WPS Spreadsheet and seamlessly open any existing .xlsx or .xls files without losing formatting.
  3. 3. Edit Intuitively: Double-click any cell to immediately begin editing your data character by character with the Backspace key.
Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsFree to use with a lightweight installation that won't slow down your MacIntuitive and familiar user interface with virtually no learning curveSeamless editing experience without complex hidden preference menus
microsoft office alternative - wps office

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.