Clear cells format in MS EXCEL 2013

Copy and Paste data from format i.e. CSV, HTML, Words, etc carried over the format that you don't want in excel. However that can be solved by removing / clear the formatting of the data in the excel itself. This tip is based on Ms Excel 2013.

All kind of format can be removed: Colors, Font Size, Font Format (italic, bold, superscript, subscript), Font type, etc. Clear all formatting will clear all the format and reset it to default.

1. Select the cells that you want to clear its format. Multiples selection of cells are allowed
2. Go to Home> Clear > Clear Format



You can also clear comments, hyperlink, and contents of the cells