How do I clear contents in excel but not formatting?



How do I clear contents in excel but not formatting?..

Answer / 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

More MS Excel Microsoft Interview Questions

What is text formula in ms excel?

1 Answers  


How do you print all graphs in excel?

1 Answers  


How do you find the regression equation?

1 Answers  


How do I enable merge in excel?

1 Answers  


What is the shortcut to copy the format?

1 Answers  


What are the built in functions in excel?

1 Answers  


Can multiple users edit an excel spreadsheet at the same time?

1 Answers  


What is font style in excel?

1 Answers  


what filter is used, if more than two conditions are used or if analysis of list has to be done where there are more than two conditions?

1 Answers  


How do I do regression analysis in excel?

1 Answers  


How do I get rid of bold lines in excel?

1 Answers  


What is the extension added to excel files?

1 Answers  


Categories