Hi, Thanks. I tried that and much to my surprise an empty worksheet with 100
rows or 50,000 rows was the same size file.

Now I have another problem. I have another sheet in this WB with about
75,000 rows of which after filtering only about 25,000 rows are needed, the
rows with good data can be identified as the cells in Column D that have a
value greater that 0 a quick sort can place all these at the top of the
worksheet. Once this is done I want to delete all the data from the other
columns/rows below row 25,000. I need a solution that can be placed in a
macro to run and one that will find the 0 value cell as the next worksheet
may only have 2200 lines of good data s I cannot fix the macro to line 25000.

again, the goal is the same - to minimize the size of the file to be saved
to disk

"Pranav Vaidya" wrote:

Excel will never remove the blank cells. These are for display only and does
not affect your workbook size etc. If you don not wish to see them, just
select the desired rows, cols and hide them.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"ewb1017" wrote:

The process you gave removes all data entered into the worksheet which is not
what I think was requested.
I have a similar problem. I need to reduce worksheets to a minimum size and
so want to minimize the number of rows and columns to a minimum (especially
rows). It seems that Excel does not shrink the size of the worksheet
automatically, I may have 50,000 to 65,000 rows of raw data when I start, by
the time I filter out bad and unnecessary data I could have it reduced to
5000 rows, all the rest are now blank but Excel does not remove the blank
cells. How can I do that ?

Regards
Ed
"Pranav Vaidya" wrote:

I am not sure if you want to remove the used cells etc, however this might
help..

go to cell A1 on the desired worksheet
hit CTRL+SHIFT+END this will select the editted region on the worksheet
hit CTRL+ - (hyphen) this will delete all the cells
save the work book.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Irishcauffey" wrote:

I am working with a very large workbook and need to remove unformated or used
rows and columsn. I am new to excel and need some help please.