Filter Problem in Excel 2007

 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.