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.

Stop ignoring valid comments that you don't appreciate
It's been known for years that the way Excel deals with circular references is very poor. Under certain circumstances, you pop up a warning that one or more circular references exist, but none can be found and fixed. I'd be happy to get a list of fields that contain the error. If the system rechecks and finds another circular reference, I could then dispose of them quickly and keep trying to save until I succeed.
1 vote 
dynamic references
Need to include calculated (and dynamic) references everywhere where appropriate:
DataValidation lists
COntrol properties
COnditional format influencing regions
etc ...1 vote 
vlookup case sensitive
very simple,VLOOKUPs are case insensitive, VLOOKUPS should be case sensitive. One use case are Salesforce reports. They produce 15 character Ids that require case sensitivity functionality in order lookup against.
1 vote 
Add INDIRECT function as the seventh argument to XLOOKUP
When using XLOOKUP to find information on another worksheet using the worksheet TAB as a dynamicselection via the Indirectfunction, the need for this argument becomes clear. For example; XLOOKUP(@INDIRECT("'"&$J$13&"'!$C5"),INDIRECT("'"&$J$13&"'!C5:H30"). the 'TabReference' is the INDIRECT("'"&$J$13&"'!) part of the function.
1 vote 
TRIM within IFS throws #VALUE error on strings longer than 255 chars
The use of the TRIM function within an IFS function throws a #VALUE error, if the string within TRIM is longer than 255 characters:
e.g.:
=IFS(TRUE;REPT("x";256))
if you use 255 instead of 256, the function works fine. If you use REPT alone, there's no problem.
Tested on German Excel version 1910 Build 12130.20390, monthly channel.1 vote 
SUMIFS and similar work with MONTH() and YEAR()
SUMIFS(values,MONTH(daterange),MM,YEAR(daterange),YYYY)
instead of:
SUMIFS(values,daterange,">="&A1,daterange,"<="&EOMONTH(A1,0)),
which seems clunky and complicated.1 vote 
the function of blinking the cell, and setting the color (under a certain condition IF)
In the MICROSOFT EXCEL program  the function of blinking the
cell, and setting the color (under a certain condition IF)1 vote 
DATEDIF formula and syntax helper in formula bar
I use the DATEDIF formula regularly for business tasks, including calculating due dates etc. I don't understand why this formula isn't more prominently offered to those who wish to use it.
1 vote 
1 vote

A command that searches for file locations (like for the location of a PDF) and displays the file location
I have a mail merge tool that will grab a file and attach it to an email, using the file's location. But it'd be nice for there to be a command that will search a drive and FIND that location, so I only have to save a file once
1 vote 
Hi
Hi like i have entered few values in a formula & out of that one value i want to change the colour of that value so that i know this coloured values signifies me where i got that from. i can select that vales but didnt allow me to change the colour of that value.
thanks1 vote 
Copy data from one table to another with a formula.
I am organising ammunition from a list of my ammunition into different storehouses. They must comply with many regulations and not all ammo can be stored together. I want to be able to type in a storehouse number in an end column. When this number is typed in i want the data from that row of the table to be copied into another table that represents the storehouse contents. This way i can quickly move ammo across between he storehouses without having to copy and paste each time. I experimented with an =if function, but i couldn't find a way…
1 vote 
How About an downend and rightend function
I have to use a OFFSET fuction for a dinamic array and I was thinking is a good idea have the posibility to use a new function for detect the last column/row in an area like in VBA. Something like:
=OFFSET(A1,1,0,1,COUNTA(RIGHTEND(A1,1)))where RIGHTEND be like
=RIGHTEND(cell_reference,0 or 1 can be right or left)Same case for DOWNEND
= DOWNEND(cell_reference, 0 or 1 for up or down)It can be vey practical.
Thanks!
3 votes 
Ability to use cell colors in formulas
I had a 30x100 grid with 2 colors and I wanted to count how many cells there were of each color in each column. Filtering did not work as I expected it to and it would have been so cool if there was just a formula for it, though I can see how it'd be difficult to implement.
1 vote 
1 vote

I believe that a comprehensive conversion function for "Decimal Feet" to "Feet and Inches with Fractional inches" would be very welcome.
I believe that a comprehensive conversion function for "Decimal Feet" to "Feet and Inches with Fractional inches" would be very welcome. Input would be decimal feet, output would be feet, apostrophe (standard abbreviation for "feet"), integer part of feet, and fractional remainder reduced to nearest 1/2, 1/4, 1/8, 1/16, 1/32, or 1/64.
Example: 10.70833 would convert to 10' 8 1/2"1 vote 
named range fix  excel 2016
Named Range fix required due to reoccurrence of previous issues in Excel 2016
This relates to named ranges being lost when duplicate names used at scope workbook and worksheet used between linked workbooks.
http://eileenslounge.com/viewtopic.php?f=27&t=3604&hilit=disappear%E2%80%A6
I have examples of files where the order that workbooks are opened affects whether named ranges appear/disappear or not and hence whether formulas work or return errors.
3 votes 
Kelly Criterion
I think it would be easy and cool if Excel had a Kelly Criterion function. You would only need two inputs from the user (potential profit as a percentage of wager and percent chance of winning). This would allow Excel to return the percentage of bankroll to risk.
1 vote 
Add more control to cell array, specifically the make the numbers say 1 in A1 a variable that can be adjusted
So I'm on cell A4 of Sheet2. I tried to manipulate the variable say "4" in a formula containing "Sheet1!$A$4" so that it when I drag the cell down it would print after every 3rd row which is to say the next printed item would be on Sheet2, cell A7 BUT I want to print the contents of "Sheet1!$A$5" it only prints "Sheet1!$A$7" as if the number "4" is linked between sheets 1 & 2 (I expected it to only be sheet1
Full code: =IF(MOD(ROW()1;3)=0;TEXT(OFFSET(Today!$A$9;(ROW(Today!$A4)*1)4;0);"dd/mm/yyyy");"")
Image 1 (capture): Expected outcome when you drag down
Image 2 (capture 2): Obtained outcome
1 vote 
Negative coefficient for square : erreur in the excel formula
Hi,
There is a problem in one excel formula. When you use a formula for a second order equation with a negative coefficient for the square term, excel applies the square to the cell value and the negative coefficient. The consequence is that the result is always positive and so result is wrong.
Ex.
=A1^2, if A1=1,2,3 the result is 1,4,9 and not 1, 4, 9. Using parenthesis does not correct the bug =(A1)^2 = 1, 4, 9. it is not the case if you do = 0A1^2 (results, 1, 4,9). Normally if you want include the negative coefficient in…1 vote
 Don't see your idea?