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.

Formula Evaluation (Auditing) doesn't exist for Mac?
I know, I know...Mac Users are different, but it doesn't mean they can't benefit from clear insights to their Formulas.
Alt+T, U, F in Excel for Windows gives a stepthrough window for evaluating a given formula. This isn't an option on Excel for Mac. Is there any work being done to enable it? Just wondering also why such basic functions for maintaining workbooks wouldn't be available across platforms.
Looking forward to hearing back.
Thanks.
BPC.
7 votes 
Including a timeor datestamp on templates for reports
To insert a time or a date, we can either use the stamp function (e.g. ctrl+;) or use the formula (=TODAY). I would like to have the use of a timestamp inside a template, so that when we create a new sheet from that template, the fixed date appears, i.e. as a datestamp. I haven't found how to do this using help.
1 vote 
WeekNum  let it work with a Array like Month() does
We can use '=SUMPRODUCT( (MONTH(A1:A10)=MONTH(TODAY()) )* (B1:B10) )' to get a result from dates.
However
'=SUMPRODUCT( (WEEKNUM(A1:A10)=WEEKNUM(TODAY()) )* (B1:B10) )
does not, because WEEKNUM can't handle an array or range.Please give us a WEEKNUM that handles Array and ranges
Thank you.
10 votes 
Excel for Mac should have the new Stocks functionalty
It would be great if Excel for Mac (Insiders) is able to have the new Stocks functionality currently used by Excel for PC (Insiders)
This functonality is described in https://support.office.com/enus/article/getastockquotee5af3212e0244d4cbea0623cf07fbc54
In respect of this particular capability, it would bring Excel for Mac more in line with Apple Numbers which currently offers something similar.
Thank you for considering this addition.
61 votesHi Jonathan – thanks for asking! We’re working on this and will update the status here once it’s closer to being ready.
James Spotanski,
Program Manger, Excel 
improve the filter function in excel for Mac  make it work the same as with excel for PC
improve the filter function in excel for Mac  make it work the same as with excel for PC
2 votes 
phonetic関数が途中までしか反映されず、後半が化けてしまう。改善してほしい。
windowsでは正しく反映されるが、マックでは反映されずストレスを感じる。
1 vote 
Rounding issue with Excel and dollar values
Current Issue just discovered talking to MS Excel Support to see if there is a work around or if someone is solving this error.
Issue is that when you place values in a cell and do a =ROUND function to format a currency value it rounds down not up. i.e. Summing to Cells and trying to find tax for the two values return in correct value.
=ROUND ($33.165, 2), returns 33.16 and not 33.17. This is a major show stopper for financial calculations and worksheets.1 vote 
Why is there no Menu item or Ribbon button for toggling between relative and absolute?
Yesterday, I spent a good 2 hours trying to change a table's references from relative to absolute. I couldn't find any Menu item or Ribbon button to perform this action, so had to resort to Google.
That lead me to the support.office.com page for Mac keyboard shortcuts (https://support.office.com/enus/article/KeyboardshortcutsinExcelforMacacf5419e1f87444d962f4e951a658ccd), which told me that I could use CMD+T (which creates a table) or F4 (which is a Redo shortcut).
So I called 365 support, where I hand to help the agent understand how to use several aspects of Excel (nothing is more frustrating than talking to an "expert" who knows…
1 vote 
Parse
I’d like to see a “parse” function that can easily separate out strings in cells and pull just one element instead of doing multiple mid() and find() functions. e.g. =PARSE(“Gift card from Company for $200”,4) would return “Company” or ,6 would return $200 etc. Maybe an optional parameter to specify the separators (sometimes it’s hyphens, sometimes spaces, sometimes bars etc). Another optional would be how many words to pull starting at word x, e.g. =PARSE(“This has useful data about product”,3,2) would return “useful data”
2 votes 
Adding notes to formulas?
Formulas can get extremely messy with messy data. This is especially true when a formula is 10+ lines long. Often, rereading a formula a few weeks later is absolutely indecipherable. Can we somehow be able to add notes to a formula, similiar to the ' in VBA?
3 votes 
Blinking briefly or highlighting matching/ pared parentheses when checking through or writing a formula in the formula bar for Mac
Blinking briefly or highlighting matching/ pared parentheses when checking through or writing a formula in the formula bar for Mac. Like it does on windows.
1 vote 
SUMPRODUCT should work with rows and columns
SUMPRODUCT should calculate a value from the same dimensionsize arrays regardless of their vertical or horizontal alignment like for example =SUMPRODUCT(A1:D1,F1:F4)
1 vote 
make same function excel for mac and window users
Please make same function excel for mac and window users so that we could be easy to use and command or shortcut key also be same.
6 votes 
Create a new "swapping" function
We have the transpose function that allows us to swap data from rows to columns, or vice versa … how about a function that allows us to swap data between two different rows, or two different columns. For example, if I have data in A1:A10 and I have data in B1:B10, I could highlight both sets of data, and by choosing this new function, I could swap the data, whereas A becomes B and B becomes A.
1 vote 
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 
userforms pour MAC ET FAIRE DES VBA MERCI
Merci de me dire quand user forms pour mac urgent
cordialement1 vote 
Put back the function
Please put the function for addition back on Excel  the one where you hit "=", then highlight the column of numbers, then hit "=" again and it adds up for you. It is way more efficient than what you have now.
1 vote 
Please inser function chek cella in Excel for Mac
Please inser function chek cella in Excel for Mac
1 vote 
Make Name Manager Mac = Name Manager Windows
Where has the Name Manager for Mac (Excel 2016) gone? I have imported work done earlier on a Windows platform and now need to work with the named ranges...but cannot find a way to access the Name Manager. The suggestion I find on the web to push command +fn + F3 does not work.
15 votes 
ekzelde bazı rakamları göremiyorum mece nasıl uyarlarım
dosyada fatura kımında ki rakamlar görüntülenemiyor
1 vote
 Don't see your idea?