1. filter the data, as that date must be visible (this is you want to delete)
2. Select the data and go to home in ribbon of excel and select the "find & select" button an click on "Go To Special"
3. Check visible cells only. This will now select only the visible cells that you wish to delete
4. Click delete>rows of sheet. ok
pls share this, excel user are demanding this type of info
Thanks Sir........
Gupta Sachdeva & Co. Chartered Accountants
New Delhi
CA Final
View Details
CAclubindia
