Filter Problem in Excel 2007 [Closed]

 Sastry -
Im Xishan, using excel 2007 & facing problem while delteing rows of filtered data. When i delete filtered rows, other rows(unfiltered ones) also get deleted. Please help me because i usually work on a huge data files normally contains more than 100 thousand rows

1 reply

Hi Xishan.

There is one solution... Use "ALT"+";" after selecting required rows/columns, by which you are selecting only visible data (without getting the hidden/filtered data selected). Even if you delete now, only selected - visible data will be deleted. However, if you are selecting a large range of data, and press "ALT"+";" excell will will give you an alert mentioning that it cann't handle action.

Hope the above would be useful for you.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!