Friday, July 1, 2011

Filter And Copy To Different Place

Once we filter the data we can copy that data in other cells as well in Excel sheet.

To copy to a different location: 

1) When we click on Filter and Advanced Filter option we get the below dialog box.

2) Here we have three options:
  • List range is the range of data that is to be filtered.
  • Criteria Range is the entire data from which data needs to be filtered.
  • Copy to pastes the filtered data to a different location.
We select the data and the cells and we will get the filtered data in the cell that is there in Copy to cell range.


Post a Comment

Search This Blog


Related Posts Plugin for WordPress, Blogger...
Twitter Delicious Facebook Digg Stumbleupon Favorites More