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


Please Help Members By Posting Answers For Below Questions

Which is latest version of excel?

721


Why can't I see the tabs on my excel spreadsheet?

723


Image result for how do I compare two columns in excel

667


What is left formula in excel?

683


How much is excel for ipad?

713


What is wrap text in excel?

720