The ability to copy (or paste) 'visible cells only' when copying/pasting from a filtered range into a column of empty cells
This option did not seem to work at all, and would just paste a few headings ignoring the filtered data.
(2016-06-20 Dan [MS]: updated title to match Win32 title)
data ninjaa commented
This is a major need, it absolutely baffles me that the default behavior is to ignore the fact that a range in filtered and that i can't copy and paste a set of cells from a range into another column on that same range. Google sheets does this perfectly