Work gripe
There are days where I think Excel is a class on how not to UX.
Like today, when I forgot that *copy and cut do different things if the selection is filtered*
A range of 5 items filtered to two, if copied, will copy only those two. If cut, it takes those two and every item between. If you want to cut, you must copy then manually delete the filtered item.
Hence why half my data is now on the wrong sheet >.<
Work gripe
Bonus: That other sheet you cut data to? Doesn't show anything has been filtered. Clicking clear filter does nothing unless you select the whole sheet first which you don't normally need to do.
The only clue is the line numbers.