delete only visible rows in filter mode
I am also faced this problem, in that case I used to delete the 500 rows
first and another 500 rows next like that€¦ If I delete the whole unwanted
rows at a single time when it is in filter then it is getting deleted.
--------------------
(Ms-Exl-Learner)
--------------------
"ajezmohd" wrote:
I use filter for a range of data but when I try to delete some visible rows (
while in filter mode ) it also delete unvisible rows
Im using Excel 2007 with Vista
|