Can i reduce my file that's 29 MB but filled with blank cells?

I used a macro to import data into a new worksheet. there isn't a great deal
of info the spreadsheet (probably about 29KB) but the worksheet has a size in
excess of 29MB. It seems to be filled with blank cells (no formulae) as the
scroll bar on the right is tiny and if you drag it to the bottom the row
number shows 60-odd thousand. How can I reduce this file so it just saves the
cells with data? The worksheet itself does not have a macro within it.

save it as a .CSV file?

zapadias, have a look here and see if this helps

http://www.contextures.com/xlfaqApp.html#Unused
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"zapadias" <[email protected]> wrote in message
news:[email protected]...
>I used a macro to import data into a new worksheet. there isn't a great
>deal
> of info the spreadsheet (probably about 29KB) but the worksheet has a size
> in
> excess of 29MB. It seems to be filled with blank cells (no formulae) as
> the
> scroll bar on the right is tiny and if you drag it to the bottom the row
> number shows 60-odd thousand. How can I reduce this file so it just saves
> the
> cells with data? The worksheet itself does not have a macro within it.

Check Debra Dalgleish's website:
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> I used a macro to import data into a new worksheet. there isn't a great deal
> of info the spreadsheet (probably about 29KB) but the worksheet has a size in
> excess of 29MB. It seems to be filled with blank cells (no formulae) as the
> scroll bar on the right is tiny and if you drag it to the bottom the row
> number shows 60-odd thousand. How can I reduce this file so it just saves the
> cells with data? The worksheet itself does not have a macro within it.
>