Excel for Mac
Welcome to the Excel for Mac forum! This is the place for users to send us suggestions and ideas on how to improve. To help us build the best version of Excel ever, we have partnered with UserVoice, a third-party service, to create this site to hear your suggestions and ideas for the next version of Excel. Your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.
-
Direct Paste Value (Text)
with Excel for Windows there is a Right click past as 'text' option which was super helpful when when building price lists for example where you grabbing data from various sources and wanting to pate unformatted text or pase while not messing with the existing cell formatting. Need a paste as text shortcut or Right click pate text option. Mac does have a default Paste as text shortcut (Shift ALT Apple Key V) but the combo is not friendly,
Right now you have to choose Paste Special, Value which is time consuming if you doing it allot.
29 votesWith the next update to Excel for Mac (version 16.33 or higher), you will be able to assign a shortcut key and/or add the “paste formatting”, “paste formulas”, and “paste values” actions to your quick-access toolbar (QAT).
For the QAT (under Commands not in the ribbon), the commands are called:
Paste Formatting
Paste Formulas
Paste ValuesKeyboard Customization (under Commands not in the ribbon), the commands are called:
Formatting
Formulas
Paste ValuesFor the keyboard shortcuts, you’ll need to assign a key combination that isn’t already being used to open the Paste Special dialog.
-
Bring back REAL keyboard customization!
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 votesGreat news. This feature is now available in Excel for Mac (O365 and Office 2019. Read more about it here -
-
Make the solver work! (Input boxes should use the reference/range picker)
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!122 votesGreat news – as of Mac Excel 15.19.1 this should be fixed – the reference picker in Solver is back!
Thanks,
Dan [XL] -
Add the Find and Select button onto the Ribbon
The Find and Select option is not available on the Ribbon make options like Replace difficult to find.
6 votesThis is now available in the 16.24 update, which you can get if you opt into the Insiders Program, by going to Help > Check for Updates (not available if you installed from the Mac App Store). If you don’t want to opt into the Insiders program, this will be released in mid-April 2019.
-
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 votesThe 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.
-
'Select all' in the address bar
Command+A in the address bar or triple clicking on a cell doesn't select all the text in a cell any more! Can you please put that back? I have a lot of semi-repetitive labels that each need slight editing and the new update has made it hard! Thanks!
2 votes -
'Select Objects'
How about giving the option 'select objects' for users to highlight which objects they want to delete? My only option on iMac is to press F5, special, then select objects which deletes all objects. Please address this issue as quickly as possible.
2 votesThis is now available in the 16.24 update, which you can get if you opt into the Insiders Program, by going to Help > Check for Updates (not available if you installed from the Mac App Store). If you don’t want to opt into the Insiders program, this will be released in mid-April 2019.
To select objects, you can click the Find & Select button on the Home tab of the ribbon, and choose the Selection Pane… or Select Objects.
-
Pls add draw or ink option on Excel for Mac
I would like to use the draw or ink tool on Excel for Mac.
1 voteThe Excel team is happy to announce support for ink in Excel for Mac.
-
Fix data entry
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 voteWe 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.
-
Bring back CMD-F shortcut for find/replace
Please . . . bring back this shortcut! I use this frequently. It takes up valuable time to go about it the long way.
19 votesTo 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 Mac
Flash Fill For Mac
304 votesGood 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]
-
Introduce an equivalent to F2 on PC to edit and F4 to make cell references absolute
Introduce a shortcut to make cell references absolute like F4 on PC version (F2 edit equivalent would be helpful too)
1 voteIf 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.
Cheers,
Dan [MS]
- Don't see your idea?