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. A simple simulation module that is simple and easy to use

    add a simple to use simulation function

    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 →
  2. Update Excel and add new features

    A lot of features had come with the latest Windows update but now after 4-5 days all have disappeared like dynamic array formulas, ideas.

    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 →
  3. Add format IFS in Excel 2016

    Add format IFS in Excel 2016

    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 →
  4. Have a date function that is shows the date of when a data point was entered

    We'd like to have a function in which we could see the date of when a data point was entered into the system. Like that we wouldn't have to enter the date manually every time we entered a data point into the spreadsheet. it would be like an if statment, example( =IF(B3<>" ",DateOfEntry()," ")) the function itself would be the "DateOfEntry()" the issue we have with Today() is that it updates every day and therefore every time we enter the spreadsheet the date information is updated to the current date and we arent able to have proper tracking of the…

    18 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. STOCKHISTORY Sorting

    Recently used STOCKHISTORY function and its very useful and most awaited feature, however I believe data should have been sorted new to old or sorting of the data should have been available. Hoping to see this option available in the function.

    Again, amazing function provided. extremely helpful. Thanks MS Excel team.

    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. Convert Rectangular Array to Single Column/Row

    Pretty simple. Take an nxm array, and convert it to a simple 1 dimensional list.

    I find myself performing this task on a reasonably regular basis, and it would work well in combination with the UNIQUE function, and SORT....FILTER.

    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. spill a cell's function

    I would like to have the ability to spill a cell's function. For example, entering this in row 2 needs to be copied to all rows.

     =AVERAGE(BE2,BG2,BH2,BJ2)
    

    Could Excel do it for me by having a spill function or operator? such as:

     =spillf(AVERAGE(BE2,BG2,BH2,BJ2))
    

    It may sound like laziness, but when a spreadsheet has a lot of these it would seriously help (especially when prototyping) to code it once and have it apply to every row from that point.

    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. Excel Formula Bar TooTip Pop-Up needs useful changes

    Example below, to apply on all functions tool tip
    On-clicking (lookup-value, Excel selects the content in the formula bar

    But when I…
    Current – On Clicking XLookUp hyperlink take me to help.
    Instead Change To – On Clicking XLookUp – select the Xlookup from start to end.

    Benefits
    Allows me to press F9 in formula bar to check the Spill effects.
    Allows me to copy (Double CC) the formula to clip board and test with another variable/input.

    Additional Changes
    Move Button
    Help Hyperlink or More Details

    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 a VOID() worksheet function

    VOID(p1, ..., pn) where each parameter is a cell or a range

    It deletes the contents of the specified cells and returns the number of cells whose values are cleared (similar to the return value of COUNTA() before the cells are cleared)

    It is suggested as an alternative to the NULL() function requested by others and hasn't been implemented yet, presumably due to some technical challenges.

    The VOID() function is different in that it does not require a cell's content to be cleared by assigning a value, which sounds like a contradiction in terms.

    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. Error en función DIAS y DIAS360

    Hay un error del orden en el cual aparece la función DIAS en la aplicación de Excel. EN el screenshot adjuntado se puede notar como la primera mitad de la pantalla enseña que en Excel la fórmula debería escribirse como =DIAS(fechainicial,fechafinal), mientras que en la segunda pantalla se ve como en el artículo online de Microsoft explican que se debería escribir como =DIAS(fechafinal,fechainicial).

    Asimismo, en el caso de la fórmula DIAS360, si metes la información como dice en la aplicación DIAS360(fechainicial,fechafinal) te arroja un dato positivo, pero es completamente incongruente con lo que la…

    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. Prise en charge des liens hypertextes sur mobile

    Prendre en charge les liens hypertextes d'un fichier Excel qui renvoient vers un onglet éxistant du même fichier pour la version mobile.
    Actuellement cela fonctionne sur un PC, mais rien ne se passe sur un téléphone (Android, iOS, etc...)

    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. Enable a way to define a subsection of a column as a calculated "column" without inserting a table. I need the data to be stacked, while als

    Either be able to insert columns when tables are stack on top of each of but the exact same width, or be able to define a portion of a column as a calculated "column" without inserting a table.

    I need certain portions of my worksheet to add the formulas when new rows are inserted without having to pull them down - this is because other people use this template and are not as well versed in Excel and it can quickly go off the rails.

    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. formula to return text string with multiple complex lookup criteria

    We really need a formula that can return a text string with multiple lookup criteria.
    Sumproduct is nice but only works for returning a sum.
    The case is a table or other similar data structur with Column A = project ref, Column B = person, Column C = start date, Column D = end date.
    The formula should be able to return the column A text string by looking up a match of a person in column B and a input date that is in the interval between the dates in column C and D.

    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. 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. 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. 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. In Excel formulas such as IFS, COUNTIFS, SWITCH, use a semicolon after a criteria pair or after each similar pair or ********* of arguments

    In Excel formulas such as IFS, COUNTIFS, SWITCH, use a semicolon after a criteria pair or after each similar pair or ********* of arguments. This will improve readability

    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. Formula to calculate tax years between 2 dates;get the tax year in which the date is


    1. The formula that calculates tax years between 2 dates.

    2. The formula that gives the tax year for a certain date.

    3. The formula that counts the number of 6th Aprils (any date) between 2 dates

    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. Adding different colors to the Trace Precedent/Trace Dependents arrows

    Add additional colors to be used in the Trace functions, instead of only the blue. It would make it easier to determine which cells are included in a range.
    Similar to different colors when summing several rows.

    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. FIFO and other stock review-methods

    Good it be possible to create a single formula to make a FIFO-review and other methods as well

    Of cause the input data shall be in a datamatrix transaction date/time ; sell/buy ; value pr. item ; name of item ; number of items. And for every sell-line, there shall be a profit or loss number.
    Of cause there will be a number of Error-possibilties (like: when selling more then there is in the portfolio, that is not possible...then cost is 0 or an errormessage like dvididing by 0 is impossible.

    There is some ressources on the internet, were you…

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

Feedback and Knowledge Base