Previous Topic Next Topic

Filter Problem in Excel 2007

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

Related:

1 response

Answer 1 / 1
Sastry
Jan 17, 2011 at 05:11 AM
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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses