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 thirdparty 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.

Autosum Keyboard Shortcut Bug
Can you please fix the autosum keyboard shortcut to behave like that of Excel 2011. It seems like the behavior is broken in Excel 2016. it sum a row at the bottom of a column way to fast and doesn't let you see the selection and press enter to except it. Also, when summing from the side it does a fast 1 cell sum but you need to hold down the key combination to get the selection cursor in order to make a larger column selection. Please fix. Thank you.
2 votes 
Excel for Mac won'ty shoe the sum, average, count, etc all at the same time, SO SAD AND UNHELPFUL!!!
Fix this, if Windows can do something so simple why can't Mac?!?
2 votes 
Excel 2016 for Mac  external links do not hold the current values, but put 0
The issues are confirmed for versions 15.26 and 15.27, and did not happen for version 15.24; there is an Excel file which has an external link to another Excel file which is on a computer which is on the network but not be shared; when we open the file in Windows Excel 2013, the values associated with the link are held in the cells; however, opening the file in Mac Excel 2016, those cells get zero (0) and another cells which are calculated based on the linked values go to wrong values. This is very critical as the file is…
11 votes 
Save function/formula string used regularly to recall easily
I think it would be very useful to be able to save a formula that you use regularly to recall. For instance, I have a formula I use to change the last character instance in a cell and it would be nice to be able to recall it by typing something like "=changelastcharacterinstance"
=SUBSTITUTE(A1,”find”,”replace”,LEN(A1)LEN(SUBSTITUTE(A1,”find”,””)))
3 votes 
Add Contextual Menu to insert Function
When right clicking on a cell provide a contextual menu option to insert a function.
3 votes 
Use return key to change cells and retain copied information
Why doesn't using the return key in 2016 Mac to change cells retain a copied formula to paste? Now we are forced to use navigation arrows (or clicking  both much slower) as the only way to navigate to paste. I miss this function from earlier versions
2 votes 
Simplify formula entry / autocomplete
If you enter a formular in a cell (e.g., "=Sum...") the autocomplete function pops up and presents you possible functions. You can select one of the functions by pressing the up and downkeys. However, the most intuitive and consistent way to choose the highlighted function by pressing the enter key does not work as expected. If you press the Enter key, Excel stores what you have typed so far in that cell instead of selecting the function and move on to filling out the arguments.
3 votes 
View (All) option (like Word) to see all whitespace characters, training spaces, newlines, etc.
Given how single trailing spaces can disrupt smooth functioning of functions, especially like VLOOKUP, it would be wonderful to have an option to display spaces, newlines (and indeed anything else that can contribute to "hidden" whitespace) just like we have been able to see in Word as an option for, ooh, about a century (or at least since the beginning of time).
At the same time, and in the same mode, a distinctive background shading or similar of numbersstoredastext — another huge time waster and caltrop for the novice, and even notsonovice users.2 votes 
Automatic detection of matrix formula results
Add automatic range selection for matrix formula results, as works in Open/LibreOffice and Google Apps for many years  no more F2,CTRLShiftEnter...
1 vote 
VLOOKUP and 256 characters limit
Many functions in EXCEL for MAC 2011 don't work at all (they return the dreaded #VALUE field) if the one of the reference cells has more than 256 characters. This is the case already for VLOOKUP, and for TEXT. Possibly for others as well?
Users shall have a list of these, to avoid disappointment. Of course if it could be corrected it would be better.6 votes 
Enable batch convert cell refs in formulas from relative to absolute in one go.
Sometimes we need to convert a relative reference in a cell (e.g. A1) to absolute values (e.g. $A$1) or the contrary. This is a painstaking process, requiring to click in the cell, locate the references, and adding/removing the $ as required. It is tedious and has to be done cell by cell, and within a cell ref by ref. Like the middle ages! It would be useful and great to enable to select the cell (and even a group of cells) and toggle ALL REFS at once to absolute and relative.
3 votes 
Add feature to list all functions and include all functions offered on PCs
Add feature to list all functions and include all functions offered on PCs
5 votes
 Don't see your idea?