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. New Formula editing experience

    With the arrival of LAMBDA and LET we now need a new formula bar experience. Please vote and put your suggestions in the comments on what features you’d like the formula bar to have

    115 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    24 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. See LAMBDA inputs and text in formula edit box

    When selecting a cell with a LAMBDA function and then using the fx icon to display the Functions Arguments dialog it would be wonderful to see the function's input name(s) and description (from Name Manager's Comment box).

    Please see attached mockup

    41 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. Use new dynamic arrays in data validation

    The use helper columns in tables now often is unnecessary if using the the new dynamic arrays. But if I want to use the output of one of the new functions as the source for a data validation list, I need to put the function in a cell and reference to that cell as the source for the data validation list. I would like to be able to put the dynamic array function directly into the source field of the data validation dialog.
    Example: I have a table with a column of countries. I want to add a cell with…

    58 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  4. Add a Split dynamic array function

    Add a dynamic array function to split apart a delimited range. See attached file for an example.

    292 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    30 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. SUMCOLS and SUMROWS functions for Dynamic Arrays

    Create new functions that SUM each column in a dynamic array (SUMCOLS(Ref#)) to produce a row of totals, and SUM each row to produce a column of totals (SUMROWS(Ref#))

    Also COUNTCOLS, COUNTROWS, AVERAGECOLS, AVERAGEROWS, but these are less important than SUMCOLS & SUMROWS.

    289 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    43 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow INDIRECT to work with dynamic names

    Now that we have dynamic arrays, we can set up dynamic range names to define those dynamic ranges.

    However, because INDIRECT doesn't work with dynamic names, we're limited in the ways we can use those dynamic names.

    Please fix the INDIRECT function so that it works with dynamic names.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  7. 11 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  8. SUBSTITUTES function supporting arrays of "find" and "replace" parameters

    From time to time, users need to remove multiple characters from a string. For example, you might want to remove all punctuation, or all accented characters.

    Right now, you have to do that with a lengthy nested formula using the SUBSTITUTE function. Such formulas are hard to read and challenging for a novice to debug. Or you could write a VBA user-defined function that performs each of the substitutions for you.

    The better approach would be a SUBSTITUTES function that works like SUBSTITUTE but accepts an array (or range of cells) for the Find parameter, and possibly also for the…

    133 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. Correção na documentação da função SOMA

    Correção na documentação da função SOMA.

    Correção da documentação na função SOMA, como neste exemplo anexo informa que se deve informar de 1 a 255 "números" mas que na verdade são argumentos, podendo dentro delas constar números, célula, intervalo de células, funções ou fórmulas e não somente números, para um usuário que está começando e lê isto pode, e já
    foi presenciado, inserir de forma manual números nos argumentos por não ter o conhecimento e não estar especificado de forma correta a diversas formas que pode ser aplicada.
    Como sugestão alterar o "núm1;núm2"... para arg1;arg2... e de 1 a 255…

    34 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow UNIQUE() to operate on a rectangular range, returning all unique values

    The new Dynamic Array function UNIQUE is awesome. It can return all of the unique items in a column or in a row. But it would be nice if the second argument could accept a 3 to indicate cell-by-cell.
    For example, see the screenshot below.

    102 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  11. Expand Name Editor for LAMBDA function

    Since we will have the ability to use the LAMBDA function in a name definition to create user defined function, it would be a good idea to the expand the Refer To field in the Name Manager beyond a single line. The LAMBDA function has been out in the Beta channel for about a week and already I have seen some very detailed definitions that would be difficult to maintain in that single line.

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add Pakistan Stock Exchange in StockHistory

    PSX is Asia's second best market. There are so many users here.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  13. Correct function Cell (Filename)

    The CELL function and the FILENAME function work incorrect with the most recent update (version16.0.13127.21064). In the previous version this function show the path is through the computer, and not through the URL link, if the files are One Drive. Please correct this function.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Lambda optional parameters

    Using the new lambda function, can we have the ability to put parameter names in square brackets to turn them into optional parameters for the user?
    LAMBDA(parameter1, parameter2, [parameter3])
    This would be extremely useful for reusable functions. For example, I've created a function that combines arrays, but I don't want to have limit that function to passing only a specific number of arrays or forcing the user to enter commas for the remaining criteria. Similar to index, or sumifs or other function that has optional parameters please!
    Also, if you're feeling generous, I'd love the option of hidden parameters too,…

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  15. Can we please get IntelliSense for LAMBDA functions?

    Add the ability to define arguement prompts when using a LAMBDA function

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Why isn't xlookup available for Excel 2019

    Xlookup should be available for older versions of Excel or at least for versions from 2016 and 2019. How come it is not available for these versions is my question.

    2 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. STOCKHISTORY function: Add adjusted closing prices

    For STOCKHISTORY function, please allow us to get not just the closing stock prices but also the closing prices adjusted for dividends and stock splits, similar to what Yahoo Finance has.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. "Excel found a problem with one or more formula references" - Please tell me where!

    One of my least favorite messages that Excel provides is:

    "Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."

    But I can never find the bad references. It's usually buried somewhere very deep, in a chart series formula, or in a name definition, or who knows where else.

    If Excel finds a problem, please Excel, tell us where it is.

    284 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    33 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  19. LAMBDA functions and recursion -- calling a SELF function?

    I would like to be able to call a lambda recursively on the grid without the name manager. a SELF function could refer to the function being written. Is that possible? Here's an example for factorial,

    FACTORIAL: LAMBDA(n, IF(n = 0, 1, n * SELF(n - 1)))

    Here's another for matrix exponentiation,
    MPOW:

    LAMBDA( A, p, 
    
    IFS(
    OR(ROWS(A)!=COLUMNS(A), p!=INT(p),p<0),
    NA(),
    p=0,
    MUNIT(ROWS(A)),
    MOD(p,2),
    MMULT(A,SELF(A,p-1)),
    TRUE,
    LET(
    B, SELF(A,p/2),
    MMULT(B,B)
    )
    )
    )
    )

    3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Change the Excel formula bar to the one from Power BI Desktop

    Change the formula bar for advanced users as well as for beginners. better reading of functions makes work easier for everyone.
    Indent the code, view the line (s) where there is an error, quickly see the syntax of a function and a bar that adapts depending on the length of the code that is entered.

    11 votes

    We're glad you're here

    Please sign in to leave feedback

    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 61 62
  • Don't see your idea?

Feedback and Knowledge Base