Excel - Paste Special

[Ron Matthews]

With Excel 2011 for Mac, the Paste Special function allowed you to pick different formats to Paste data that had been copied from say another Excel spreadsheet.
Such formats are placed formatting, paste values, et cetera.
There was even a button supplied for this task which could be included into the taskbars and ribbons.

However, with Excel 2016 for Mac, I can find no such function, simply paste special as Unicode text or text, neither of which appear to me that fit the bill as to what I'm looking for.

Has anyone had a similar problem and if so, can you please help me with the solution to this probably very simple, problem for Excel 2016

with thanks
Ron

 

[Kamolga]

It normally has nothing to do with your version, Unicode-text only option normally comes from the copied source: I think I have it when I copy-paste from Microsoft Project or a pivot table for example (Windows machine).

If you type anything in a cell on a new file where you have all rights and copy it, you should have all options in

paste special ​

​