why is it when you filter a table, and you delete those items that are filtered, when you show all again you do not always show the complete remaining records (some are missing)

ie. i have a table that shows a number of invoice details in rows, some are marked X, some are marked C. I filter showing only the rows with an X. then delete these. when I show all not all the C records remain (I have deleted some of them)

is there a way to avoid this?

Dear Neil

Thank you for attending Excel Advanced Course.

Please remember that by Filtering data you are simply hiding the records that you don't want to see and displaying the records that you are interested in. Therefore by Applying the Auto Filter or Advanced Filter it hides rows as well. Therefore, when you delete certain rows containing e.g. C or X as they are not together it deletes all the rows in between.

The best way I can suggest you to do this is to do a simply sort on the filed (Column where it says C or X and when the entire C and X are together select all the rows that you require and right click and Choose Delete from the shortcut menu.

I hope this helps.

Please mark this question as Resolved it has answered your query otherwise please press the reply button and ask your specific query.

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003