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. Increase/Decrease value of a numeric cell by 1

    Increase numeric value of a cell (which does't have formula) by 1 if we press a key ( lets say Alt + right arrow) and decrease the value by 1 if we press another similar key ( lets say Alt + left arrow). As a modeler/data analyst, this feature would be truly great.

    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 →
  2. Add a Switch Reference button to Ribbon

    Many know the F4 is used with authoring a function. However it needs to be memorized. please create a button on the ribbon to switch between types of referencing.

    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 →
  3. Automatic update of text value in textboxes linked to cells and maintain the format of the text in textbox

    Textboxes can be linked to cells for values / texts. But, if it is a dynamic connection, in the sense, if the value in the cell changes based on formulae, the textbox takes the first given value. Then, on, even if the cell value changes, the value in the text box does not change in the current scenario. Everytime, we need to press F2 and enter for the formula / datalink in the textbox to get updated. But after that, If we have to manually update the format of the text in the textbox. If both these activities can happen…

    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 →
  4. 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 →
  5. Add an IN() function to check for existence of a value

    Right now, I often use formulas like this:
    =IF(COUNTIF("A", myRange)>0, ..., ...)

    It's be handy to be able to just use:
    =IF(IN("A", myRange), ..., ...)

    This could also help with formulas where a number of different criteria are allowed:
    =SUMIFS(B:B, A:A, "2016") + SUMIFS(B:B, A:A, "2013") + SUMIFS(B:B, A:A, "2010")
    becomes
    =SUMIFS(B:B, A:A, IN(A2, "2016", "2013", "2010"))

    3 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 →
  6. Convert all instances of compatibility functions to their newer counterparts

    The compatibility functions are under that category for a reason: they've been superseded. Please give us the option to convert all instances of compatibility functions to their new counterparts. With such a feature in place, Microsoft could remove the compatibility functions sooner. The list is only going to grow and become cluttered over time.

    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. Change SUBTOTAL's description

    SUBTOTAL's description is "Returns a subtotal in a list or database". When I read that, I think that it does the exact same thing as SUM, so why would I use it?

    The first catch is that SUBTOTAL doesn't just do sums, but several other aggregate functions. Even with this information, it's not obvious why I would want to use SUBTOTAL(4,) as opposed to MAX().

    The second catch is that SUBTOTAL has 2 special properties: it ignores other SUBTOTAL functions (good for grand totals) and it ignores filtered out results (AutoFilter or Advanced Filter).

    SUBTOTAL's description should reflect all of…

    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 →
  8. Function to return reference returned by a cell's formula

    If cell A1's formula returns a reference (e.g. INDEX():INDEX()), then no other cell can refer to that reference. A reference to A1 is not the same as a reference to the reference that its formula returns.

    I believe that we should have a function that can access this reference. For example, if I call REREF(A1), then I get the reference to INDEX():INDEX().

    This function would come in handy when you want to use a helper cell to hold a reference. It avoids having to define the reference as a name.

    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 →
  9. Make XIRR function more flexible

    The MS Excel 2010 function XIRR requires that cells that are included in the formula must be numbers and dates. But there should be an option that with ADDRESS function you can specify the first and last cell, for values and dates, respectively. When you specify the necessary cells, simply select them in a form of a range and calculate the formula.

    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. Lets users set exponential smoothing beta and alpha

    In some fields, such as supply chain management, it helps for analysts to be able to set their own alpha and beta values when using the new exponential smoothing functions. I don't think it's necessary to build it into the Forecast Sheets.

    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 →
  11. 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. Add a funciton to search in a string from the end (INSTRREV)

    Please add a formula that works like INSTRREV in VBA.

    (2016-03-08 Dan [MS] - updated title to include INSTRREV, when merging in duplicate idea)

    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 →
  13. Function Picklist and Parens

    When entering a function name while editing a formula you gets a pick list. Suppose you enter =Su you get a list {Substitute, Subtotal, Sum, Sumifs,....Sumxmy2} and you pick Sumproduct you get =Sumproduct( which is the name you picked and a left paren.
    However, if suppose you have an existing formula =(A1+A10)/2 A1=22 and A10=33 and you want the Sqrt. So you place your cursor to the right of the = and use the picklist and Excel sees a paren and does not add another ( giving =SQRT(A1+A10)/2 resulting in 3.708099 which is not what you want and no error…

    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. Async formula when querying data from remote services

    Many services offer APIs which allow retrieving data through excel formula, however these services are often remote and can take tens of milliseconds to return results, when done synchronously this can be very time consuming over many cells.

    The oft-used work around is to return a dummy result and use eventing to populate the actual result when it returns, creating a pseudo async formula. This however when used with automatic calculation the constant updating of values can cause many additional recalculation steps, when used with manual calculation you have no idea when the data has actually be retrieved which is…

    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. Integrate units into cells for display and mathematical operations

    Allow numbers to be displayed with text (without using the concatenate), while also being able still use the numbers/text for equations. Then units can be displayed (e.g.20 mm) and referenced to be operated on via another cell (e.g. 20mm*2+5 = 205mm)

    ---------------Keep reading if want more Details/explanation---------------
    Minimum way to implement would be to provide function to ignore all text for calculations (de-concatenate?) but then add it back in at the end (re-concatenate)...all in one function. This would be the quick and dirty method to get the low hanging fruit.

    Super slick way to implement would be to go a…

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

    We’ll send you updates on this idea

    10 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  16. Root Mean Square Error (RMSE)

    Please add RMSE formula to statistical function library.

    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 →
  17. worksheet function for returning a field inside a delimited lists

    I’d like to have a function available that returns a specified field within a delimited list. I would pass the list, a delimiter and a field number as arguments to the function and it should return the value in that field.

    For instance with the pipe separated list ”TEST1|TEST2|TEST3|TEST4| TEST5|||||||TEST|” in A1.
    I’d like to use something like GetFieldInDelimitedList(A1;"|";5) and have it return “TEST5”.

    Any equivalent formula will requires quite a lot of nested functions e.g.:
    =MID(A1,FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1,FIND("([])",SUBSTITUTE(A1,"|","([])",5))-(FIND("([])",SUBSTITUTE(A1,"|","([])",4))+1))

    13 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 →
  18. Date/time stamp with auto update

    A means by which entering/changing data in a range would update a date/time stamp. It could be a simple function like TimeStamp(range). This would be hugely beneficial when for example working with a group of coworkers on a data table in a shared spreadsheet, allowing the team to immediately see what has been updated without forcing team members to manually enter a date/time for each edit.

    5 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 →
  19. string function which returns the number of occurences of a sub-string

    I regularly have comma separated lists, and would like to know how many values there are in the string. Currently do that in VBA, but it would be nice if there was a function for that. E.g.:
    A1 = "abc, def, pqr, xyz"
    B1 = PARAMS(A1,[optionally]",") optionally so that you can do ; or others as well

    5 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. Build more tools to perform stochastic / probabilistic analysis and Monte Carlo simulation

    1. More inverse cumulative distribution functions (Poisson, Exponential, Negative Binomial, Weibull, etc.);
    2. Ability to confine the distribution between certain values;
    3. Ability to generate / simulate time series;
    4. Ability to sample/simulate all inverse cumulative distribution functions without continuously recalculating the workbook (ex. run the simulation behind the scenes much like the current IRR function operates though iteration);
    5. Ability to correlate distributions;
    6. Ability to run sensitivity analysis on the results;
    It is currently possible to build all of the above functionalities through VBA but having dedicated tools will bring considerable efficiency improvements.

    11 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 →

    Thanks for logging this, Lyubomir. How do you do these today? Is deeper integration with R potentially useful for such scenarios, at least for the analysis?

  • Don't see your idea?

Feedback and Knowledge Base