Clear excess formats in Excel 2007
 

My old version of Excel (97) had a option (clear excess formats in
"bookname") on the "File" menu that would reduce the size of a worksheet by
removing all the excess rows & columns. I can't seem to find how to do this
in Excel Enterprise 2007.
Can anyone help?

Clear excess formats in Excel 2007
 

Home tab click on the eraser icon and choose one of the options.


"Don" wrote:

My old version of Excel (97) had a option (clear excess formats in
"bookname") on the "File" menu that would reduce the size of a worksheet by
removing all the excess rows & columns. I can't seem to find how to do this
in Excel Enterprise 2007.
Can anyone help?

Clear excess formats in Excel 2007
 

I believe you are referring to an add-in that Microsoft provided.
This site seems to answer your question
"How to reset the last cell in Excel" at
http://support.microsoft.com/kb/244435
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Don" wrote in message
...
My old version of Excel (97) had a option (clear excess formats in
"bookname") on the "File" menu that would reduce the size of a worksheet
by
removing all the excess rows & columns. I can't seem to find how to do
this
in Excel Enterprise 2007.
Can anyone help?

Clear excess formats in Excel 2007
 

Sorry TM but that did not work

"Teethless mama" wrote:

Home tab click on the eraser icon and choose one of the options.


"Don" wrote:

My old version of Excel (97) had a option (clear excess formats in
"bookname") on the "File" menu that would reduce the size of a worksheet by
removing all the excess rows & columns. I can't seem to find how to do this
in Excel Enterprise 2007.
Can anyone help?