To remove all formatting, select all the cells and select 'Clear formats' from the button present in the editing section of the Home tab. This will convert your data in the cells of worksheet into plain text and allows you to use it for storing or calculating other information.
from http://en.kioskea.net/faq/10707-excel-remove-all-cell-formatting
Write an answer
Answers (1)
To remove all formatting, select all the cells and select 'Clear formats' from the button present in the editing section of the Home tab. This will convert your data in the cells of worksheet into plain text and allows you to use it for storing or calculating other information. from http://en.kioskea.net/faq/10707-excel-remove-all-cell-formatting