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

Immediately colorcode cell references upon selection
When we edit a cell by doubleclicking it or hitting F2, we get a very helpful colorcoding of the cells it references. Why can't we just get this colorcoding immediately upon selecting the cell? That way we could easily click or arrowkey 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 
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 
How to avoid auto adding the stupid @ operator without looking up the context?
When I need the columns that can be mod3, 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 Row6: 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 
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 
Make spill optional
Make spill optional. Totally broken ten years worth of formulas (and the experience gained in creating more complex formulas)
4 votes 
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, 20132019, 20072010 or all versions.2 votes 
excel里如数值为86.44度，调用函数TRUNC（）时，计算公式为=TRUNC((F8TRUNC(F8))*100)，取整后数值应该是44,但是这函数取整后却等于43，是什么原因？
excel里如数值为86.44度，调用函数TRUNC（）时，计算公式为=TRUNC((86.44TRUNC(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.44TRUNC(86.44))本应该等于44的，但实际却等于43.9999999999，请问这是什么原因导致的，希望尽快得到处理意见，十分感谢。
补充说明：这个问题不管是在office2007版里还是2010版、2016版里都出现这种情况
1 vote 
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 
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 YYYYYY(+/)1. For Example. Fiscal year starting from April the formula FiscalYear(1362020,4) should return "3/202021" or something like this.
2 votes 
[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 SmartContracts, onchainGovernance and it is the first Blockchain which is amendable (without the need of so called "Hardforks"). Ticker symbol is $XTZ.50 votes 
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 
Excel Sum Function is truncating trailing zero's while pasting Sum from one cell to another
Steps to reproduce the bug:
 Create Sum of 2 or more cells with numeric values  Ex. A4 = Sum(Sheet1!A2+Sheet2!A3)
 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.
 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.
 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 
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 longwinded...to clarify
=COLUMN(AB1) returns 28
=COLUMNA(AB1) returns AB10 votes 
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 
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 8This would help in parsing filenames that include paths, for example.
8 votes 
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 
Google Sheets QUERY() equivalent?
I would welcome a straightforward, SQLlike 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 builtin filtering (querying) of data within Excel tables, not passing SQL statements to connected SQL data server/connection.
6 votes 
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 
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 
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
 Don't see your idea?