Filter Problem in Excel 2007

Xishan - Jan 14, 2011 at 12:04 AM
 Sastry - Jan 17, 2011 at 05:11 AM
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.