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

    43 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 →
  2. Money in Excel should allow manual entry of transactions.

    Money in Excel should allow manual entry of older transactions so that the whole year's transactions can be contained in 1 sheet. Right now Money can only import about 90 days of transactions and January and February are missing from my transaction log.

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

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

    10 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. Paste Special - Formulas without Adjusting References

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

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

    We’ll send you updates on this idea

    9 comments  ·  Editing  ·  Flag idea as inappropriate…  ·  Admin →
  6. 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 →
  7. 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

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

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

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

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

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

    13 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 →
  15. update stock data type and STOCKHISTORY function with the ability to pull data from the Egyptian Stock Market

    To be able to pull data from the Egyptian stock market using the Stock Data type and the STOCKHISTORY function

    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  ·  Data Import  ·  Flag idea as inappropriate…  ·  Admin →
  16. Stock Data for Singapore Stock Exchange - SGX

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

    9 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 →
  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)

    5 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. Stop automatically changing text and number fields to dates

    Excel needs to provide a setting to allow users to prevent Excel from changing number and text data fields to "Date" data format when importing data. THIS IS INCREDIBLY AGGRAVATING. Once Excel incorrectly changes something in my .csv file to a date, I can no longer recover the number or text that it was supposed to be, and I must re-export the file from the database. It is absolutely unacceptable for excel to change my data, especially without giving a warning or providing a preferences setting that I can disable. Yet another example of how excel is a piece of…

    16 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 →
  19. XLOOKUP to return an array of ranges

    Currently XLOOKUP can return an array of return values, given an array of search values, OR a range corresponding to a single search value. Like other functions, it does not return an array of ranges but, rather, truncates the calculation.

    This may have been acceptable in the past when the expectation was to copy formulas across to return values that logically form an array. As dynamic arrays receive increasing use, the expectation will change and the failure of a range to spill will be far more problematic.

    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 →
  20. sheet tabs

    currently the amount of characters allowed per tab is 31 maximium. THIS IS NOT ENOUGH. please make an option to extend the amount to at least 100. If you do this you are good. If you don't you are bad. It is that simple.

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

Feedback and Knowledge Base