Deleting Data

[WynandS]

Hi, I have filtered on some criteria in excel to delete,...BUT the hidden rows also gets deleted - which i still need.

 

[DauntingGecko]

Er....rant?

 

[WynandS]

Thanks for the words of wisdom..... do you have a solution too?

 

[DauntingGecko]

I don't know what you've done or what it is you're trying to do. All you've told the world is that you've deleted something and you're not happy about it. :P

 

[Sandeep Warrier]

If you have saved the workbook then I don't think anything can be done. If you haven't saved the workbook, try Undo or close the workbook without saving and reopen.

For future reference, if you need to delete data after filtering, select the data, press Alt+; to select only the visible cells, and then delete.