Filter Problem in Excel 2007
Closed
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
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:
- Filter Problem in Excel 2007
- Save as pdf office 2007 - Download - Other
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- Safe search filter - Guide
1 response
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
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
