View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Michael M Michael M is offline
external usenet poster
 
Posts: 118
Default 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.