Remove all formatting

R

ragtopcaddy

I'm looking for a method to remove all formatting from selected ranges.
The goal would be to revert to the default cell format for the selected
range.
Is there a function in Excel to do that, or can you recommend some VBA
to add a custom function?

Thanks,

Bill
 
S

SteveG

Bill,

Select your range. Go to Edit>Clear and select All. This will remove
all formats/formulas and revert back to your default settings.

HTH

Steve
 
M

Matt D Francis

Clearing all would also remove the values surely? Wouldn't

Edit > Clear > Formats

do the trick?

Matt
 
S

SteveG

You are correct. To clear just formats, selecting Format is the way to
go. I should have discerned that from the OP. Thanks

Steve
 
Top