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.

How can we improve Excel for Mac?

(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54

    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.

    58 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    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 →
  3. 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
    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. Adding notes to formulas?

    Formulas can get extremely messy with messy data. This is especially true when a formula is 10+ lines long. Often, re-reading 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
    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 →
  5. 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
    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 →
  6. SUMPRODUCT should work with rows and columns

    SUMPRODUCT should calculate a value from the same dimension-size arrays regardless of their vertical or horizontal alignment like for example =SUMPRODUCT(A1:D1,F1:F4)

    1 vote
    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 →
  7. 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
    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. 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 →
  9. userforms pour MAC ET FAIRE DES VBA MERCI

    Merci de me dire quand user forms pour mac urgent
    cordialement

    1 vote
    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. 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.

    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 →
  11. 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
    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. Please inser function chek cella in Excel for Mac

    Please inser function chek cella in Excel for Mac

    1 vote
    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. ekzelde bazı rakamları göremiyorum mece nasıl uyarlarım

    dosyada fatura kımında ki rakamlar görüntülenemiyor

    1 vote
    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. 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.

    13 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 →
  15. 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

    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 →
  16. 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.

    7 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 →
  17. Return clickable icons for formula operators

    Previous editions of Excel had clickable icons for formula operators, very handy for inputting formulas using a mouse.

    PLEASE give them back

    1 vote
    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. Sort out the Symbol feature

    Inserting a symbol does not work correctly, with a single click on some symbols (e.g. heavy check mark) it appears in the spreadsheet as a check, followed by a square which cannot be removed without removing the checkmark. Inserting the Eight Pointed Black Star shows as aa.

    IN ADDITION, if I succeed in inserting a symbol, save the document and then close it - when I reopen the document it is no longer possible to insert any symbol as clicking 'symbol', on the 'insert' menu, does not bring up the required symbol window.

    I am so sad, I loved Office…

    1 vote
    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. Añadir Evaluar Formula para Mac en Excel

    Mismas funciones de programación en VBA y analisis de formulas tanto en Windows como en Mac

    1 vote
    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. Añadir Evaluar Formula para Mac en Excel

    Mismas funciones de programación en VBA y analisis de formulas tanto en Windows como en Mac

    1 vote
    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 →
← Previous 1 3 4 5 6
  • Don't see your idea?

Feedback and Knowledge Base