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. implement data analysis in excel online

    implement data analysis in excel online

    6 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. Include a button to change the border color of the active cell

    Include a button to change the border color of the active cell

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

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  3. How about some geodetic functions?

    It would be nice to see some geodetic functions like great circle distance between two points, final lat/lon given a starting point/direction/distance etc. Vincenty's approach for direct and indirect solutions is pretty reasonable to implement.

    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. HIGHLIGHTING ROWS IN FIND

    When using the "FIND" function, allow users to highlight the whole selection/part of a selection matching a particular search criteria.

    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 →
  5. Numbers to Words

    We desperately need an INBUILT and SIMPLE function wherein we can convert the amount mentioned in number into words.
    (For Example Rs.25,000 to Rupees Twenty Five Thousand Only)
    Many accounting software are capable to do so. So why excel being the most sophisticated calculator in the world can't add this simple function. Many accountants are dependent on your spreadsheet software. Please don't disappoint accountant community.

    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 →
  6. Formula - "-1^2" - First squared and then minus is correct.

    When I input "-1^2", the result is 1. Is it an error? First squared and then minus is correct. It should be different from "(-1)^2". It should be the same as "0-1^2".

    6 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 →
  7. Adding back what was available in office 2003 & 2007. Great features missing. For excel Previous & next arrows when you add a link.Thanks

    Adding back what was available in office 2003 & 2007. Great features missing. For excel Previous & next arrows when you add a link.Thanks

    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 →
  8. Allow to expand Evaluate Formula window

    It's not possible increase the size of the formula evaluation window. This is a simple but very useful request to better understand the evaluation of large formulas and array formulas.

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

    We’ll send you updates on this idea

    8 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  9. The function price

    In the function "price", the yield argument is restricted to non-negative numbers. This no longer makes sense, and have rendered the function useless and us as users in troubble since we now have negative yields on the market. Mathematically there should be no problem to allow a negative yield, so fixing the issue would be easy.

    11 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. Add formulas for most common colors. SO =COLOR(E6) would return name of color for cell E6. Then we can write IF based on colors.

    Add formulas for most common colors. SO =COLOR(E6) would return name of color for cell E6. Then we can write IF based on colors.

    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 →
  11. find and replace formulas with a volatile function like INDIRECT

    When you use for example formulas with volatile functions like INDIRECT or OFFSET and you want to use less volatile functions to optimize your excel performance and you want to do find and replace actions then you can't make changes. Let me show it with an example:

    SUMIFS(INDIRECT("Table1[volume]");INDIRECT("Table1[products]");A10)
    you want to remove the INDIRECT in your formulas; so you want to find and replace first: 'INDIRECT("' with "nothing"
    Secondly: '")' so you want to have a remainder that looks like:
    SUMIFS(Table1[volume];Table1[products];A10)
    But that doesn't work, because at the first find and replace action you already get a warning stating: "There's…

    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 →
  12. LASTROW() returns the row number of the last row with data. LASTCOLUMN() returns the column header of the last column with data.

    LASTROW(range[optional, whole sheet if not used]) returns the row number of the last row with data. LASTCOLUMN(range[optional, whole sheet if not used]) returns the column letter of the last column with data. Results can be used in ranges.
    Select cell A1 and press <ctrl> + <shift> + <end>
    =CONCATENATE(LASTCOLUMN(),LASTROW())
    would return the cell reference of the of the bottom right cell that is selected
    =LASTCOLUMN()
    would return the column letter of the last column
    =LASTROW()
    would return the last row number

    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 →
  13. Enable full feature functionality for a shared xls

    Enable full feature functionality for a shared xls. When shared currently limits are placed on ability to copy or move tabs as well as chart and pivot table functions.

    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 →
  14. Support named arguments for optional parameters of custom functions

    For functions with "many" parameters it would be great to be able to pass named arguments in the function calls within spreadsheet formulas, e.g.

    =YesNo(B4, AcceptTF=true)

    rather than

    =YesNo(B4,,,,,,,true)

    To be clear, this is about calling functions, including or especially user-defined functions, from SPREADSHEET formulas.

    This request is NOT about add-in functions calling other add-in functions internally to the add-in code.

    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 →
  15. OR function within the SUMIFS function

    I would love to have OR function within the SUMIFS function so if it meet either of two (or more) criterias it will be true.

    18 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 →
  16. Create a historical record for cell value

    Create a historical record for cell value on daily, weekly, monthly basis automatically without using VB.

    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 →
  17. Alternative Column and Row Range Names

    Similar to creating a range name. Enable users to rename selected columns or rows to unique names.
    E.g. Columns B thru M may be renamed Jan, Feb, Mar ... thru Dec to represent calendar months.

    Rows 2 thru 5 renames as "Sales", "CostOfSales", "GrossProfit" and "GrossProfitRatio" respectively.

    The formula for Gross Profit in cell "B4" would currently be B2 - B3 however with the renamed columns and rows the formula would be "JanSales" - "JanCostOfSales" .

    The formula for Gross Profit Ratio in cell "B5" would currently be B4 / B2 however with the renamed columns and rows the formula…

    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 →
  18. Add a suite of nonparametric statistical formulas and tests

    Add a suite of nonparametric statistical formulas and tests such as the Spearman rank correlation coefficient, nonparametric regressions, semiparametric regression, Tukey Duckworth test, Anderson Darling tests, Wald Wolfwits run test, Kendall’s tau, Kolmogrov Smirnov test, Kuiper’s test etc.

    Likewise add the Durbin Watson runs test and other measures for the stability of timeseries.

    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 →
  19. Add "YYYYMMDD" to text that DateValue() can convert to a date

    A lot of systems keep dates in YYYYMMDD format and when extracting text, it would be nice to wrap that in a DateValue() function to convert to date. Fortunately Date.FromText() in PowerQuery/M Language does this, but =DATEVALUE() should too.

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

    We’ll send you updates on this idea

    6 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Custom Sort Formula

    It will be great and very powerful formula if excel has formula that return result similar to applying Custom Sort. I imagine the syntax to be something like this =CUSTOMSORT(RetunArray,Array1,SortKey,[Array2],SortKey,....)

    Where
    -Return Array is the range user is looking to return the values from
    - Array is range(s) with equal dimensions.
    - Sort Key is Sort Order Ascending and Descending

    OR another Idea is to return all range values again as formula output without specifying the return range.

    5 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