how to delete unwanted rows?

in the excel file i wanted to delete the blank rows which come in between data rows. i applied the following with negative result. select entire column. auto filter. filter for blanks. got all the blank rows selected . then i pressed delete key. nothing happened.

i tried the other way and got the result. select the entire col. press f5= special blanks. go to the ribbon. delete- drop down arrow and select entire sheet rows. done

anybody tell me why the first option didn't work.

in my worksheet there are unwanted entries "3 years ago" (row numbers-2,5,10,14,19,25,31,37,43,49,55,61,67)how to delete those entries?

my worksheet contains duplicate entries(Row numbers-3,8,12,16,22,28,34,40,46,52,58,64,70). kindly tell me how to avoid the duplicate entries.

just got the idea to delete the rows which contain certain text. go to find-give the input-let excel search and give the list of all the rows which contain certain text. then go to the ribbon delete entire sheet rows-done.

Originally Posted by davesexcel

Hitting the Delete key just clears the contents, you have to right click and select delete rows.

Another way i like is to :
Select the Column
Hit F5
Select Special Cells
Select Blanks-OK
Right Click on a selected cell and select Delete
Select "Entire Row"
OK

this is what i have pointed out in my original post