Add-on to Removes formatting and formulas on unused cells and therefore shrinks size

[djboston]

Hey everyone! I am looking for a specific Add on for Excel. Here is what I need it to do. Removes formatting and formulas on unused cells and therefore shrinks the spreadsheet size. Any help would be useful, and very helpful. I have found one in the past, but due to the user crashing his HDD, it was lost forever.

[Richard Buttrey]

Hey everyone! I am looking for a specific Add on for Excel. Here is what I need it to do. Removes formatting and formulas on unused cells and therefore shrinks the spreadsheet size. Any help would be useful, and very helpful. I have found one in the past, but due to the user crashing his HDD, it was lost forever.

If you don't find it, you might like to consider a VBA macro to do the same thing.

Rgds

[dominicb]

Good morning djboston

...and welcome to the forum!!

You could download my add-in via the link below : this has a large number of utilities, one of which will do what you require. Once installed go to Ultimate > Optimise > Optimise Worksheets.

HTH

DominicB