Use the macro at
Why do my scrollbars go to row 500 -- my data ends in cell E50?
http://www.contextures.com/xlfaqApp.html#Unused

If that does not work you will have to provide information on what you
mean by "the work area I need".i

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sol42" wrote in message ...
My work sheets keep growing larger even though nothing is entered into the
cells.
How can I maintain the work area I want with an error making my workbook
grow from several hundred Kbytes to several Mega bytes. Very time consuming
for saves over the internet.
Is there a way I can reduce the sheets back down to the work area I need.