Hello again, Susan,

as I advised you before, apply the filter to the appropriate column,
and select Blanks from the bottom of the filter pull-down. This will
show only those rows which have blanks in that column, which are the
ones you want to get rid of.

Then you should highlight all of the rows that are visible, i.e. click
on the row identifier for the first visible row, hold down SHIFT, and
click on the row identifier of the last visible row, then release
SHIFT. These are the rows you want to delete, so while they are
highlighted click on Edit | Delete Row - now you should see nothing
below your headers, and you will need to click All from the filter
pull-down in order to see the remaining rows. You can then sort these
if you wish.

NOTE that you have to delete the rows with blanks in them - it is not
sufficient to just hide them by selecting Non-blanks from the filter
pull-down, which is what I think you are doing.

Now you should click the Save icon - I understand from your earlier
post that you have started with a .csv file, and so at this stage
Excel will warn you that you will lose some features if you save back
as a .csv. You can go ahead with the save anyway, but if you want to
avoid this message, then click on File | Save As and choose Excel
workbook in the File Type box, give the file a suitable name (or keep
it the same if you wish), then click the Save button. In this case
your original file remains unchanged, so next time you should open
the .xls (or .xlsx) file you have just saved, and that should have the
rows with blank cells removed from it.

You could then use File | Save As to save this as a .csv file -
select .csv in the File Type box and give the file a suitable name.

Hope this helps.

Pete

On Nov 18, 12:18 am, Susienak
wrote:
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