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.