Deleting all empty raws and columns.
 

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.

Deleting all empty raws and columns.
 

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" 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.

Deleting all empty raws and columns.
 

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.

Deleting all empty raws and columns.
 

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

"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.

Deleting all empty raws and columns.
 

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

"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.

Deleting all empty raws and columns.
 

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.

Deleting all empty raws and columns.
 

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.