I would like to use the draw or ink tool on Excel for Mac.1 vote
The Excel team is happy to announce support for ink in Excel for Mac.
Please . . . bring back this shortcut! I use this frequently. It takes up valuable time to go about it the long way.19 votes
To use Find and Replace, you can press CTRL+F or CTRL+H. These shortcuts bring up the find and replace dialog.
Press CMD+F to go to the search field above the ribbon.
Flash Fill For Mac304 votes
Good news! Flash Fill is now available in Excel for Mac if you upgrade to version 16.13 or greater. To use it, you need to click the Flash Fill button or press CTRL+E, since it won’t happen automatically as it does in Excel for Windows.
Thanks – Steve K [MS Excel]
It is completely not true, that keyboard customization through OS X keyboard preferences really works. Tell me how to make a shortcut to fill cell with color: for instance CTRL+2? Or how to paste values (without any mid-steps)? Or even do something more advanced than copy/paste with my own combination of inputs.
The fact is that office 2016 for mac lacks this feature and this "workaround" is NOT a replacement. Please bring back the option that was SO USEFUL!287 votes
Great news. This feature is now available in Excel for Mac (O365 and Office 2019. Read more about it here -
Maintain copied data on the clipboard even if the "dancing ants" aren't shown around the copied range
I understand that the clipboard can use A lot of memory, but It is sooo frustrating having to re copy everything because I accidently clicked in the wrong cell before pasting.22 votes
The clipboard is now persistent in some cases where it would have been cleared in the past. For example, if you copy some cells, and then insert a new sheet, you can paste the copied cells. In the past, the clipboard would have been cleared when you inserted the new sheet.
Introduce a shortcut to make cell references absolute like F4 on PC version (F2 edit equivalent would be helpful too)1 vote
If a function key doesn’t work as you expect it to, press the FN key in addition to the function key. If you don’t want to press the FN key each time, you can change your Apple system preferences:
Go to Apple > System Preferences > Keyboard.
On the Keyboard tab, select the check box for Use all F1, F2, etc. as standard function keys.
Fix the solver so that fields that take range references as inputs have the reference picker control (RefEdit), which you can click on and then select the range to use. Today, you have to manually type in the range, and it's super frustrating.
[Note: Title and Description updated on 10/19/2015 by Dan [MS]. Original description follows:)
just make it work!123 votes
Great news – as of Mac Excel 15.19.1 this should be fixed – the reference picker in Solver is back!
- Don't see your idea?