deleting empty rows

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

Greetings,
I imported some data into my spreadsheet. Now I have several blank rows
scattered throughout all 1500 rows. Is there an easy way to delete the
empty
rows ?

thanks,
Darryl
 
Open your table and sort ascending on a field that contains a blank, then
highlight all the empty rows by using the far left side of the rows and
dragging down to the end and hit delete. Make sure you only select those
rows that are empty as once you delete they are gone.
 
Just click on a column in an empty row and then click the Sort (A_Z) button.
All of the empty rows should appear together at the top of your table.
 
Darryl,

You can create a delete query where it looks at the rows and deletes all
rows that have null values
 
Back
Top