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. Add a CONTAINS("find_text","within_text") Function

    Excel's own documentation recommends pairing the ISNUMBER and SEARCH functions to accomplish this, but I still have team members asking on a regular basis for a function that returns whether a string is found within a given cell. An out of the box CONTAINS() function would go a long way for usability.

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

    We’ll send you updates on this idea

    12 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  2. Reverse FIND and SEARCH functions to search from the right

    Add functionality using the start_num as negative to search from the end of the string.

    FIND("123","123123",-1) would return 4
    FIND("M","Miriam McGovern",-1) would return 8

    This would help in parsing filenames that include paths, for example.

    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. How About an downend and rightend function

    I have to use a OFFSET fuction for a dinamic array and I was thinking is a good idea have the posibility to use a new function for detect the last column/row in an area like in VBA. Something like:
    =OFFSET(A1,1,0,1,COUNTA(RIGHTEND(A1,1)))

    where RIGHTEND be like
    =RIGHTEND(cell_reference,0 or 1 can be right or left)

    Same case for DOWNEND
    = DOWNEND(cell_reference, 0 or 1 for up or down)

    It can be vey practical.

    Thanks!

    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 →
  4. Pull Current Stock Prices and Historical Data Into Excel

    Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.

    It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.

    1,027 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    375 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →

    Hi everyone,
    Stock data types are now available to all Windows Office 365 subscribers with an English editing language installed (our data is only available in English at this time). You can find some instructions on how to use the feature here: https://support.office.com/en-us/article/get-a-stock-quote-e5af3212-e024-4d4c-bea0-623cf07fbc54. The feature will also be appearing in Excel for Mac and Excel Online in early 2019 – as usual, Office Insiders will see the feature before the general population. See http://aka.ms/officeinsider for more info.

    One pro tip to locate instruments on a different exchange is to include an ISO country code alongside the symbol, for instance MX MSFT will tell Excel to grab Microsoft from the Mexican stock exchange instead of Nasdaq. We’ll be publishing more thorough documentation in the near future.

    We also acknowledge that this is only half of the requested feature in this suggestion – the current stock prices piece. The ability to…

  5. XLOOKUP AND $

    When selecting the data ranges that have the information you want, enter the $ on the range: XLOOKUP(A5,$D$1:$D$80,$G$1:$G$80)
    I'm working 30 years with spreadsheets and I've probably use VLOOKUP without the $ 5 times. People with less skills forget to include the $ and the formulas don't work properly and they have to call me for help.

    4 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 →
  6. Add single use functions

    I’ve thought of a couple of functions that would be helpful.


    1. A GetSingleDate function. If you put this in an empty cell, it returns the current date and won’t update again. In a Table it would have the effect of being a date created value for that row.


    2. AutoNumber. Like MS Access, it returns the next number in sequence. After it gets a number the first time, it won’t increment again. In a table it would be just like autonumber in Access. Parameters could be starting number and increment.


    I have implemented both of these with VBA and they have…

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

    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 →
  8. I found a mistake of EXCEL function 'QUARTILE'. How can I feedback this mistake to your development team?

    Hello,

    I found a mistake of EXCEL function 'QUARTILE'.
    I use the example data via https://support.office.com/en-us/article/quartile-function-93cf8f62-60cd-4fdb-8a92-8451041e1a2a?omkt=en-US&ui=en-US&rs=en-US&ad=US to explain the details.
    I believe the formula of function 'QUARTILE' is wrong according to statistics. This serious mistake may mislead people.
    Please feedback this mistake to your EXCEL development team and fix it ASAP.

    Please find attached excel for details.

    You can contact with me via fang.lin@te.com

    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 →
  9. Modify the Optional Search mode Parameter to specify Instance number of the Search term in XLOOKUP

    Make The [Search mode] parameter to accept values as below
    1,2,3 etc to mean 1st instance, 2nd instance etc from the top
    -1,-2,-3 to mean 1st instance , 2nd instance etc from bottom

    The search algorithm is already specified in the [Match Mode] parameter so there is no need to duplicate it again in [Search mode]

    7 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 →
  10. Be cool to be able to set a default value in a data validation list that shows if no adjustment is chosen

    When selecting the data validation dropdown list it would be great if you could preset the field to show a default value.

    For example, a list of currency alternatives, and a default value of GBP. How can I do that with the current program?

    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 →
  11. Convert Number to Word (SpellNumber)

    A very much need function which should allow Excel users to convert number to word.

    Example :
    1. $ 450.00 it should convert to US Dollars four hundred fifty and zero cents only.
    2. SAR 450.00 it should convert to Saudi Riyals four hundred fifty and zero halalas only.

    Note : the conversion should be based on regional setting and user should be able define the currency code.

    =SpellNumber([cellReference],"CurrencyCode")

    13 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 →
  12. 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. Function and formulas recommended

    Mohammed A Elrify
    Mohammed A Elrify Occasional Contributor

    4m ago

    Suggested to Microsoft EXCEL
    By creating the advantage of the proposed Function and formulas recommended
    Such as recommended pivot tables and recommended charts

    For example, the work of options for the user
    For example if he wanted to compile on terms, he would have the formula SUMIFS ready and only a choice
    Also like the search that VLOOKUP uses
    And so on
    I hope the Microsoft community will support and encourage this idea

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

    We’ll send you updates on this idea

    20 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  14. Evaluate Formulas based on spilled array need to show evaluation for each row (not just formula row)

    If you enter a dynamic array formula in cell A1 (which spills the results) and then you write a formula in cell B1 that is based on A1# that results set will also spill.

    However the evaluate formula function will never evaluate for any row in the spilled array in column B except B1. Put another way if you go to cell B2 and click Evaluate Formula and step through it the formula that is evaluated is the formula in cell B1. This makes it impossible to debug formulas based on spilled arrays.

    I really think this is a bug…

    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 →
  15. named range fix - excel 2016

    Named Range fix required due to re-occurrence of previous issues in Excel 2016

    This relates to named ranges being lost when duplicate names used at scope workbook and worksheet used between linked workbooks.

    http://eileenslounge.com/viewtopic.php?f=27&t=3604&hilit=disappear%E2%80%A6

    I have examples of files where the order that workbooks are opened affects whether named ranges appear/disappear or not and hence whether formulas work or return errors.

    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 →
  16. Anchor period during formula entry.

    Upon upgrading to Excel version l 365 16.0.11328, I lost the ability to anchor formula ranges with the period key instead of the colon. Prior to this version, hitting the period would insert a colon so that I could complete a cell range. Could this functionality be added back to the "Transition Navigation Keys" option?

    Having started with Lotus 123 back in the 1980's, I still use "Transition Navigation Keys." Using the period during formula entry has become second nature and is embedded in my muscle memory. Please kindly consider this for your more "seasoned" Excel users.

    6 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 →
  17. Be able to use user-defined Power Query functions in Excel formulas

    Power Query has a few advantages over VBA for creating user-defined functions for use in Excel formulas:

    • Power Query produces shorter code that is faster and easier to write. This is largely thanks to Power Query native supporting tables, lists, and records; having many built-in functions to work with these data types; and supporting first-class functions and higher-order functions, which eliminates repetitive code and grants the programmer more expressive power than VBA.

    • The Power Query GUI produces code that is closer to ideal than the VBA code that the Macro Recorder produces. Power Query also shows your recorded…

    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 →
  18. Does Microsoft pay for good Excel sujestions and ideas ?

    Does Microsoft pay us for good suggestions to improve the usability of Ms Excel ?

    Please reply.

    Lakdasa Dassanayake

    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. Toggle Relative/Absolute for Structured References

    When referencing a table column, it's cumbersome to add the additional square brackets and repeat the column name to make the reference absolute.

    It'd be great if the F4 shortcut could also work in this, so toggling
    tablename[ColName] --> tablename[[ColName]:[ColName]] --> tablename[ColName], or, when referencing the same row from within the table,
    @[ColName] --> [@[ColName]:[ColName]] --> @[ColName]

    Many thanks,

    6 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 →
  20. Directions from 0 to 2pi 1)atan(x,y) 2)atan(E,N) and from -pi to +pi 3)atan2(x,y)

    1)atan(x,y)=pi-pi/2(1+sgn(x))(1-sgn(y^2))-pi/4(2+sgn(x))sgn(y)

                   -sign(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y)))  when x=x2-x1 ,y=y2-y1
    

    2)atan(E,N)=pi-pi/2(1+sgn(N))(1-sgn(E^2))-pi/4(2+sgn(N))sgn(E)

                    -sgn(N*E)*atan((abs(N)-abs(E))/(abs(N)+abs(E))) when N=N2-N1 ,E=E2-E1
    

    3)atan2(x,y)=pi/2(1-sgn(x))(1-sgn(y^2))+pi/4(2-sgn(x))sgn(y)

                     -sgn(x*y)*atan((abs(x)-abs(y))/(abs(x)+abs(y)))  when  x=x2-x1 ,y=y2-y1
    

    The above fuctions give the directions in the 4 quadrans for all the pairs of dx and dy.

    For dx=dy=0 the result is indefinite .

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

    We’ll send you updates on this idea

    15 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base