Feedback by UserVoice

Excel for Windows (Desktop Application)

Welcome to the Excel for Windows (Desktop Application) feedback forum! This is the place for users to send us suggestions and ideas on how to improve. If you think you have found a bug, please send us feedback in-app instead! To do so, please click “File”, then “Feedback”, then “Send a Frown” in Excel. This way, we will get detailed information that will help us better diagnose the problem.

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. Add an If_NA optional sixth argument to XLOOKUP

    The new XLOOKUP function introduced on August 28 2019 is awesome - exact match by default, the ability to return several columns at once, and search from bottom of data. But one thing would make it better - an optional sixth IfNA argument to provide an answer in case nothing is found.
    One of the benefits of XLOOKUP is to eliminate the need to nest MATCH inside of INDEX. If you are trying to reduce the number of functions this would be a low-impact way of eliminating nesting XLOOKUP inside of IFNA.
    For me, the main argument is that

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

    We’ll send you updates on this idea

    17 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Thanks for the suggestions folks! We’ve added [if_not_found] as the 4th argument to XLOOKUP. The thinking is as follows:

    It’s a reasonably common use case
    The ISNA XLOOKUP approach cannot distinguish a “not found” from a #N/A returned from a valid match.
    - Joe McDaid [Excel]

  2. Absolute Reference Shortcut

    Really simple. Pretty much in all my data analysis involves absolute references and relative references. For a formula I enter, I have to go through and manually type in the $ symbols to lock those references, which can be cumbersome when I have 15 or so references to take care of. What I suggest is a shortcut key e.g. ctrl + click/alt + click where by clicking the cell in the formula using this combination will convert it to an absolute reference.

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

    Great news, we have this in Excel already. as you are authoring a formula, when you select a cell/range, you can press F4 to toggle the “absolute-ness” of the reference.

    cheers,
    dan [MS]

  3. Kill nested IFs

    What about a function like =ELSEIF([if1]; [then1]; [elseif2]; [then2]; [elseif3]; [then3]; ...)

    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 →

    Give our new IFS and SWITCH functions a go – they are exactly what you’re looking for.

    Cheers,
    Dan [MS]

  4. Please add MAXIF and MINIF

    It would just be so useful to have this. Thanks!

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

    We’ll send you updates on this idea

    14 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    2016-04-19

    Hello all,

    Just wanted to let you know that we’ve released MAXIFS and MINIFS to Excel as part of Office 365. If you’re a subscriber you should already have (or see soon) these functions in your arsenal.

    Cheers,
    Dan [MS]

    2015-11 ========
    Hi there,

    Great news – we’re working on this! Actually, we’re working on MAXIFS and MINIFS – even better :-)

    Cheers,
    Dan [MS]

  5. Add a select case function

    =Selectcase(A1>89,"A",A1>79,"B",>69,"C",A1>"59,"D","F")

    7 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. Improve the Concatenate Function

    Make Concatenate to Work with Range of Cells / Arrays rather than 1 cell separated by Comas

    =CONCATENATE(Array,Seperator)
    The Array to Accept A1:A10 or A1:D1 or {"Abb","Areva","BHEL"} or {"ABB";"Areva";"BHEL}
    or

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

    We’ll send you updates on this idea

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

Feedback and Knowledge Base