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. Changes to VLOOKUP/HLOOKUP

    I suggest 2 changes in Vlookup/Hlookup:

    A. VLOOKUP/HLOOKUP functions user can only search for the lookup value in the first column/row, and the result column/row is always after (right/bleow) the lookup column/row.
    I suggest to make it more flexible by letting the user decide which column to search in and which columns to retrieve the value from.

    B. Sometimes user need to drag lookup function to several columns and needs the column index to be incremented, for example to be 3 in the first column, the second column to be 4 and so on, I suggest to add new parameter…

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

    We’ll send you updates on this idea

    8 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. In Excel for Mac, fix the issue that the characters on the formula bar get corrupted when pasting a folder name in a cell

    Copying a folder name and pasting it in a cell may not be a common operation, but sometimes we do so.
    Therefore, it would be great if you could fix the issue that the characters on the formula bar get corrupted in the operation above.
    This issue has not been fixed for a long time and is always reproducible.

    8 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. Data Validation to hold New dynamic Arrays function in Validation list

    Current Scenario
    While using the dynamic arrays formula in data validation list is not returning the arrays values, we need when enter the dynamic arrays formula in a column then call the arrays using # in data validation

    Requested Solution
    Allowing user to use the dynamic arrays formula in the data validation directly instead of using the helper column.

    15 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 →
  4. Alt shortcuts for the Mac pls

    Please provide Alt key equivalent shortcuts for the Mac

    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. Make Microsoft Excel for Mac EXACTLY THE SAME as Microsoft Excel for PC.

    If Mac subscribers of Office 365 are getting less features and PC subscribers, prorate the Mac annual subscription accordingly. If not, MAKE BOTH VERSIONS OF EXCEL HAVE THE SAME MENU FEATURES!

    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 →
  6. Need a way to turn off a recurring disclaimer after it presents itself a few times

    I've started using the Stocks data types and now all workbooks that have them get the disclaimer banner on each sheet every time I open it up. After seeing it a few times, the user needs to have a way to turn it off. Otherwise , it just an annoyance. 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

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. Money for Excel-Allow the same transaction to be split into various catgeories.

    Certain items, especially income, need splitting; in order to accurately separate expenses like withholding for taxes or healthcare premiums.

    4 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 →
  8. Name Manager

    Include it please ini 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 →
  9. add Let function to Excel for macOS

    Please add the Let function to macos excel. Some people/colleagues are already using the Let function in the Excel Windows version documents and the file doesn't work on the Mac.

    5 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 →
  10. Problème de syntaxe "DATEDIF"

    Bonjour, j'utilise Excel sur PC iMac.
    J'ai un problème, je souhaite utiliser la syntaxe DATEDIF, mais cette dernière n'apparait pas dans la bibliothèque des formules et lorsque je la rédige elle ne fonctionne pas.
    J'ai été en relation avec un conseiller via LogMeRescue, qui n'est pas parvenu à résoudre mon problème.
    Merci de bien vouloir m'apporter une solution.

    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 →
  11. 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. A option to select in what language the user inputs formulas.

    Example: for an PT-BR version of Excel, I want to input EN-US formulas.

    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. Have UNIQUE() optionally ignore blanks

    The new UNIQUE(), SORT() and SORTBY() functions are incredibly useful and they save a lot of time. It would be helpful though to allow UNIQUE() to optionally ignore blanks. I use UNIQUE() to build named arrays dynamically which I can use as a validation list for data validation. At the moment I have to create the list (e.g. SORT(UNIQUE(<some column in a table>)) and then created a Name using OFFSET() to ignore the blank at the start of the sorted list.

    9 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 →
  14. Put back subtext when building formulas

    Put back subtext when building formulas. The text that lets you know where you are in the formula.
    Examples from previous editions: "argument", "value if true", "value if false"...

    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 →
  15. Function for Classifying data as ABC instead of a series of "if cell in range A; classA; if cell in range B; classB...."

    Using Frequency function, you can input a list of classes then compute the occurrencies of data selected as a matrix formula. What about classifying each item in the data interval in the class computed?
    Instead of a series of "if data in rangeA; classA; if data in rangeB; classB;0;0...), why not using the same list of classes for a new function CLOOKUP or CASEIF(cell;classMatrix;classNameColumnIndex;<= or <upper range limit).
    Examples: Pareto analisys, ABC, Inventory Cross analisys, Data stratification

    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 →
  16. Excel for Mac.


    1. We need a simple function that can tell us the last date a change was made to a cell.


    2. We need a "find all" function that lists all examples in a separate box, together.


    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 →
  17. find all function missing on Mac

    Find all isn't available on Mac. Online and PC have this function. Needs to be on Mac too.

    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. 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 →
  19. ability to create named ranges globally to all open worksheets

    as in Windows version of Excel, unable ability to define scope for a named range so that a named range can be used across all opened worksheets

    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. Need a shortcut for trace precedent and dependent

    Need a shortcut to trace precedents and dependents

    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