Copying and sorting filtered lists


show more Copying and sorting filtered lists provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010 show less
please wait ...

Copying and sorting filtered lists

It's not uncommon when viewing a filtered list to want to copy the data elsewhere. There are special rules that allow us this to proceed pretty quickly. You don't have to worry about the hidden data. You also have the option of pasting the data as values or actually pasting it to include formulas where present. Let's imagine in this particular list here, we want to apply a filter and maybe we just wanted to see people from certain departments. So clicking the arrow for Department will unselect all of these and choose just the people in the ADC group and in the Audit Services group. Click OK.

And we may or may not want to sort these, but if we do, we could do that pretty quickly here, sort A to Z. We've isolated the two. Let's simply highlight the data. We might want to include the titles as well. There is a concern though as we consider highlighting the data. What about formulas that might be in here? Here is a formula here, rather long, that easy formula that extracts...

Copying and sorting filtered lists
Video duration: 3m 7s 1h 32m Appropriate for all

Viewers:

Copying and sorting filtered lists provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Managing and Analyzing Data in Excel 2010

Subjects:
Business IT
Software:
Excel
Author:
please wait ...