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
- Apr 21 Sat 2007 20:37
Remove all formatting
close
全站熱搜
留言列表
發表留言