Hi Martin, are you talking about Windows or Mac Excel? The previous version of Excel for Mac was released in 2011, and we just released Excel for Mac 2016. Windows Excel had a 2010 version, a 2013, and now a 2016.
In both Excel for Mac 2011 and 2016, there is the option to Right Click > Paste Special... or the keyboard shortcut for Cmd + Option + V.
In Excel for Windows, there is the option to Right Click > Paste Special... or the keyboard shortcut is Ctrl + Alt + V. If you are only seeing two options under Paste Options, try copying your source cell again. Lastly, there are a few "shortcuts" for Paste Options in the Windows right click menu, but you can get to all of the options by clicking on Paste Special...
Hope this helps,
49 votes5 comments · Excel for Mobile Devices, Tablets, Phones (Android, iOS, Windows Mobile) » Graphics · Flag idea as inappropriate… · Admin →
Interesting idea. Thanks for the feedback. We’ll definitely consider this in our next round of planning. In the mean time, please continue to vote on this feature idea.
I believe the functionality you are asking for is available from the Insert tab, by clicking on the Camera button - this will open up the Camera app from within Excel and allow you to insert a picture directly. There's currently no way to link the image to a specific cell (in any version of Excel, desktop or mobile), but it will be inserted into the spreadsheet and viewable anywhere you open the file.
Hope this helps!
Interesting suggestion Nick - we do have some documentation about the keyboard shortcuts in Excel for Mac 2016 here - http://aka.ms/xlmacshortcuts.
Both of the specific examples you've mentioned are supported in Excel for Mac 2016, but switching the default behavior of the function keys on a Mac requires checking the box in Apple > System Preferences > Keyboard > Use all F1, F2, etc. as standard function keys.
If you're asking for Excel for Mac 2011, I wouldn't expect to see any new features added there. But if you'd like a one-click "use Windows keyboard shortcuts" setting in 2016, then that's something we would consider adding if it gained enough traction (votes) here and in other feedback channels.
Thanks for the feedback Anonymous, we have this fixed in the December update.
If the file does not contain any private information, could you upload it to an online host (e.g. OneDrive.com) and share the link so we can investigate it directly? If you'd rather not upload it somewhere publicly, I will try to find a way for you to send it to us privately.
228 votes73 comments · Excel for Mac » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
Thanks for all your comments and votes supporting this suggestion. Please keep adding votes. We are considering this for a future update.
Thanks – Steve K [MS Excel]
Thanks for the suggestion! If you'd like to see us add "Find All" to Excel 2016 for Mac, vote here. The more votes this post gets, the more likely we are to do it
In order to make sure your request gets seen by the right people, please post it in the Excel Online uservoice here - http://excel.uservoice.com/forums/274580-excel-online