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. Temporary variables in formulas

    It would be amazing if you could implement a function that allows you to set a temporary variable to use within a formula! Something like the syntax used in OpenRefine's "with()" control (borrowing their syntax for my example - link to their wiki below).

    Syntax:
    WITH( [Function A], [Variable Name: string], [Function B] )

    [Function A] would get evaluated first, and then the result could be referenced within [Function B] using the [Variable Name] string (essentially as if it was a named range). With this you can reuse a value in a formula multiple times without needing to repeat the…

    3 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 →
  2. Find

    Why after so many years of people requesting that Find All button be added to the Find dialog box in Mac Excel version it's still not there? How difficult is it just to add a button?

    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 →
  3. In Office 2011 for Mac in the pulldown File menu under Recent the user has the option to Clear Recent. This option does not exist in Office

    In Office 2011 for Mac in the pulldown File menu the user had the option to Clear Recent. This option is missing in Office 2016. It was a useful feature. You should put it back.

    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 →
  4. 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”

    3 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 →
  5. 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
    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 →
  6. 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 →
  7. 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 →
  8. You have to bring back Clipboard in Excel 2016

    Sorry, I have commented before on this topic but I have to comment again. This is crazy and incredibly frustrating. The Clipboard is so essential. Right now I am trying to copy about 22 individual rows of data (each about 32 columns wide) but spaced about 50 rows apart, so they have to be done individually, to another part of the sheet quite some distance away. Without clipboard it is so frustrating. Once the row is copied,iIf I make one little error, like selecting the wrong staring cell to paste or pressing some other key, the copy is lost and…

    3 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 →
  9. 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
    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 →
  10. 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
    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 →
  11. Add Contextual Menu to insert Function

    When right clicking on a cell provide a contextual menu option to insert a function.

    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 →
  12. Non-parametric statistical tests

    Excel only offers parametric tests like the t-test and the ANOVA. It should also offer non-parametric tests that are not based on binomial distributions like the Mann Whitney (u test) for instance.

    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 →
  13. View (All) option (like Word) to see all white-space characters, training spaces, new-lines, 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, new-lines (and indeed anything else that can contribute to "hidden" white-space) 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 numbers-stored-as-text — another huge time waster and caltrop for the novice, and even not-so-novice users.

    3 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 →
  14. 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. Sheet numbers change as you drag the formulae down

    Can there please be the ability to drag the below function down the column and the sheet number changes automatically only. The '$' sign fixes the cell but I need the ability for the sheet number to change automatically in numerical order as I have over 200 rows and 25 columns to change manually!!

    ='18'!$B$3

    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. phonetic関数が途中までしか反映されず、後半が化けてしまう。改善してほしい。

    windowsでは正しく反映されるが、マックでは反映されずストレスを感じる。

    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 →
  17. 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/en-us/article/Keyboard-shortcuts-in-Excel-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd), 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…

    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. 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
    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 →
  19. 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 →
  20. 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
    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