I have this datasheet. There filters (auto filters) on some columns.
I select any value from the list of values (it doesn't matter e.g. :6.5 from my
datasheet). The datasheet is filtered as it supposed to be. Now here's the buggy
part:
I select all columns (that's why i filter them for) and try to paste some data
into  them. It works. But it pastes the data to ALL cells (from top cell till
last cell I've selected). It's suppose to paste only into cells I've selected,
but it pastes to the cells to the whole range, pastes to the hiddens cells to,
instead of filtered cells.

Maybe the if I enter the value while having some cells selected, all cells could
be filled with value I enter - would make some sense too.

If I didn't exactly explained the problems, give me a shout, I'll give more
specific steps