Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtered cells return after saving
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return Value from a Filtered List | Excel Worksheet Functions | |||
Referencing Filtered Cells | Excel Worksheet Functions | |||
filtered cells | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Sumproduct on filtered cells | Excel Worksheet Functions |