Difference between delete and clear

Solved/Closed
aysherryan Posts 3 Registration date Monday September 3, 2018 Status Member Last seen September 15, 2018 - Updated on Sep 25, 2018 at 12:14 PM
vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 - Sep 3, 2018 at 10:59 PM
Could some one explain both function ("Delete" and "Clear" in Excel) ?

1 response

vcoolio Posts 1409 Registration date Thursday July 24, 2014 Status Moderator Last seen May 23, 2024 262
Sep 3, 2018 at 10:59 PM
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.