Remove contents, hyperlinks, or formatting

You can clear cells to remove the cell contents (formulas and data), formats (including number formats, conditional formats, and borders), hyperlinks, and any attached comments. The cleared cells remain as blank or unformatted cells on the sheet.

  1. Select the cells.

  2. On the Edit menu, point to Clear, and then do one of the following:

To clear

Click

Everything that is contained in the selected cells

All

Only the formats that are applied to the cells

Formats

Only the contents in the cells, leaving any formats and comments in place

Contents

Any comments that are attached to the selected cells

Comments

Only the hyperlink, leaving the contents and any other formats or comments in place

Hyperlinks

Notes: 

  • If you click a cell and then press DELETE , Excel clears the cell contents but does not remove comments or cell formats.

  • If you clear a cell, the value of the cleared cell is 0 (zero), and a formula that refers to that cell receives a value of 0.

  • To remove cells from the sheet and shift the surrounding cells to fill the space, select the cells that you want to delete, and then on the Edit menu, click Delete, and then select the option that you want.

  • To select a cell that contains a hyperlink, click the cell and hold down the mouse button for at least one second, and then release the mouse button.

See also

Display or hide cell values

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×