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 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Sep 3, 2018 at 10:59 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Sep 3, 2018 at 10:59 PM
Related:
- Difference between delete and clear contents in excel
- Difference between clear chat and delete chat in viber - Guide
- Vostfr et vf difference - Guide
- How to delete whatsapp account without login - Guide
- Number to words in excel - Guide
- Position formula in excel ✓ - Office Software Forum
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Sep 3, 2018 at 10:59 PM
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.
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.
