Hi Suzie

When you are selecting Blanks, it will include the rows where there is data
in other columns in those rows, as well as the remainder of the sheet which
have not yet been used, as they will be blank also.

You might be better to Sort the whole block of your data, by the column
which contains blanks.
This will cause all of the rows with blanks to go to the end of the list.
Now delete all rows at the end of the list, where there is data in other
columns (but not the one you sorted on).
Then re-sort the whole table by whichever column you require for your sorted
list.

--
Regards
Roger Govier



"Susienak" wrote in message
...
Excel 2007... After removing columns from a document Im left with rows
that
have blanks in some of the fields. I click on the column that has blanks,
go
to data/ filter to uncheck blanks and then do a sort on the table to
alphabetize the list thats left. I save the document thinking it all looks
grteat. But when I reopen the document, the filter is not saved. the rows
that have blank fields are back. Is it because there are other cells in
the
row that are not blank? Im confused. What good is filter? I need to filter
the list to remove all rows with blanks in a particular column. None of
the
other data in the rest of the row that contains a blank matters. Why isnt
the
filter being saved? Any answers please?????

Thanks, Susan