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. LAMBDA functions and recursion -- calling a SELF function?

    I would like to be able to call a lambda recursively on the grid without the name manager. a SELF function could refer to the function being written. Is that possible? Here's an example for factorial,

    FACTORIAL: LAMBDA(n, IF(n = 0, 1, n * SELF(n - 1)))

    Here's another for matrix exponentiation,
    MPOW:

    LAMBDA( A, p, 
    
    IFS(
    OR(ROWS(A)!=COLUMNS(A), p!=INT(p),p<0),
    NA(),
    p=0,
    MUNIT(ROWS(A)),
    MOD(p,2),
    MMULT(A,SELF(A,p-1)),
    TRUE,
    LET(
    B, SELF(A,p/2),
    MMULT(B,B)
    )
    )
    )
    )

    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 →
  2. reinstall the "change case" button to convert lower case to upper case, upper case to lower case, etc.

    reinstall the "change case" button to convert lower case to upper case, upper case to lower case, etc.

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

    We’ll send you updates on this idea

    3 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  3. Track changes request

    Request is to enhance the track changes

    1- Give us the possibility to track changes on specific sheet.

    Often we have a sheet for data processing and we do not wanted to track changes on that specific sheet.

    2- Track changes only in a specific area of a sheet

    Same as previous but apply to a specific region of a sheet as not the whole sheet need to have changes to be track

    3-Have the history sheet always visible

    To see history we have to go inside track option and enable the track sheet, in intensive review session we would…

    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  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  4. Provide drop down list of columns where filters are applied with column's alphabetical label in brackets.

    This ties in with recommendations of others where they recommend changing the color of the filter button to easily identify filtered columns. Also consider providing drop down option or pop up option to list column names (with alphabetical label of column, such as (A), (B), etc). This will help to easily identify columns where filters are applied. You don't necessarily want to go to each column, but rather want to catch up with the logic / thought process you were busy with. Maybe some short abbreviated info about the values filtered as well.

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

    We’ll send you updates on this idea

    2 comments  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  5. Paste Special - Formulas without Adjusting References

    There should be a Paste Special option to paste formulas without updating relative references.

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

    We’ll send you updates on this idea

    12 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  6. Multiple Letters

    I am a 10 year old boy from INDIA.
    I want to create a new feature in your ‘Microsoft Excel’.

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

    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 →
  8. Allow for more categories in Money in Excel

    The Categories spreadsheet only allows for the addition of 20 categories. My Quicken account, which I am trying to terminate, has over 70 categories in current use. This limits the usefulness of Money in Excel.

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

    We’ll send you updates on this idea

    2 comments  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  9. Stock Data for Singapore Stock Exchange - SGX

    Hope to see data from Singapore Stock Exchange available in the Sock Data.

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

    We’ll send you updates on this idea

    6 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  10. Excel Stock Data Not Updating

    MSO365 Excel stock data is not updating on either of my computers since Sept 15th. Creating new (clean) Excel file makes no difference. Looking at Stock "Card" shows last update 9/15/2020. Seems the Refinitive feed is down? In case this is not the correct forum, apologies, please advise where I should post this issue. Thank You

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  11. Error in the translation of the function description "PROCURAR" (MS Excel Pt-Br)

    On the Brazilian Portuguese version of Microsoft Excel (desktop and online versions), the "PROCURAR" function has a translation error on its description.

    The "PROCURAR" function description text uses the word "LOCALIZAR" instead of the word "PROCURAR", causing an error because "LOCALIZAR" is also another function.

    The description states that "LOCALIZAR" is case sensitive. The "LOCALIZAR" function makes no distinction. The more adequate use on this case would be: "PROCURAR" is case sensitive.

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

    We’ll send you updates on this idea

    1 comment  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  12. Get rid of scientific notation being automatically applied on large numbers

    Excel automatically converts large numbers to scientific notation. This is possibly the most useless and annoying feature ever. Please stop.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  13. About Waterfall Graph in Excel for Microsoft 365

    In the Waterfall Graph in Excel for Microsoft 365 applications, you want to be able to configure the following Horizontal Axis:


    • [Format Axis] - [Text Options] - [Text Box] - [Text direction]

    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  ·  Graphics  ·  Flag idea as inappropriate…  ·  Admin →
  14. lookup/hlookup

    Can you add a new vlookup that allows the lookup variable to lookup against a specified column in a range (versus column 1) and to return the value in relative column (X) where X can be both negative and positive values? Why should the lookup column need to be the left-most? Also, it would be very helpful if the lookup column could be multiple columns. I have oil well data that is specific to the well and the day and is text data.I would like to look up text in a column that matches both the well and the day…

    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 →
  15. Money in Excel: budget template

    Create a budget template to make sure you aren't spending more than a certain amount per month in a budget (e.g. shopping, dining out)

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

    We’ll send you updates on this idea

    2 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  16. Power Query Ranking

    Add the ability to add a custom column that ranks data. Needs to offer the standard different ranking methods: ordinal, standard, modified, dense and fractional as explained here: https://en.wikipedia.org/wiki/Ranking

    Also needs to be able to rank within groups and nested groups.

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  17. Shift Mouse Scroll (Horizontal Scroll)

    Please allow us users to navigate through the excel sheet left and right with Shift + Mouse Scroll.
    Thank you.

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

    We’ll send you updates on this idea

    6 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  18. Outliers Function for Office 365 Excel Desktop App

    I do not understand why Excel - Desktop or Web - does not have a function to identify and flag Outliers (statistical unusually high or low data values) in a column of data? Outliers in data skew any data analysis results whether we are talking about simple data visualization or more advanced regression and other modeling. For example, it could be a spreadsheet function where you enter "=Outlier" in a cell and then select range of data. Or, it could show up in the list of Excel Functions under the Formulas toolbar tab at the top of Excel. Or, it…

    3 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 →
  19. co-authoring track changes history

    I love that using co-authoring you can manage how you share the excel file with your team wherein you can set a user as view only and the others will have the capability to edit. I however extremely need this TRACK CHANGES features 1.) alert notification real-time whenever there is change. This should have an on/off settings so you can turn this on if you want to monitor the progress real-time, 2.) you can check changes history who edit what and you can set the date so that you can select from the start and end date of the project.

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

    We’ll send you updates on this idea

    1 comment  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  20. Include Track Changes in Teams

    As a engineering company we need to be able to track changes to a spreadsheet that is inside a teams tab.

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

    We’ll send you updates on this idea

    0 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base