Difference between delete and clear [Solved/Closed]

Report
Posts
3
Registration date
Monday September 3, 2018
Status
Member
Last seen
September 15, 2018
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
Could some one explain both function ("Delete" and "Clear" in Excel) ?

1 reply

Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
213
Hello Aysherryan,

Delete means just that, delete. If, for example, you high-light an entire row of data then right click and select delete, you'll notice that the entire row disappears and all the subsequent rows move up one spot. It is gone forever.

If you select "Clear" instead, all the data (including all formulae, values, formats etc.) are cleared from that row but the row remains as a blank row.

If you select "ClearContents", then only the cell values and formulae are cleared. Formats will remain and the row will remain in place.

I hope that this helps,

Cheerio,
vcoolio.
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2904 users have said thank you to us this month