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 |
What is text formula in ms excel?
How do you print all graphs in excel?
How do you find the regression equation?
How do I enable merge in excel?
What is the shortcut to copy the format?
What are the built in functions in excel?
Can multiple users edit an excel spreadsheet at the same time?
What is font style in excel?
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?
How do I do regression analysis in excel?
How do I get rid of bold lines in excel?
What is the extension added to excel files?