MAC - Paste only to visible cells not working

hey guys, I've spent last two hours trying to figure out how to paste a selection into visible cells only (some rows are hidden) but no luck. Before I decide to trow my computer out of the window, I want to see if you maybe someone knows what the problem is. Searching the internet did not give any answers.

I want to copy a whole column from one sheet, to another with hidden cells. So what I did is copy as normal, than select where I want to paste, click the visible cells only and then CTRL+V. This does nothing, and I mean nothing. Its like it gets locked when I click the visible cells only option. It doesn't even respond to the paste command. So I don't know what to do. The same happens when I do the right click on the selected cells and then paste.

Quick note - I use excel 2011 on a mac, so no macros posible

I added the worksheet as well so you can take a look. I want the paste the values for "average #" from sheet2 to the sheet1 with hidden rows.

Thank you in advance.