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.

Make the Evaluate Formula dialog box resizable
The evaluate formula box is unusable with large and/or CSE formulas. Please just make it resizeable. Thank you.
45 votes 
Formula for checking validation compliance
It'd be great to have a formula (no vba) to check that the value in a cell complies with that cell's validation rules.
Since validation can be bypassed with things like pastetovalue, it'd be useful to have a formulaic way to check on entries after they're entered.
This is also useful for validation with conditional lists. (For example when the validation list switches depending on the value of another cell.) What can happen here is that the validation list can change but there's no way to alert the user that the value in the cell, while compliant with the previous…
1 vote 
when calculating the amount of days difference between specific dates, give the user an option to decide what it shows if it is a negative i
Using Today and another date, in my case a fee renewal date, to get the number of days between the dates, if it is a negative, allow the user the option of what to show instead of #NUM!, in my case I would use either Current or Renew not yet due.
My spreadsheet, using the If then function, shows Current if less then 30 days but if ve shows #NUM!. It also shows Arrears  30 days, arrears 60 days arrears 90 days and if a year past then it is Lapsed. This all works great except for when they…
1 vote 
Evaluate Formula Readability
There needs to be a huge update regarding the Evaluate Formula.
I'm sure those using this feature are not trying to see simple calculations done.For me, I might create a report that has a cell calculate multiple IFs within IFs that have embedded functions.
with this in mind, it would be a huge advantage to the user if the Evaluate Formula has the following upgrades:
1. able to expand the window.
the window currently is too small and only allows to view simple calculations.2. color code what is being calculated.
with everything being the same color it is…2 votes 
Ordinal Position Function
A function which returns ordinal position of one specific element in an array as a number. Alternative name occurrence.
So for example if the array was like this
A1 Dave
A2 Fred
A3 Jim
A4 DaveThen Ordinal(A1:A4,A1) would return 1 eg the 1st Occurence of Dave
Ordinal(A1:A4,A2) would return 1 eg the 1st Occurrence of Fred
Ordinal(A1:A4,A3) would return 1 eg the 1st Occurence of Jim
Ordinal(A1:A4,A4) would return 2 eg the 2nd Occurrence of DaveFunction Format something like
Ordinal(lookup array, lookup cell, optional reverse)
Lookup array could be vertical with a width of 1 column or horizontal…2 votes 
Allow the use Structured References in Textbox
Enable Excel to link Text Boxes (Textboxes) to table values using Structured Table References.
Currently, linking the textbox to a defined name that contains a structured table reference results in a "Reference isn't valid" message.Attempting to link the textbox directly to a structured reference results in an error stating "This formula is missing a range reference or a defined name"
To reproduce this behavior:
Set up RangeName: PC01_ID
RangeName Formula: =Table_Progress_Chart_01[[#Totals],[Slice 2]]Try linking a text box to: =PC01_ID
1 vote 
Add cell reference to Data Validation Messages (Input Message, Error Alert)
Please add the ability to use cell references or formulas in the Data Validation Messages (Input Message, Error Alert).
This would make possible to use variable contents.Thanks,
Fernando Fernandes32 votes 
Perform Calculations (Sum, Count, If, etc.) Based on Cell Color
Allow users to create formulas and that perform specified operations with data/values from only cells with a chosen background color, from a range of cells.
For example, in a range of 10 cells (A1:A10), only 3 cells have been colored yellow (either by the user or by a specified condition). A user can create a formula, such as =SUM or =COUNT or =AVERAGE, that will only use the cells colored yellow to determine the result. All other cells in the range, regardless of background color, will be excluded from the formula's result.
Alternatively, the same functionality can be achieved based…
19 votes 
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.
2 votes 
Create iszero function
Please create ISZERO and ISONE function.
All the spreadsheets I've ever used use flags (1's and 0's), which are comprised of complex formulas that return 1's and 0's depending on the cells referenced by the formula.
For example, in the leftmost cell of a row, I can have a formula that reads: =IF(C25>=$C$5,1,0). I then I copy this formula horizontally across 40 adjacent cells horizotnal, and depending the values of adjacent reference cells (C25, D25, E25), I will have 1's and 0's throughout the row in which I create the formula.
I then proceed to create more complex periodic formulas…
1 vote 
Please answer
I post yesterday. but i want to know more(why this gave wrong answer) .Please check attached excel file (in sheets("result") column "H"> why this formula give different result ( it is not array)
1 vote 
sum by color
add Sum by Color function in excel so that we can selectively add the cells of same color or background color
3 votes 
Increase the source character count in Data Validation from 256 to possibly 512 or 1024, that way nested formulas can be utilized.
Increase the source character count in Data Validation from 256 to possibly 512 or 1024, that way nested formulas can be utilized for bigger worksheets that data from a lot of different tables is used.
2 votes 
Formula that lets you replicate the formatting of a reference cell
Excel should create a formula that would allow the user to specify a reference cell whose format you want to copy.
For example, I should be able to create a formula in cell A1 of Sheet 1 that refers to A1 of Sheet 2 such that Cell A1 of Sheet 1 will replicate the formatting of A1 on Sheet 2 [e.g. =Formatcopy(Sheet2!A1) or =Formatcopy(Sheet2!A1)*Shee2!A1] .
Alternatively, if you have a formula with multiple reference cells, it would be helpful to be able to specify a single reference cell whose formatting you would like to use. For example, if I have…
2 votes 
hide columns
I would like to see an Option when you right click on a cell formula an option is added that allows you to hide all columns that aren't referenced by the formula.
For example if the cell A6 contains the formula
"=IF(AH6<1,"",MAX(0,IF(W6>0,I6+E6+D6+F6J6),0))"
right clicking "Hide Unused Columns" would hide all columns except
A,AH,W,I,E,D,F,J.Once this had been done the option would change to "Unhide All Columns".
2 votes 
Allow summing a column of numbers by just entering the "=" sign then highlight the column (or row) of data to sum it.
Allow summing a column of numbers by just entering the "=" sign then highlight the column (or row) of data to sum it. Presently when you do that you the the #VALUE! response. You must either manually enter the formula or use the Greek summation icon.
2 votes 
Rounding Error in Excel
You have a serious rounding error issue in excel that I confirmed with your help desk they could recreate.
Go into excel and type 3 in cell B2
In B3 type the formula =B2+0.1
Copy the formula down to cell B36
Cell B32 should read 0 exactly but does not 1.53E15
I had this rounding error turn up when creating a more complex spreadsheet and could not understand why there is an error
if you format the cells to 30 decimal places you will see that when 0.1 is added to 1.1 the answer returned is 0.999999999999998000000000000000
not 1.00000000000000000000000000003 votes 
Make it easier to find errors in a large worksett with multiple tabs
I get an error message telling me there are formula errors in my worksheet. My worksheet is very large with many tabs and hundreds of formulas. If the program is able to identify an error in the worksheet, it should be able to tell me where the error is located.
2 votes 
Add Automatic Calculation By User Entered Interval
Add an option for "Interval" or "Timed" calculation to the Calculation Options and to the File>Options>Formulas dialog.
Enable user to specify a minimum of time (in seconds (and fractions of a second e.g. 2.251234) that should pass before a workbook (or worksheet) calculation is performed.
Worksheets with longer calculation times, that receive data from external sources may
2 votes 
Formula Colors
There is a red opening parenthesis and a red closing parenthesis.
Can we do some stronger highlighting instead of text color?
Maybe space out the parenthesis?
Maybe give a background color?
Maybe invert the entire formula bar to a black color, so the formula colors stand out more?
Maybe have collapsible formulas?
Maybe have a live preview?
5 votes
 Don't see your idea?