Return features from Office 2010
When copy and pasting, in Office 2010 you get a veriety of options when you right click, but in Excel 2016, it does not, you have to click on Paste Special and then choose from only 2 options! - Thos feature in excel 2010 is brilliant and gives so many useful options for paste special.
In excel 2010, you can create your own personalised menu with shortcuts to the icons that you use most often... This I can not find how to do in 2016. It makes working in Excel so much easier and quicker.
Unfortunately, I can not see how to attach images on here otherwise I would have attached samples!
Hope this makes sense!
Also bring back the minimize / maximize and close buttons for each spreadsheet from 2010 into 365
Hi James Spotanski
Apologies for the vast delay in responding, but I am talking about Mac Book Pro.... Always only 2 options in Word and with excel it is the old fashioned way of opening an option window and choosing from there.
In Office 2010 you right click and you have a load of different options right there and is so much quicker...
Also In 2010 I can create my own personalised ribbon menu and options... in 2016 / Office 365 it will not allow me to...
I use this at work I do not understand why Office has gone backwards?
Unfortunately this site does not allow me to attach anything so can not attach samples!!
Andre Neves commented
It's ridiculous that I have to use a previous version of the program to insert pictures in a spreadsheet header, save it and work with the new version again.
James Spotanski (Microsoft Excel) commented
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,
What a waste of time this was