Feedback by UserVoice

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.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Allow the NULL() result in a formula to create an effectively empty cell. This posted in the Windows side but not on Mac

    There is not way to get a formula result to be the same as an ampty cell.
    This explored in much more detail on the Windows Excel side by Jon Peltier.
    It would be extremely useful as a statistical 'Missing Value' flag that should propagate through formula as though the cell were empty.
    Bob Jodan

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. 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.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Include IFS function in Office 2016 Excel

    Why isn’t the IFS function in Office for Mac 2016 Excel? I can’t imagine it’s a technical problem. An explanation would be interesting.

    4 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add more basic Quick Access Commands on Office 2016 for Mac: * , / , + , - , = thank you

    Need Quick Access Commands for basic math:
    Multiply: *
    Divide: /
    Add: +
    Subtract: -
    Equal Sign: =

    Your help to add these icon commands will be greatly appreciated. It will simplify my operations.

    Thank You
    Pino

    Thank You

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. FIX CONDITIONAL FORMATTING

    You have taken something simply and made it incredibly difficult to do. Typical Microsoft. Just copt a rule from one cell to another. Simple stuff, impossible to do in your product

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Update tooltips and autocomplete/auto suggest to match Windows version functionality

    I've encountered two major differences between the Mac and Windows version that have to do with the auto-suggestion of 1) arguments for functions that require specific inputs, and 2) structured references. (Screenshots attached)

    1) Take SUBTOTAL() for example, whose first argument is a function_num which must be a number 1 through 11 which correspond to other functions like SUM, AVERAGE, etc. In the Windows version, these are presented to you as soon as you type the function, but in the Mac version you either need to have the numbers memorized, or look it up in the help.

    2) Excel for…

    5 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. AutoSum Shft+Alt+T Bug

    Can you please fix the auto sum keyboard shortcut Alt+T to behave like that of Excel 2011 and the Windows Version? It seems like the behavior is broken in Excel 2016. It sums a column of numbers way to fast and doesn't let you see the selection and then press enter to except it. Also, when summing from the side of a column, it does a fast 1 cell sum. In order to make this keyboard shortcut behave correctly you need to hold down Shift+Alt+T until the selection is paused so you can then hit enter or make an expanded…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. 2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Bug associated with how ISNUMBER handles blank cells when used in SUMPRODUCT

    With the help of a user who is using Excel 15.25 on a Mac, we discovered a difference between how ISNUMBER handles blank cells when used within the SUMPRODUCT formula. Or at least that is what we think is going on. I am using Excel 2016 on a PC. I have attached a test workbook, a screenshot of what I see when I open the workbook in Excel 2016 on a PC, and what the user see when he opens the same workbook in Excel 2016 on a Mac.

    If A1 is a blank cell, then ISNUMBER(A1) returns FALSE.

    So,…

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Provide tools for working with names. Insert->Paste doesn't work. Define has no edit. What are we supposed to do - delete and redefine th

    Provide tools for working with names. Insert->Paste doesn't work. Define has no edit. What are we supposed to do - delete and redefine the table or name? That's pretty lame. Define shows the range and has a definition box, but I can't do anything with it.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Please create a function that will give you the Range (largest-smallest value)of a data set. ex.=range(a1:a13)

    Please create a function that will give you the Range (largest-smallest value)of a data set. ex.=range(b1:b13).

    More detail:
    Sales person: (a1) a b c d e f g h i (j1)j

                      (b2) 11 12 9  13 12  13  3  2   14  (j2)1  
    

    =range(b2:j2) math: 13-1 answer: 12

    Excel should look at only the highest and lowest digits within a given range and subtract the higher value from the lower.

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Argument tooltips in Russian localization

    No argument tooltips in Russian (and, maybe, another languages, I didn't check that) localization in Excel for Mac in versions above 15.29. Looks like temporary disabled and then forgotten feature.
    I have to stay on 15.29 and ignore updates.
    I appeciate if you pay attention for correction and respond here (it is awkward to check each release by installing->noresult->uninstallwholeoffice->returnbackto15.29).

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. "Break link" command causes Excel 2016 to crash

    Serious Issue in Excel 2016
    Copying a table of data or a figure from Excel 2016 to another work book retains the links to the source workbook as it should. However, there"Break Link" command causes Excel to crash. Please fix.

    2 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. 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.

    7 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Allow spreadsheets with links to other spreadsheets on network drives to work between Mac and Windows

    (we have a case open with Microsoft of this: 117010515137743 )

    We have two spreadsheets on a shared network drive, spreadsheet 1 has links to cells in spreadsheet 2. If we create the links on a Windows machine running Office 2016 (link looks like this: ='\staff01\staffshare\CentralDepts\Technology\NetworkServices\MSTest\Folder2[Main.xlsx]Sheet1'!$B$5), when we open the spreadsheet on a Mac running Office 2016, the link is broken! (on the Mac, the link is: ='\staff01\staffshare\CentralDepts\Technology\NetworkServices\MSTest\Folder2[Main.xlsx]Sheet1'!$B$5, which is not a valid path on the Mac).

    If we fix it on the Mac, so now the path looks like this: ='\staff01\staffshare\CentralDepts\Technology\NetworkServices\MSTest\Folder2[Main.xlsx]Sheet1'!$B$5

    When we open it on Windows, Excel tries…

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base