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…

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

    11 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 →
  3. 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.

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

    8 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 →
  5. 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.

    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 →
  6. 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!

    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 →
  7. 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. 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. PLEASE add the page & cell reference of a formula when alerting the user to an issue when the spreadsheet is opened

    I open one particular spreadsheet and a warning comes up that there is a circular calculation but it doesn't tell me where and I can't find it.

    I think it would be a good idea to add the page & cell reference to assist the user find the problem

    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. Click sheet to add same cell in different sheets to a formula

    Excel 2011 had the possibility to sum the same relative cell in different sheets by typing "=", and then clicking on a cell in one sheet and then just clicking the next sheet and it would add the same cell in that sheet to the formula. This functionality is no longer available in Excel 2016.

    I would have thought that this functionality would have been included when Microsoft added the Preference "Enable Click To Add Mode) in May 2020 (v16.37 or higher). See https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/9603774-just-click-individual-cells-to-sum?tracking_code=5c6fb0a2180ea3d9572d151bf21fefc0
    but they didn't.

    Please add this functionality when turning on "Enable Click To Add Mode.

    Thank…

    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. HYPERLINK function - optional Screen Tip argument

    This should be a relatively easy one: In the HYPERLINK function, please add an optional argument for assigning a Screen Tip.

    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. Money for Excel-Allow user-defiined subcatgeories

    I think of my finances along main domains, like housing, auto, healthcare, etc. Each of the domains, however, should have user-defined subcategories that can drilled down to when needed.

    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. Combine Arrays Function: COMBINE(Array1, Array2 , ...)

    A functions to combine arrays and return a single array. For example, I have a spreadsheet that contains a list of schools and a list of theatres. Some schools also have theatres, so I would like to combine a subset of the schools with the theatres to produce an array of venues that then be used as a validation list. Currently I use the new FILTER() and SORT() functions to create 2 arrays and then use an awkward and complex array function with helper functions (based on MID()) to combine them. Would be great if I could just e.g. SORT(COMBINE(A3#,B3#))

    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 →
  14. weighted randomizer function

    Make a randomizer (for contests, sample data, or simply randomizers) which uses 2 columns; one with the value, one with the weight of said value. Making a randomizer which uses weighted values is a huge pain as of right 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 →
  15. Make the SUM function more convenient to use so when you click the individual cells it will added them opposed to having to put + btw cells

    Make the SUM function more convenient to use so when you click the individual cells it will added them opposed to having to put + btw cells

    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. 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. Filter/explode category in Formula Builder

    One can search and Scroll in the Formula dialog. If you don't know what excel will call a function you need to scroll. What you usually know is if you will need a function on text, Date/time, number, stats etc... It would then be very nice to filter the enormous list of functions based on topic / data type you are to operate on.

    Seems like a small feature add, that would help a lot.

    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. translation function

    It would be a great time saver if there was a translation function that worked like a reference function. Especially if you work internationally and have to enter 2 languages in e.g. a list to make it easier to understand, this function would be very practical, because you would have to enter it once and then you could transfer it to the other cells.
    For example: column A is German and column B should contain the corresponding English translations. Instead of having to translate everything manually, a function would be simpler here, which would transfer the following information: If A1…

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

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

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

Feedback and Knowledge Base