Delete Contents of Selected Cells in Excel or Sheets
To delete the contents of selected cells, select the cells and clear their contents; the cells themselves remain in the worksheet. In Excel, press Delete or use Home > Clear > Clear Contents; in Google Sheets, press Delete or Backspace, or choose Edit > Delete values.
What Deleting Cell Contents Means
A spreadsheet cell can contain a value, text, a formula, or formatting. Clearing contents removes the value, text, or formula while leaving the cell in place. The cell’s formatting—such as its fill color, borders, number format, and font—usually stays unless you choose a broader clearing command.
This is different from deleting cells or rows. Deleting cells can shift other data into the vacated space; deleting a row removes that row from the sheet. Clearing contents leaves the grid structure unchanged, so neighboring cells do not move.
For example, if B2 contains the number 12 and has a yellow fill, clearing its contents makes B2 blank but keeps the yellow fill. If B2 contains a formula, clearing removes the formula too; any cells that depended on it may then show an error or a different result.
Clear Selected Cells in Excel
Use this method when you want to empty cells without changing their formatting or the worksheet layout:
- Select one cell, a range, or multiple nonadjacent cells. To select a range, click and drag, or select the first cell, hold Shift, and select the last. To select separate cells or ranges, hold Ctrl on Windows or Command on Mac while selecting.
- Press the Delete key. This clears the selected cells’ contents while leaving their formatting in place.
You can also use the ribbon: go to Home > Clear > Clear Contents. The Clear menu includes other choices, so check the command before using it. Clear All removes more than contents, including formatting and other cell features.
On some keyboards, Backspace opens an editing action or behaves differently from Delete. If the selection does not clear as expected, use the ribbon’s Clear Contents command. Keyboard behavior can also differ by operating system and Excel version.
Clear Selected Cells in Google Sheets
In Google Sheets, select the cells and press Delete or Backspace to clear their values or formulas while retaining formatting. You can also right-click the selection and choose Delete values, or use Edit > Delete values.
Be precise about the menu wording: the option for clearing values is not the same as deleting cells, rows, or columns. Those structural commands can shift surrounding data or remove an entire part of the sheet. Sheets saves changes automatically, but you can use Undo immediately if you clear the wrong selection.
Choose What to Clear
Spreadsheets provide different kinds of clearing because “remove what is in these cells” can mean several things. Choose the narrowest action that matches your goal:
- Contents or values: Remove text, numbers, dates, and formulas, while retaining the cell positions and generally retaining formatting.
- Formatting: Remove visual and number-format settings without removing the underlying values or formulas. A date may display as a serial number after its date format is removed.
- Comments or notes: Remove annotations without changing the cell’s value. The wording and available commands vary by spreadsheet app.
- Everything: Remove contents and other cell properties, such as formatting. In Excel, use Clear All only when you intend this broader result.
- Cells, rows, or columns: Remove worksheet structure. Depending on the command, other cells may shift to fill the gap.
Clearing contents is often the right choice when reusing a template: it empties old entries but preserves headings, borders, colors, and layout. If you want a completely plain cell, clear formatting too; if you want the cells gone, delete them instead.
Effects on Formulas and Data
Clearing a formula cell removes the formula, not merely the result displayed in the cell. For instance, if C2 contains =A2+B2, clearing C2 removes that calculation. A formula in another cell that refers to C2 may treat the now-empty cell as zero in some calculations, while other formulas or functions may handle blanks differently.
Clearing a cell also removes any data validation or other cell-level content rules only if the chosen command includes them; behavior can depend on the application and specific command. If the cell is part of a table, protected range, or shared worksheet, restrictions may prevent editing or affect what is cleared. Check the selected range and the command before confirming a large change.
For important data, consider copying the range or making a backup before clearing it. Undo (often Ctrl+Z on Windows or Command+Z on Mac) can reverse a recent action, but it is not a substitute for a saved copy—especially after other edits or when collaborating.
Common Problems and How to Avoid Them
- The cell looks blank but is not empty: A formula may return an empty string, or the text may be hidden by formatting. Select the cell and inspect the formula bar before clearing it.
- Formatting disappeared: You may have used Clear All or a formatting command instead of Clear Contents. Undo, then use the contents-only command if available.
- Neighboring data moved: A delete-cells or delete-row command was likely used. Undo promptly, then clear contents instead.
- Only part of the intended range changed: Check the highlighted selection before pressing Delete. If a filtered list or nonadjacent selection is involved, verify which cells are actually selected.
- The command is unavailable: The sheet may be protected, or you may have only view access. Check permissions or ask the sheet owner to allow editing.
A useful habit is to read the command label and look at the selection outline before acting. The Delete key is quick, but the menu makes the distinction between clearing values, clearing all properties, and deleting worksheet structure easier to verify.
Frequently Asked Questions
Does pressing Delete remove cell formatting?
Usually not when you use the contents-only action. In Excel, Delete or Clear Contents removes contents while keeping formatting; in Google Sheets, Delete or Delete values likewise clears values without deleting the cell or its formatting.
How do I clear cells without deleting the cells?
Select the cells and use Delete or the app’s Clear Contents or Delete values command. Avoid commands named Delete cells, Delete row, or Delete column.
How do I remove formatting but keep the data?
Use the spreadsheet’s clear-formatting command, not Clear Contents. The exact menu location can vary, so check the command description before applying it to a large range.
Can I recover cell contents after clearing them?
Try Undo immediately. If the action is no longer available in the undo history, recovery may depend on saved versions, backups, or the application’s file history; do not assume deleted contents can always be restored.
Why does a cleared cell still look colored?
Clearing contents normally preserves the cell’s fill, font, borders, and number format. Clear formatting separately if you want to remove those visual settings too.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.