Deleting all empty raws and columns.

[SURCAL]

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.

 

[Michael M]

Hi
Go to the row after the last row of data, click on the row header and then
press Ctrl +Shift +Down Arrow. This will highlight all the rows from the last
row down.
Right click on the row header again and select delete.
Do the same with the column after the last column of data and press
Ctrl+Shift +Right arrow, click on the column header and select delete.
You will now only have the columns and rows that contain data.

Regards
Michael M

 

[SURCAL]

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

 

[Michael M]

I don't believe you can actually "remove" the rows, but you can hide them so
the area below the data is blank.
Follow the same process as mentioned previously but use Hide, instead of
delete
Regards
Michael M

 

[FARAZ QURESHI]

U may filter the data by Data > Filter > Auto Filter

Select blanks from any of the filter

Select all the empty rows and delete by Alt+E, D

 

[FARAZ QURESHI]

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

Regards

Faraz

 

[FARAZ QURESHI]

Sorry,

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