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.

Can the weight of the grid lines be change
Can the weight of the grid lines be chance? the weight of the grid lines make them lighter than the input in the cells
2 votes 
Static timestamps that has an option to be updated when a target cell is updated.
It would be great to have the ability to use a function that targets a cell and when the target cell receives a value gives a "static" Date and Time stamp. Also have a true/false option for updating timestamp when target cell value changes.
Currently the only options are VBA or circular reference. NOW just isn't any use for static timestamps?? Or have
7 votes 
Allow Trace Precedents/Dependents) to work on protected sheet
If you protect a sheet, Trace Precedents/Dependents no longer works, even if you can see the formulas. This can be annoying if someone wants to see the calculation flow, but the author doesn't want anything changed.
Either completely disable formula tracing only if the formulas are also set to hidden or add another option to the Protect Sheet dialog to toggle this on or off.
4 votes 
"Manual" calculation setting should not affect other spreadsheets
If a user has a spreadsheet that has calculations set to "Manual" (for what reason, I can't fathom), if they open that spreadsheet first, then all subsequent spreadsheets open in that session will do manual calculation.
Calculation settings should not be global like that. If you have to have a Manual calculation spreadsheet, that should only affect that single spreadsheet  not any others that may be concurrently opened.
This is a terrible design choice.
24 votes 
clicking on cell while using formula adds it to formula
In older versions, (2011) when you entered "=" and clicked on a particular cell, it added that cell's value to the formula. You could then click on another cell and it would use addition to add the second selection. Example: When entering = and clicking A1 then clicking B1, then clicking C1, formula would calculate "=A1+B1+C1". Now we have to manually enter "+", or the cell first clicked is replaced with the most recently selected cell.
8 votes 
Hello I've been using Excel on Mac for over 20 years, I've always liked to be able to Sommer discontinuous cells, simply by selecting them
Hello
I've been using Excel on Mac for over 20 years, I've always liked to be able to Sommer discontinuous cells, simply by selecting them one after the other after putting the = sign in the cell to receive the sum... it never worked On Windows versions and if I was not careful I found myself with the value of the last cell clicked instead of the sum of the Series.
Here I've just acquired and installed Office 365, instead of my "old" office Mac 2011 and this automation of the sign + no longer functions...
Do you have any…2 votes 
Timecode Calculator
I'm a video archivist frequently working in excel with footage logs. I'm always looking for tools & formulas for calculating various durations of footage down to the frame. [ HH:MM:SS:FF] I'm looking for a cell formatting and a formula that would allow me to calculate (add & subtract) Timecodes. Another trick to this problem is that footage can have a few different frame rates (frames per second). I know several networks of fellow archivists who would appreciate this kind of functionality. I'd be glad to discuss this further if you're interested in developing.
4 votes 
Make the one version identical to the other
How can a pc version of Excel be different to a mac version? If we are being forced to upgrade office to benefit from all the new features in excel, then no matter what our platform we should have all the benefits.
I upgraded specifically to get the IFS function, which I now have found out is not available in MAC.... why not?
Make the two versions offer the same capability as soon as possible!
14 votes 
conditional cell formatting
Like in google sheets, provided conditional cell formatting. For example, in cell C1, if the value is above zero, the cell's text will turn green. If below zero, the cell's text will turn red.
3 votes 
"Find All" feature not available in Excel for Mac?? There are workarounds, but take longer to find all results of a search. PLEASE fix!!!!
"Find All" feature not available in Excel for Mac?? There are workarounds, but take longer to find all results of a search. PLEASE release a download so that I can use it, or at the very least, implement for future releases/verisons.
6 votes 
Support for regular expression functions REGEXEXTRACT, REGEXMATCH, REGEXREPLACE
I would like to see support for regular expressions in Excel for Mac functions. Desired functions:
REGEXEXTRACT
REGEXMATCH
REGEXREPLACE
How they would work is explained on https://support.google.com/docs/answer/3098244?hl=en12 votes 
Interpolation function for Excel
When you have a number in cell A1, say it is "10" and then another number in cell J1 and it is "100" it would be great to have a function to do linear interpolation (lerp) between the two numbers without having to resort to long and complicated formula that is easy to get wrong.
Function LERP:
=LERP(startvaluecell, endvaluecell) for a simple useage
or
=LERP2(startvalue, rangefirstcell, endvalue, rangeendcell)So using LERP and my example:
A1= "10" , B1=LERP(A1, J1), C1=LERP(A1,J1), D1=LERP(A1,J1),…I1=LEPR(A1, J1), J1="100"SO USING LERP2 and my example
A1="10",…2 votes 
We need a "SORT" function to automatically sort rows or columns.
The syntax would be simple: =rowsort (array,column to be sorted,0 or 1).
Array: select the array of the desired sort
Column: the column number to be sorted
0 or 1: ascending or descending.The "column" syntax entry could be further expanded to include the order of the columns to be sorted by; ie rowsort(A1:D19,{1,2,4},0) would indicate the array A1:D19 would be sorted ascending in the order of column 1, then 2, then 4.
issues: 1. if the first sorted column is entered first (for data entry) the whole row would instantly sort when "Enter" is selected unless one has set…2 votes 
Touchbar absolute/relative formula shortcut (F4)
When entering a formula, please add a touchbar button (ideally around where F4 used to be) to toggle relative/absolute cell reference. Again, would be much simpler than pressing Fn + F4, which often doesn't work at the moment either.
9 votes 
watch window  to watch the value of cell in excel
Can we please have a Watch Window where we can see / monitor when the value in the cell which is being watched is changed. This functionality is available in Excel for windows under Formula's Ribbon under Audit formula section
21 votes 
Add Evaluate Formula to Mac app
Please add the evaluate formula dialogue box to the mac app. With it you can evaluate a formula step by step and see which part of the formula works and where the problem is.
733 votesThanks for all your comments and votes supporting this suggestion. We are in the planning stages for this feature to be added to Excel for Mac.
Thanks – Steve K [MS Excel]

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…
12 votes 
Fix concatenate function in formula builder so it doesn't crash Excels and force a shut down.
Using concatenate function in formula builder causes Excel to shut down. Repeatedly.
3 votes 
Autodetect functions used in Excel and link me to a short video explaining how to use them
I should be able to click on ANY cell with a formula, and then a Video button lights up to the right of formula bar, which takes me to an excel website with embedded 2 min videos describing the use and construction of the specific function in the formula bar!
For example: Imagine I have something like "=If(And(Or(xyz)))" typed into a cell, and I can't figure out how to make it work.
If i click the cell > then click the video button that is now lit up, I should be taken to a webpage where the construction of IF…
13 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
 Don't see your idea?