Filter Problem in Excel 2007 Closed

Question

Hello, 
 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

Configuration: Windows XP / Internet Explorer 7.0

Sastry · Answer

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.
Sastry

Filter Problem in Excel 2007

1 response

Similar discussions

Subscribe To Our Newsletter!