Learn › Excel › Empty cells

Excel Delete key: Delete

Empty the selected cells with one key, and bring them back with Ctrl + Z.

← All Excel shortcuts

With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.

WindowsDelete
MacDelete

Keys on keyboards of other languages

The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.

English (US)Delete
HrvatskiDelete
DeutschEntf
EspañolSupr
FrançaisSuppr
PortuguêsDelete
ItalianoCanc
TürkçeDelete
Bahasa IndonesiaDelete
PolskiDelete

What it does

The Delete key empties the contents of every selected cell. The cells stay in place, and their format stays too. Nothing moves, there is no gap in the table.

When to use it

Use it to clear old data or a mistake. Select a block of cells and one press empties all of them. It is faster than deleting the text cell by cell.

How to do it

  1. Select the cells you want to empty.
  2. Press Delete.
  3. The cells are empty at once. Press Ctrl + Z if you want them back.
Good to know: Delete does not remove rows or columns. To delete the cells themselves and shift the rest, use the Delete command from the right-click menu.

A quick example

In the task list, select A3 and B3 and press Delete: both cells are empty at once. Press Ctrl + Z and they come back.

Delete, cut and Backspace

Delete empties the selected cells. Cut (Ctrl + X) empties them too, but keeps the data ready to paste. Backspace empties only one cell and starts editing it.

Not working? Check this

  • Nothing happens: click into the sheet first, not into the formula bar or a search box.
  • Only one word was removed: you were editing the cell. Press Enter first, then select the cell and press Delete.
  • The format is still there: Delete empties the contents, not the format. Use Clear All from the Home tab to remove both.
  • Your laptop has no separate Delete key: it is often Fn + Backspace.

Quick answers

How do I empty a cell in Excel?

Select it and press Delete. The contents disappear and Ctrl + Z brings them back.

Does Delete remove the format too?

No, only the contents. The format stays. Use Clear All on the Home tab to remove both.

What is the difference between Delete and Cut?

Delete just empties the cells. Cut empties them too, but you can paste the data somewhere else.

← All Excel shortcuts

Chrome extensions

Free web tools

Free games