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. Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality (see description)

    Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality for example =UNIQUE({Z:Z},{A:A})

    Also, please upgrade the protection similar to Google sheets or rather launch all Google sheet functions here as well.

    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 →
  2. Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality (see description)

    Please introduce Split formula, uniqueifs, countuniqueifs, flower bracket functionality for example =UNIQUE({Z:Z},{A:A})

    Also, please upgrade the protection similar to Google sheets or rather launch all Google sheet functions here as well.

    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 →
  3. 2 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 →
  4. Convert Dynamic Arrays into Tables

    The new Dynamic Arrays make possible to automatically fill down formulas. Tables can also fill down formulas. Microsoft Excel Team could make both features be compatible so we could convert Dynamic Arrays into Tables making them expand and shrink according to the main formula.

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

    We’ll send you updates on this idea

    23 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Add a MONTHDIF function

    The formula should work like the YEARFRAC function. It should calculate partial months on either end of the dates. So starting 1/15/20 should calculate as 16/31 days or 0.516.. months, and ending at 6/5/20 should calculate as 25/30 day or 0.8333.. months. Currently, I have to use a ridiculously long formula to achieve this.

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

    We’ll send you updates on this idea

    9 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  6. Need Stock Data Type Functionality on Office Pro Plus 2016

    Dear Microsoft Team :( ,

    Did you know there is a Stock Function in all your desktop versions of office products and did you know it does not work?

    I am wondering if you will ever get it to work? It's not that you are short on funds to add that additional line of script to pull the free data from from exchange.

    If you still don't want to give it as a free update to your customers, you can sell it as a chargeable add-in.

    If you don't want to do either, please add a pop-up saying "YOU WERE…

    3 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 →
  7. COUNTIF, SUMIF............etc. based on cell color

    If Excel allow us to use cell color as function criteria, it would be wonderful.

    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 →
  8. DECODEURL function

    Currently, The ENCODEURL function returns a URL-encoded string, replacing certain non-alphanumeric characters with the percentage symbol (%) and a hexadecimal number.

    There needs to be a DECODEURL function that does the reverse, replacing the percentage symbol (%) and a hexadecimal number with the appropriate non-alphanumeric characters.

    2 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 →
  9. DONT'T CHANGE MY FORMULA!!!!!!!

    How about keeping the formula intact, returning a #REF result and NOT editing the formula with a #REF comment. This stupid idea prevents one from following the formula back and evaluating what the error is, or what cell it's referencing. Who ever thought of doing this should have some training! If one receives a spreadsheet developed by someone else, they may not know how the formulas work/reference, but leaving the formula intact gives the opportunity to understand what the result should be. CHANGING the formula should NEVER be an automatic option by the software!!!!!

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

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  10. Formula to get valueout of merged cells

    lets say we have merged cells A1:D10, when I do =A1 then I get the value, but when I do =C3 then I get nothing becuase the value is not stored the. But if there would be function, lets say =GetMergedValue(C3) so it would lookup the merged area and gets the value, this would be great!

    2 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 →
  11. Date picker button for excel in offfice 365 for Windows 10 64 bit

    I am so surprised that there is no Date picker function available in Excel 365. I see that this function existed and has been removed. this makes no sense to me what so ever. This is what has been pushing me away from Microsoft. This is why I have stopped using One note ( due to feature removals) and seek other options as you just cant rely on such thing.

    I feel less protective of Windows/ MS at home and hence Apple and Google devices have started replacing MS specially by Kids. Surface pro 4 was highly disappointing. So now…

    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 →
  12. Support of dynamic array formulas in tables

    Support of dynamic array formulas in tables

    1 vote
    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 →
  13. Formula to return multiple values from LookUp function

    We need a simple formula that can return all the values from data source based on a lookup. Vlookup, Xlookup return only first matching value and don't check further.

    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 →
  14. Add Non-Repeating Option to RANDARRAY

    Currently it is difficult to get non-repeating random numbers in Excel. Can we add an option to RANDARRAY to force it to only generate unique random numbers?

    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 →
  15. vlookup case sensitive

    very simple,VLOOKUPs are case insensitive, VLOOKUPS should be case sensitive. One use case are Salesforce reports. They produce 15 character Ids that require case sensitivity functionality in order lookup against.

    11 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 →
  16. Allow lookup functions to spill in two dimension

    Currently Vlookup, Xlookup, Lookup and Index function is able to produce a spilled array only across one dimension (i.e. row or column).

    So, if I give a formula like =Vlookup(J4#,Table1,{2,3},0), it spills only across rows and does not spill across column. This limitation exists with every other function in the lookup family.

    If these functions can be made to spill across both the dimensions, we can completely avoid copy pasting in MS Excel.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Disable the "SPILL!" error function completely

    Disable the SPILL! error fucntion/code completely, it is garbage and wrongfully tags formulas with SPILL! Having to go in and change formula syntax to satisfy this random error is ridiculous.

    4 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 →
  18. Please add Xlookup and XMatch functions for Office 2019 Professional Plus users.

    Please add Xlookup and XMatch functions for Office 2019 Professional Plus users.

    For that matter either give Office 2019 Pro Plus users the option to migrate to Office 365 at a reduced cost or provide the nice new office 365 functions to Office 2019 Pro Plus users

    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 →
  19. Extend XLOOKUP and XMATCH to return nth matched item/position

    INDEX, MATCH and other variants return the FIRST value that matches the given criterion. Extend the functions (especially the new XLOOKUP/XMATCH functions) so that the formulae return the nth matching item or position

    Extend XLOOKUP and XMATCH to return nth matched item/position

    9 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 →
  20. Immediately color-code cell references upon selection

    When we edit a cell by double-clicking it or hitting F2, we get a very helpful color-coding of the cells it references. Why can't we just get this color-coding immediately upon selecting the cell? That way we could easily click or arrow-key through several cells and quickly see what they're referencing, rather than having to squint and find "Column G.... Row 11....., Column K .... Row 15....", etc.

    See attached GIF animations demonstrating the current behavior versus what I'm proposing.

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

Feedback and Knowledge Base