"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Ian

Just "Clearing" will not do the trick.

You must EditDelete the unused column and rows.

And as you mentioned......Save, close and re-open to see changes in size.

Gord Dibben Excel MVP

On Thu, 16 Dec 2004 22:32:36 -0000, "Ian Ripsher"

wrote:

Thanks. Edit | Clear has *always* done the trick for me in XL 2k or 2003.
Perhaps Del Rows/Cols is needed for earlier versions? Also, I believe that
Save, Close & Open is required for versions < XL 2k (although I always do
that for good measure anyway under Xl 2k at work / 2003 at home)?