clear all format from range of cells in Excel

Q124. In Excel, how can I clear all formats (formats alone not data) from a range of cells?

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 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 excel excel clear all format from range of cells

c) All formats are removed from the range selected.

excel excel excel excel clear all format from range of cells


You can find similar Excel Questions and Answer hereunder

1) Vlookup to return max value from multiple hits in Excel

2) How can I identify all cells with Conditional Formatting in my WorkSheet?

3) How do I copy a Table from one location to another and retain all formulas, formats and columnwidths?

4) How can I set up a dynamic named range that expands automatically when new items are added to the list?

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

6) how to combine the content of two or more cells in Excel

7) How can I delete all shapes in a WorkSheet?

8) How can I add a Prefix to a set of numbers in a range?

9) I have a WorkBook that loads a form automatically when it is opened. In Excel, how can I suppress the form from loading on file open when required?

10) How can I extract file name from a full path including folder path and file name?

11) How can I edit names of all the Shapes in the WorkSheet easily instead of navigating to each Shape and renaming them?

12) I have WorkBook with sensitive confidential information - how do I encrypt / protect my file so that access to file contents is restricted?

13) How can I find the slab in which a given value fits?

14) Is there a way to easily shade alternate rows in a data range for improving readability?

15) How can I clear cell after activating a routine when there is a change in value of a cell?