How to delete cell formats without losing the cell content in Microsoft Excel?

Be the first to add this question to starred list!
▼Scroll down for more questions

Answers (1)

vote up or down the answers
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.

on July 23, 2014