Be Careful with FILTERED Data
This is a great tip, and I use it all the time, but it will ignore any filters. So if you filter a subset and want to copy a cell or series to those filtered values only, you must use copy/paste. Double clicking the handle will copy into ALL cells in the column - even the unfiltered ones.
Keep Up with TechRepublic