Microsoft Office Tutorials and References
In Depth Information
Delete Data from a Cell
A Excel removes the cell data.
Undo Cell Data Deletion
1 Click the Undo drop-down
arrow ( ).
2 Click Clear .
Note: If the data deletion was
the most recent action you
performed, you can undo it by
or by clicking
Undo ( ) .
B Excel restores the data to the
When I delete cell data, Excel keeps the cell
formatting intact. Is it possible to delete the
data and the formatting?
Yes. Excel offers a command that deletes
everything from a cell. First, select the cell
with the data and formatting that you want to
delete. Click Home , click Clear ( ), and then
click Clear All . Excel removes both the data
and the formatting from the selected cell.
Is it possible to delete just a cell’s
Yes. Excel offers a command that deletes just
the cell formatting while leaving the cell
data intact. Select the cell with the
formatting that you want to delete. Click
Home , click Clear ( ), and then click Clear
Formats . Excel removes just the formatting
from the selected cell.