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. Immediately color-code cell references upon selection

    When we edit a cell by double-clicking it or hitting F2, we get a very helpful color-coding of the cells it references. Why can't we just get this color-coding immediately upon selecting the cell? That way we could easily click or arrow-key through several cells and quickly see what they're referencing, rather than having to squint and find "Column G.... Row 11....., Column K .... Row 15....", etc.

    See attached GIF animations demonstrating the current behavior versus what I'm proposing.

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

    Hi, Lookup formula is not working well when we just want to search in an small 2 column table like the image attached it is working wrongly and if we don't attention to it can make big mistakes.
    I know we can use vlookup formula in 2column tables but if the table wasn't in 2 column we can't do any thing with lookup and neither Hlookup.
    because some of my tables are on 2 rows and I can't use this functions because it will give wrong answers.

    1 vote
    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 →
  3. How to avoid auto adding the stupid @ operator without looking up the context?

    When I need the columns that can be mod-3, I've got my formula automatically added with a stupid '@' without look for the context,
    Can you explain this? I don't know where to get help or ask question, it seems the community is a rubbish.
    My formula is:

    =MIN(IF(MOD(COLUMN(G6:R6)-COLUMN(I6),3)=0,G6:R6))
    

    The values in Row-6: A FAIL -9.46% 6.07% -9.46% 6.07% 0.43% 0.89% 0.62% 0.02% 0.10% 0.05% -0.19% 0.14% -0.02% -9.46% 6.07% -0.12%
    it is infinitely long, maybe 10000B cells and even longer, so do not suggest a stupid solution of selecting each of the cells satisfied.

    1 vote
    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 →
  4. Anchor period during formula entry.

    Upon upgrading to Excel version l 365 16.0.11328, I lost the ability to anchor formula ranges with the period key instead of the colon. Prior to this version, hitting the period would insert a colon so that I could complete a cell range. Could this functionality be added back to the "Transition Navigation Keys" option?

    Having started with Lotus 123 back in the 1980's, I still use "Transition Navigation Keys." Using the period during formula entry has become second nature and is embedded in my muscle memory. Please kindly consider this for your more "seasoned" Excel users.

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

    We’ll send you updates on this idea

    18 comments  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  5. Make spill optional

    Make spill optional. Totally broken ten years worth of formulas (and the experience gained in creating more complex formulas)

    4 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 →
  6. Show if formulas are compatible backwards and to which version

    I hesitate using some of the newer formulas as I don't know what versions are compatible.
    Could you mark formusla as 365 only, 2013-2019, 2007-2010 or all versions.

    2 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 →
  7. excel里如数值为86.44度,调用函数TRUNC()时,计算公式为=TRUNC((F8-TRUNC(F8))*100),取整后数值应该是44,但是这函数取整后却等于43,是什么原因?

    excel里如数值为86.44度,调用函数TRUNC()时,计算公式为=TRUNC((86.44-TRUNC(86.44))*100),取整后数值应该是44,但是这函数取整后却等于43,是什么原因?而且我们还做了实验,发现如果直接对数值取整没有问题,调用函数计算取整遇到如下这些数值时就会出现减一的情况(02、05、07、08、10、11、13、16、19、21、22、24、27、30、32、33、35、36、38、41、44、46、47、49、52、55、57、58、60等数值)。通过对上述公式计算的数值进行认真分析后发现(86.44-TRUNC(86.44))本应该等于44的,但实际却等于43.9999999999,请问这是什么原因导致的,希望尽快得到处理意见,十分感谢。

    补充说明:这个问题不管是在office2007版里还是2010版、2016版里都出现这种情况

    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 →
  8. Please implement COUNTUNIQUE

    Google Sheets has a =COUNTUNIQUE formula. This isn't supported in Excel and it's very ugly to try to recreate using combinations of existing formulas. Could we please have the =COUNTUNIQUE formula supported in Excel?

    2 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 →
  9. A formula for fiscal year started from month

    A formula to calculate Fiscal year based upon starting month. The result can be Fiscal month serial number and year in the format YYYY-YY(+/-)1. For Example. Fiscal year starting from April the formula FiscalYear(13-6-2020,4) should return "3/2020-21" or something like this.

    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 →
  10. [Excel Currency Conversion Function] add Tezos XTZ (Cryptocurrency)

    Please add support for Tezos in this function.
    Tezos is very popular and provides formal verification for Smart-Contracts, on-chain-Governance and it is the first Blockchain which is amendable (without the need of so called "Hardforks"). Ticker symbol is $XTZ.

    50 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 →
  11. Be able to add a "Full Name" field with a specific button.

    Being able to highlight the first and last name column and click "Add Full Name"

    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 →
  12. Excel Sum Function is truncating trailing zero's while pasting Sum from one cell to another

    Steps to reproduce the bug:


    1. Create Sum of 2 or more cells with numeric values - Ex. A4 = Sum(Sheet1!A2+Sheet2!A3)

    2. Copy the formula and paste it to other cells, so that it can take values from respective cells and create summation. Ex. Pasting Sum in B4, C4, D4...B12, C12, B15 etc.

    3. While pasting, its working correctly for B4(i.e. Sheet1!B2+Sheet2!B3), also for B15(i.e. Sheet1!B13+Sheet2!B14) where there the cell numbers are not ending with 0s.

    4. Its not working correctly for B12(it should be Sheet1!B10+Sheet2!B11) instead it is pasted as Sheet1!B1+Sheet2!B11. This is wrong. This is happening especially when we sum across sheets
    1 vote
    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 →
  13. COLUMNA() returns the letter(s) where as COLUMN() returns a number

    column() is great, as usually we want the column NUMBER

    BUT when you want the column LETTER(s), something like

    COLUMNA()

    could return it.

    I know you can use
    =SUBSTITUTE(ADDRESS(1,COLUMN(A1),4),"1","")
    but it's pretty long-winded...

    to clarify
    =COLUMN(AB1) returns 28
    =COLUMNA(AB1) returns AB

    10 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 →
  14. Deprecate VLOOKUP & HLOOKUP (make them Compatibility functions)

    VLOOKUP and HLOOKUP use a lengthy, unintuitive syntax and have been superseded by XLOOKUP. They should be used only when a spreadsheet might be used on a version of Excel that does not support XLOOKUP. To help promote the best practice of using XLOOKUP, please deprecate VLOOKUP and HLOOKUP by making them Compatibility functions.

    In cases where VLOOKUP and HLOOKUP cannot be converted to an equivalent XLOOKUP expression (e.g. dynamic 3rd argument), they can still be converted to an equivalent expression using INDEX and XMATCH, so users are not missing out on any functionality from not using VLOOKUP and HLOOKUP.

    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. Reverse FIND and SEARCH functions to search from the right

    Add functionality using the start_num as negative to search from the end of the string.

    FIND("123","123123",-1) would return 4
    FIND("M","Miriam McGovern",-1) would return 8

    This would help in parsing filenames that include paths, for example.

    8 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 →
  16. translation funtion

    It would be a great time saver if there was a translation function that worked like a reference function. Especially if you work internationally and have to enter 2 languages in e.g. a list to make it easier to understand, this function would be very practical, because you would have to enter it once and then you could transfer it to the other cells.
    For example: column A is German and column B should contain the corresponding English translations. Instead of having to translate everything manually, a function would be simpler here, which would transfer the following information: If A1…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  17. Google Sheets QUERY() equivalent?

    I would welcome a straightforward, SQL-like function to build complex queries, similar to Google Sheets QUERY(). For me, building complex filters with multiple criteria in Excel is frustratingly difficult. This is especially true when attempting to emulate SQL's WHERE, IN, LIKE, GROUP BY, and HAVING.

    For the record, I'm referring to built-in filtering (querying) of data within Excel tables, not passing SQL statements to connected SQL data server/connection.

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  18. You need a single command or function that gives just the name of the file.

    You need a single command or function that gives just the name of the file.

    1 vote
    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 →
  19. Fix =Z1 when Z1 = "" should return "" not 0, No work around w/ Dynamic Arrays

    There has been a longstanding issue as follows. When referencing a cell (e.g. formula in cell A1 is "=Z1") and Z1 is blank/"" then the value returned in A1 is 0 (not blank/"" as expected). The work around for this has always been to change the formula to =Z1&"".

    The problem is now with Dynamic arrays this is not possible. Create a table with 3 columns, first 2 columns are a text values and 3rd column is a date or numeric. The write a dynamic array function =FILTER(Table1,Column2<>"Y"). The spilled array will return a 0 in column 1 or 2…

    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  ·  Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
  20. Include unique,countunique and countuniqueifs functions

    Please include unique,countunique and countuniqueifs function in excel. remove duplicates is also good. But it is not useful if data is changing.

    1 vote
    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