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 -
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.
I'm trying to enter the text "HSA" into an Excel cell. No matter what I do or how many times I type it, Excel changes it to "HAS". What the **** is wrong with you people!?1 vote
We have good news to share. In the January 2019 release of Excel for both Mac and Windows, this issue has been resolved. Once you install the update, Excel will allow you to override any autocorrection simply by going back and typing over the correction. For example, if you type “HSA” into cell A1, Excel will autocorrect it to “HAS”. If you go back and type “HSA” again in the same place, Excel will not correct it again. It will still autocorrect “HSA” if you type it into a different location, or if another autocorrection happens before you change “HAS” back to “HSA”. To summarize, Excel will no longer make the same autocorrection 2 times consecutively.
This fix is included in Excel for Mac if you have version 16.20 or greater, and Excel for Windows if you have version 16.0.11126 or greater.
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]
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?