Discussion on:

Message 29 of 34
1 Vote
+ -
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.
Posted by Hogie51
3rd May 2011