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

    12 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 →
  3. Property in Power Query "Enable background refresh" - default to unchecked

    When creating a new query in Power Query, by default the property "Enable background refresh" is enabled. Please make this property be unchecked by default. The cases where I need this property disabled outgrow at large the cases where the background refresh can be turned on.

    8 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 →
  4. Fusionar Células

    Uma outra função que o Excel deveria ter é o fusionar células (não é mesclar). Se tiver algum valor duplicado, mas em alguma coluna ter algum valor diferente, uma função poderia unir as duas e mantendo apenas valores únicos.

    Ex: A1 - japão A2 japão

      B1  em branco   B2  é bonito  

    a função fusionar deveria ficar assim:

    C1 japão C2 é bonito

    poderia ter uma função = fusion (a1:a2)

    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  ·  Performance  ·  Flag idea as inappropriate…  ·  Admin →
  5. Ultimate OST to PST Converter

    You may a 100% satisfied with the software working functionality then move beforehand for full model license to maintain the get better or transformed emails. It moreover cut up oversize PST document as much as 5GB and assist MS Outlook versions from 90 seven to 2016. Export OST document to PST is performs works very fast in all state of affairs. The software program is designed with many forms of advanced functions. It is available at sincerely $39. For more information associated with this product,

    please go with this net site: https://www.inspiredatacare.com/convert-ost-to-pst.html

    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 →
  6. shortcut to remove all filters

    easy shortcut to remove all the filters on tables in a worksheet.

    I work in finance and always filtering and unfiltering multiple columns, it would be fantastic and save so much time to have this shortcut.

    thank you
    Samantha Casey

    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  ·  Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
  7. Money in Excel Capital One

    Without being able to get my Capital One data in Money in Excel I can only get a small fraction of my finances. Either work with a data aggregator that plays nice with Capital One (not Plaid) or allow me to import my data manually.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →

    Hello,

    Thank you for your valuable feedback. Currently Money in Excel doesn’t support Capitol One accounts. We’ve shared your feedback to the apt team for review.

    Thank you for using Money in Excel!

    Regards,

    Vipin Nair
    The Microsoft Team

  8. Save font style and size for new documents

    Once a user has created a Font and Size they want, Excel will have a button to save that font and size for further new documents.

    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  ·  Formatting  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add "Header" Argument to FILTER and UNIQUE Dynamic Array Functions

    I'm proposing that header argument be added to the FILTER and UNIQUE Dynamic Array Functions just like we have seen in the STOCKHISTORY function

    11 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 →
  10. 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…

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

    We’ll send you updates on this idea

    2 comments  ·  Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
  11. Change the Excel formula bar to the one from Power BI Desktop

    Change the formula bar for advanced users as well as for beginners. better reading of functions makes work easier for everyone.
    Indent the code, view the line (s) where there is an error, quickly see the syntax of a function and a bar that adapts depending on the length of the code that is entered.

    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 →
  12. Unhide Tabs in One go

    Hi Microsoft Excel can you please introduce a feature wherein if more than one tab is hidden it allows us to select more than one tab so we can unhide al required tabs in one go.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. 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.

    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  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  14. To apply a function on Chart Title...

    When we visualize the data, we need the Chart Title to be dynamized. İt is impossibe to

    apply Simple Excel Functions like Textjoin, Concat, Concatenate, etc. on Chart Title Cell.

    To keep Chart Title interactive, we implement the necessary Functions combination in

    another cell and make link from Chart Title Cell to it.

    From time loss point of view, Direct implementation of Functions Combination on Chart

    Title Cell would be very practical for Excel Users and appreciated.

    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 →
  15. Add Corkscrew function for dynamic arrays

    Corkscrew accounting is fundamental to Financial Modeling. It is where opening balances are carried over from closing balance of prior periods..

    =OpeningBalance(FirstPeriodBalance, PriorBalances)

    Where FirstPeriodBalance is the first period's opening balance and PriorBalances is an array of closing balances for each period.

    The cell containing this function will return FirstPeriodBalance. The SPILL range will contain the n-1 closing balance array value.

    https://corporatefinanceinstitute.com/resources/excel/study/corkscrew-calculation/

    20 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 →
  16. Text to Columns Wizard - Select multiple columns when changing Column data format

    Text to Columns Wizard - Select multiple columns when changing Column data format

    On using the Text to Columns functionality, you can change the Column data format (step 3 of 3). You can only select one column at a time and set the format. It would be great to select multiple columns and change the column format to one specific format in one go.

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

    10 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 →
  18. Add functionality to Money in Excel to allow data to be downloaded from a Bank Account back further than 30-60 days

    Add functionality to Money in Excel to allow data to be downloaded from a Bank Account back further than 30-60 days; for at least two years. Or for the time period to be selected by the user.

    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  ·  Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
  19. Implement / expose object orientation

    Would be great to be able to manipulate values returned by Excel formulas as objects with properties.

    E.g. if I create select an array of cells (=A1:C20), I'd like to be able to manipulate that array as follows
    =A1:C20().count -counts the number of items in the array
    =A1:C20().sort(index1,desc) -sorts first index of array in descending order
    =A1:C20().filter(index2,filterclause) -filters array on index2 of array on filterclause
    =A1:C20().filter(index2,filterclause)[:2] -filters array on index2 of array on filterclause, and returns/slice-returns last two columns of array
    =A1:C20()[1] -returns/slice-returns first column of array

    And it would be even better to be able…

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

    19 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