adspace
How do I clear contents in excel but not formatting?
Answer Posted / Gaurav Ankur
To clear cell values (contents) while keeping the formatting, use the 'Clear Formats' option. You can find it by right-clicking on a cell or by going to Home > Editing > Clear > Clear Formats.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers