How to quickly remove ALL formatting on a sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 04 Feb 2008 15:55 GMT

I usually just do a control+A and hit delete but this does not remove any
formatting (font, background, borders, alignment).

Is there any quick way to do that (short of deleting the sheet)

Any help here will be appreciated.

Thanks in advance
Dave

Reply to this Message

Dave - 04 Feb 2008 16:03 GMT

OK - I found Edit/Clear/All

which seems to do what I want
EXCEPT
Put the row/column sizes back to standard

Is that doable?

dave

> I usually just do a control+A and hit delete but this does not remove any
> formatting (font, background, borders, alignment).
[quoted text clipped - 5 lines]
> Thanks in advance
> Dave

Reply to this Message

Ron Coderre - 04 Feb 2008 16:22 GMT

If you just want to remove *everything*...

Maybe just:
[Ctrl]+A (twice with some versions of Excel to select the entire sheet)
<edit><delete>...Which will remove all rows

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> OK - I found Edit/Clear/All
>
[quoted text clipped - 15 lines]
>> Thanks in advance
>> Dave

Reply to this Message

Dave - 04 Feb 2008 16:41 GMT

Yep - that seems to be what I needed.

Thanks

Dave

> If you just want to remove *everything*...
>
[quoted text clipped - 31 lines]
>>> Thanks in advance
>>> Dave

Reply to this Message

Ron Coderre - 04 Feb 2008 16:49 GMT

I'm glad I could help......and thanks for the feedback.

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

> Yep - that seems to be what I needed.
>
[quoted text clipped - 37 lines]
>>>> Thanks in advance
>>>> Dave

Reply to this Message