Difference between Delete and Clear [Solved]

aysherryan 3 Posts Monday September 3, 2018Registration date September 15, 2018 Last seen - Sep 3, 2018 at 08:57 AM - Latest reply: vcoolio 1195 Posts Thursday July 24, 2014Registration dateModeratorStatus September 22, 2018 Last seen
- Sep 3, 2018 at 10:59 PM
Could some one explain both function ("Delete" and "Clear" in Excel) ?
See more 

Your reply

1 reply

Best answer
vcoolio 1195 Posts Thursday July 24, 2014Registration dateModeratorStatus September 22, 2018 Last seen - Sep 3, 2018 at 10:59 PM
3
Thank you
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.

Thank you, vcoolio 3

Something to say? Add comment

CCM has helped 1854 users this month

Respond to vcoolio