How to quickly remove ALL formatting on a sheet

D

Dave

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
 
D

Dave

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
 
R

Ron Coderre

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)
 
D

Dave

Yep - that seems to be what I needed.

Thanks

Dave

Ron Coderre said:
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)

Dave said:
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
Click to expand...
Click to expand...
 
R

Ron Coderre

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

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

Regards,

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


Dave said:
Yep - that seems to be what I needed.

Thanks

Dave

Ron Coderre said:
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)

Dave said:
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).

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

Any help here will be appreciated.

Thanks in advance
Dave
Click to expand...
Click to expand...
Click to expand...
 
Top