close

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--
ragtopcaddy
------------------------------------------------------------------------
ragtopcaddy's Profile: www.excelforum.com/member.php...oamp;userid=25838
View this thread: www.excelforum.com/showthread...hreadid=517294
Bill,

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

HTH

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=517294Clearing all would also remove the values surely? Wouldn't

Edit gt; Clear gt; Formats

do the trick?

Matt

quot;SteveGquot; wrote:

gt;
gt; Bill,
gt;
gt; Select your range. Go to Editgt;Clear and select All. This will remove
gt; all formats/formulas and revert back to your default settings.
gt;
gt; HTH
gt;
gt; Steve
gt;
gt;
gt; --
gt; SteveG
gt; ------------------------------------------------------------------------
gt; SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
gt; View this thread: www.excelforum.com/showthread...hreadid=517294
gt;
gt;


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

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=517294

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()