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 the month.…There is another formula right there that calculates the number of years a…