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. Suggestion: Reconcillion Function

    Reconciling Function.

    A function that looks at a string of numbers and finds the items that add up to a certain amount.

    Example: I have a check from a vendor for (example: $1210 that mentions payment for 5 items, but In my vendor outstanding invoice list I have 25 items. It would be helpful for excel to search through all permutations and give me suggestions as to which 5 items add up to $1210.)

    In a lot of cases there is only 1 combination, which would have to be the solution (or check breakdown in this case).

    Microsoft would be…

    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 →
  2. Sequence function Numeric Run

    Instead of futzing around with things like ROW(INDIRECT("1:"&Len(A1))) and Column and Transpose in order to construct certain array formulas which need runs like 1,2,3,4,...., provide a Seq array function.
    Seq(from,to[,step][,Horiz/Vert]). Also make it imply an array function like does sumproduct.
    REgards
    BRian

    9 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 →
  3. Expand the MATCH function - allow range being searched to be 2-dimensional.

    Expand the the MATCH function capability to allow the second argument to refer to a two-dimensional range, instead of restricting it to data in a single column or data in a single row.
    Microsoft's documentation of the MATCH function (via Excel Help) does not mention this restriction but simply refers to the "range of cells being searched" as if it could be any range.

    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 →
  4. vlookup for 2nd, 3rd, etc occurrance

    How about something like =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup,occurrance) like =VLOOKUP(123,A1:B100,2,FALSE,3) where the 3 means to return the 3rd occurrance of the lookup value. Of course, #N/A if there isn't one.

    9 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. Array Formula - allow us to type the curly braces instead of CSE (and make them persistent when i edit formula!)

    currently we have to use Ctrl-Shift-Enter. What an odd concept. Please make array formulas easy to enter just like any other formula. Either let us type in the curly braces, or add something like ARRAYFORMULA(......). At least, PLEASE make the array formula persistent. Currently if I (or any other user) even looks at the formula, they can easily break it just by pressing enter.

    8 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 →
  6. Network functions, like ping() or nslookup()

    Handy if you have a column of hostnames or IP addresses.

    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 →

    Interesting idea, thanks for the suggestion. I’d be interested to know if there are other functions in this area that people also want to see. I’ll check back soon to see how many votes this is getting, so if you like the idea be sure to vote for it.

    Cheers,
    John [MX XL]

  7. TODAY volatility reduction

    A function like NOW must be volatile because it changes so often. However, even though TODAY can change while the workbook is open, this occurs much less often.

    My suggestion is to track any TODAY-containing cells and recalculate them only when the day changes. This saves on the recalculation of possibly many cells that depend on TODAY (e.g. a "days remaining" column) without having to resort to manual entry in a separate cell. Having a workbook that is fast and requires minimal manual entry are key to user-friendliness.

    2 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 →
  8. VLOOKUP with exact match and sorted data

    VLOOKUP formulas where you want an exact match are often accused of being slow, especially when the lookup table has a large number of rows and columns. And if you have a lot of VLOOKUP formulas, changing a value in the lookup table can result in an annoying delay while all the VLOOKUP formulas using that table recalculate.

    In many cases, the user would be willing to sort the lookup table by the first column--provided that led to a significant improvement in recalc time because of a binary search. The problem is that setting the fourth VLOOKUP parameter to TRUE…

    6 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 →
  9. Formula autocomplete - select with Spacebar

    Excel's autocomplete on formulae is nice, except that there doesn't appear to be a shortcut key to actually accept the suggested formula. The only way to select it afaics is to pick up the mouse and click on it, which is annoying when your hands are on the keyboard.

    Apologies if a shortcut key for this already exists, though I've never found it and I also checked here:
    https://support.office.com/en-us/article/Use-Formula-AutoComplete-6d13daa5-e003-4431-abab-9edef51fae6b

    1 vote
    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 →
  10. Cortana should learn excel syntax so that I don't have to

    Cortana should learn excel syntax so that I don't have to. Pretty simple, for users that don't want to learn functions such as left/right, they should simply be able to say "Cortana, take the last 3digits off that column and put them in the next column" "Make me a pie chart with the colors red white and blue"

    (2015-11-05 Dan [MS] - added to Formulas and Functions category)

    8 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 →
  11. Sum quarters more easily.

    A formula function that sums quarters from a year's data series. It is easy to sum the entire year (all 12 columns) for example. But to sum each quarter, its a manual process.

    For example, =quarter(full year series,1) result equals sum of 1st 3 columns. Or =quarter(full year series,3) result equals sum of 7th, 8th, 9th column)

    Thanks!

    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 →
  12. In EXCEL 2010 with all updates available installed, the polynomial curve fit otion only works for second power equations no matter the input

    in EXCEL 2010 (with all updates installed) the polynomial curve fit option only works for second power equations even if you tell it to fit with higher power polynomials. This used to work perfectly but one of the recent updates must have affected this

    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. MODE function work for text

    Could you make the MODE function work for text?
    Currently you have to do a crazy index and lookup thing, which could all be made so much easier if mode worked for text. i.e., if you have MODE("a", "b", "c", "a") you would get "a".

    7 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 →
  14. Suggest formula simplifications to the user

    For those without a strong Excel, math, and/or computer science background, formulas can be much more complicated than they need to be. To help them along, Excel could suggest simplifications to commonly used simplifiable expressions. It would be like a spell checker, but for logic.

    Here are some simplifications that I've done over the years:
    IF(A1=1,"",IF(A1<>1,"s","error")) has an unreachable part "error" and becomes IF(A1=1,"","s").
    NOT(A1<B1) becomes A1>=B1.
    IF(A1<0,0,A1) becomes MAX(A1,0).
    DATE(YEAR(A1),MONTH(A1)+1,1) becomes EDATE(A1,1).
    SUMIFS(,,"="&A1) becomes SUMIFS(,,A1).
    (A1*B1)+C1 becomes A1*B1+C1.
    ...
    and so on.

    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 →
  15. vlookup should treat the lookup value as it APPEARS

    If you VLOOKUP (or HLOOKUP) 123 (or a range containing 123) into a range which clearly has 123 in it, but the latter is formatted as text, it doesn't find it. If it LOOKS right, it should find it!

    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 →
  16. Track affected cells

    Have a tool that allows you to see what cells (or ranges) are changed when a given cell is altered - i.e., the entire dependency tree rooted at that cell. It is much easier than trying to manually do trace precedents 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 →
  17. Need a "DELETE" function to work in a formula to automatically delete rows when a certain value exists in a cell

    I have seen, over the years, NON-automatic methods for this.

    I am asking if MS will please develop a new FUNCTION called 'DELETE ROW' that can and will AUTOMATICALLY delete a certain range of rows, if another cell contains a particular value or character.

    Everything I have seen that seems to suggest this functionality won't do it.

    And myself and about 98% of MS Excel Users no nothing about VBA (if that's the internal complex programmer's language). I am looking for an honest to goodness automatic Delete Row FUNCTION that will delete rows specified in a formula by itself, if…

    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 →
  18. Daylight savings time

    We should have functions that allow for the conversion of non-DST time to DST and vice versa. To determine the location parameter for DST rules, have a map pop up so that you can choose where you are.

    To give you an idea of how complicated this can be from a user's perspective, this is the formula that I use to convert non-DST to DST:

    A1+TIME(ABS(A1+WEEKDAY(DATE(B1,3,7))-DATE(B1,7,12)-1/12)<=119,0,0)

    where A1 holds the datetime and B1 holds YEAR(A1). This is the shortest formula that I've come across/come up with, and it only applies to Canada, and its derivation is difficult. Surely Excel can…

    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. Function to only use every xth-row or column in another function

    Function to only use every xth-row or column in another function

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

Feedback and Knowledge Base