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. Please create a FILTERJSON (FILTROJSON) worksheet function

    Hi. How about creating a FILTERJSON function? It would make our life easier allowing us to get JSON data with less workarounds.

    Oi. Que tal criarem uma função de planilha FILTROJSON? Tornaria a nossa vida mais fácil nos permitindo obter dados em formato JSON com menos soluções alternativas.

    🇺🇸 English: FILTERXML --> FILTERJSON
    🇨🇿 Czech: FILTERXML --> FILTERJSON
    🇩🇰 Danish: FILTRERXML --> FILTRERJSON
    🇳🇱 Dutch: XML.FILTEREN --> JSON.FILTEREN
    🇫🇮 Finnish: SUODATA.XML --> SUODATA.JSON
    🇫🇷 French: FILTRE.XML --> FILTRE.JSON
    🇩🇪 German: XMLFILTERN --> JSONFILTERN
    🇬🇷 Greek: FILTERXML --> FILTERJSON
    🇭🇺 Hungarian: XMLSZŰRÉS --> JSONSZŰRÉS
    🇮🇹 Italian: FILTRO.XML --> FILTRO.JSON
    🇳🇴 Norwegian:…

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

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

    44 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 →
  4. Let add setting to switch gridlines on/off

    Now we can do that for current worksheet only. These days it's quite desirable to have an option to keep greedlines off on permanent basis for each new workbook. That could be done using template or by changing/adding registry key https://www.quora.com/What-are-some-ways-of-removing-gridlines-in-Excel-2007.
    That will be much more suitable if we have such option in Advanced section of Options.

    12 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 →
  5. Budgeting with Money in Excel

    Can you add a budgeting function to the template Money in Excel? Tracking my transactions is great, but being able to assess if they align with a monthly budget would be ideal.

    12 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 →
  6. Bring Power Pivot closer to Power BI Desktop Functionality

    Development for Power Pivot for Excel seems to have stopped around 2016. TREATAS got added as a DAX function that works, but it never got added to Intellisense, and that was nearly 3 years ago.

    Today, the two measure editors (still no idea why there are different ones) are a very VERY poor substitute for the fantastic DAX editor in Power BI Desktop. It is a real pain to properly tab and indent in the Excel Measure editor(s).

    In the last year there have been about a dozen new DAX functions and several updated functions per https://docs.microsoft.com/en-us/dax/new-dax-functions but NONE of…

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

    We’ll send you updates on this idea

    4 comments  ·  PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
  7. Money in Excel

    Support MFA for accounts in Money in Excel

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

    We’ll send you updates on this idea

    4 comments  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  8. Paste Special - Formulas without Adjusting References

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

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

    We’ll send you updates on this idea

    10 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  9. The user name should be removed from Office apps title bar for security reasons

    Say you work while traveling on a train. Someone wants to know who you are for whatever reasons. If your name is in the title bar of an application or the user name on the logon screen, giving away your credentials that easily... User credentials should not be disclosed in title bar of office applications and there is really NO sensible reason to show them on the title bar. Fancy true, safe nope. Remove it.

    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  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  10. Money in Excel should show due dates, statement balance, and minimum owed for debts

    Money in Excel should show due dates, statement balance, and minimum owed for debts (e.g. credit cards and loans). Somehow it could track if debts are on "autopay" or paid already for the next due date (or allow the user to specify these).

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

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

    17 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 →
  13. Separate Excel windows shall not share an UNDO buffer.

    Sorry Microsoft, but you really blew it in the 2016 update. Separate Excel windows used to be separate Excel windows. Now they share the same buffers for Undo, copy/paste, and highlighting. This is really limiting when working comparatively on two spreadsheets.

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

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

    We’ll send you updates on this idea

    3 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

  15. User usage tracking

    Would be great to have a way to monitor the usage of an Excel File. working in Finance, many of the reports we produce can be used or not used. having a mechanism for a file author to get usage statistics would be super helpful. for example each time the report is being opened it pings the server and let the author know through a report sent weekly or daily (customizable).

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

    We’ll send you updates on this idea

    2 comments  ·  Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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.

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

    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 →
  18. Create Array that joins two arrays

    Create a function called ArrayJoin() or ArrayConcat(), this would join two or more arrays together to make one array. This could be used on spreadsheet directly or embedded in inputs of other functions eg to dynamically organise inputs for MMULT().

    16 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 →
  19. Want to sign in to Salesforce through Salesforce Connector with Excel client

    The article below describes how to change the registry key in order to use Salesforce Connector with Excel.
    But we would like you to improve the behavior for us to sign in to Salesforce through Salesforce Connector with Excel instead of changing registry. Hopefully I would like you to improve the Excel client behavior itself.
    Title: Salesforce Connector not working with Excel
    URL: https://support.microsoft.com/en-us/office/-652418aa-7873-4257-90c3-7bce1061b410

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

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

Feedback and Knowledge Base