Sorry,

After step 2, select special and then blanks;
Then step 3.


"FARAZ QURESHI" wrote:

U may also:
1. First select the data;
2. Press F5; &
3. Delete the unnecessary rows/columns.

Regards

Faraz

"SURCAL" wrote:

Thank you Michael, I did evry thing you sugested and I did not do what I
wanted to see. It is true pressing Ctrl + Shift + Down Arrow will highlight
evrything beyond the rows that contain data, but it didn't get rid of the
empty raws. By the way I am using MS office 2007.

Sincerely,

SURCAL







"SURCAL" wrote:

How can I delete all empty rows and columns to have just the cells that
contain data? I need this because, when I save the data an acess file and
then to dbf, I end up getting too many rows and columns.