View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ms-Exl-Learner Ms-Exl-Learner is offline
external usenet poster
 
Posts: 506
Default 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