Clear all format from range of cells in Excel

For example, I copied and pasted a Table from a web page. The Table is very poorly formatted - I want to reformat the Table with the existing data.

excel clear all format from range of cells

To do it in Excel, here is the answer:

a) Select the entire range that needs to be reformatted.

excel clear all format from range of cells

b) Under "Home", click on "Clear" under "Editing" section. Click on "Clear Formats" as shown below.

excel clear all format from range of cells

c) All formats are removed from the range selected.

excel clear all format from range of cells

 

You can find similar Excel Questions and Answer hereunder

1) How can I get an estimate of Standard Deviation of a sample dataset?

2) I have a big Table spanning across pages when printed - how do I get Excel to print titles in all pages?

3) Millions thousands custom number formatting in Excel

4) How can I set FreezePanes in a certain range using VBA?

5) How can I find the count of records that meet multiple conditions in my raw data table?

6) Can I apply formatting to a number concatenated with a Text?

7) Sumifs with date range as criteria in Excel

8) How can I find the count of records that meet a given condition in my raw data table?

9) How can I list all files in a folder using VBA?

10) How can I loop through all ActiveX checkboxes in WorkSheet and set them to Unchecked status?

 

Here the previous and next chapter