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 extend FIND and SEARCH Function to search from right to left. Also if possible add a unction to reverse string.

    Please extend FIND and SEARCH Function to search from right to left. Also if possible add a function to reverse string.

    Thee 2 important and basic functions are missing

    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 →
  2. 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…

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

    159 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. GetHyperlink function

    There needs to be an GETHYPERLINK function that lets you reference the hyperlink that is alreday associated with a cell.

    For example if the contents of cell A1 =HYPERLINK("https://www.microsoft.com","Microsoft Home Page")

    Then there needs to be a way to put in cell B1 =GETHYPERLINK(A1) which would return "https://www.microsoft.com" without needing to do it in VBA.

    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 →
  11. 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 →
  12. "Cross-join" function for dynamic array that gives all possible combinations of multiple dynamic array?

    For example, A6#: {2, 3, 5} and B6#: {A, B, C}

    All the combinations of {2 A, 3 A, 5 A, 2 B, 3 B, 5 B, 2 C, 3 C, 5 C} can be returned in a 6 x 2 dynamic array.

    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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. Add Translate Function

    Add Translate Function as like as google sheet googletranslate function. it is very applicable if you add it in Mirosoft Excel. Thank you.

    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. can Microsoft pay us for good suggestions made

    Can Microsoft pay us for good suggestions for improving Ms Excel usability?

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

Feedback and Knowledge Base