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........
Naveen Fintech Pvt Ltd
Kolkata
CA Inter
View Details
CA Suraj Garg & Associates
New Delhi
CA Final
View Details
MANUJ SHARMA AND COMPANY
Noida
CA Inter
View Details
CCI
Pro
CAclubindia
