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.

Subtotal in the Outline Group in Data Tab
When selecting the subtotal in the Outline group in the Data tab, you are presented with a dialogue to select the Column where at each change you select the function (Sum, Average, etc.…). I wish that Excel will sort the column after the selection automatically.
1 vote 
Trend function between an array with multiple data points
This would be a new function that would allow you to calculate a fitted trend value to data, trending between the closest two data points instead of the entire dataset.
For example, let's say you have data for 5 year increments between 2000 and 2020, so data for 2000, 2005, 2010, 2015, and 2020.
Currently, using a trend line will just fit a line of best fit across all data points, but this can produce values that deviate a lot and don't fit well.
Instead, a formula that linearly interpolates between the two closest values would provide a better approximation…
2 votes 
LOGEST
Please suppress the overspill output from the LOGEST function. Prior to the latest Excel version, the basic logest function would give the growth rate in a single cell. Now the calculation spills over some calulaton values into the adjacent cell and cannot be deleted or hidden. This makes it a problem when including the LOGEST growth rates in a table, as there is superfluous (for display purposes) information in the adjacent cell.
1 vote 
Match Function Reverse Order
Add ability for Match function to base match on a reverse order lookup.
e.g. Match(A1,A1:A100,0,REVERSEORDER)
which should start the match from row 100 to row 1.2 votes 
Create WORKTIME as a new function
I would like to have a formula that returns the date and time that is the indicated number of working hours before or after a date and time (the starting date and time). This would be similar to the WORKDAY function, but would also account for business hours.
2 votes 
1. Ability to set a pop up function to a specific file prior to turning off a laptop
 Ability to set a pop up function to a specific file prior to turning off a laptop,
 When you turn your laptop back on that specific file opens up so you can continue working.
1 vote 
make vlookup see towards left also
vlookup function only matches data in the right side, i want to use the reverse order also
1 vote 
Named spilled arrays
When defining named ranges using Ctrl+Shift+F3, add a "Include spilled array" checkbox to the label selection dialog box.
This would simply reference the first cell next to the label with the spill operand.
2 votes 
Introduce #N/F as a new ERROR.TYPE besides #/A
With the arrival of XLOOKUP() there is a real need for a new error.type that can distinguish a criteria not matched or not found from a non available value #N/A.
I suggest that a new #N/F i.e. a not found error be added and ERROR.TYPE(#N/F) would give ... 9, i.e. just after error.type 8 (#GETTING_DATA).
Besides ISNA() we could have also ISNF()
One must also think of what would return ISERR() and ISERROR() and what IFERROR() would do.
2 votes 
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:
able to expand the window.
the window currently is too small and only allows to view simple calculations.color code what is being calculated.
with everything being the same color it is a bit…
4 votes 
Excel Data Column Relation
Create an Excel function that gives a data relationship score between an input column of data and the corresponding result column of data. The function will output between 1 and 1 with 1 to be a complete relationship, 0 no relationship and 1 a complete inverse relationship. This function would be available in both Excel & Power Query. This is like fuzzy matching feature in Power Query. Fuzzy matching compares two cells this new Fuzzy data relationship compares two columns.
1 vote 
Broaden some of Excel's output forms
Excel has some things it won't do, at least one of which it kind of blames on what YOU are trying to do, because it has one chosen method of output after your action and that output can't be figured out by it for the input.
Say you have A1 to B3:
1...a
.....b
3...cand you select all cells but for A2 however you wish to do it. Now try to copy to the clipboard. Won't do it. Reason?
"This action won't work on multiple selections."
In truth, Excel wishes to give an output that eliminated blanks. So select…
1 vote 
Ribbon Spelling Mistake  FunctionsRecentlyUsedtInsertGallery
Logged to UserVoice Dec 5 2016  Spelling Mistake in idMso
1 vote 
create
I have created Dynamic lookup function with 4 inputs
1) Range
2) Lookup Value
3) Lookup Range
4) Column From lookup range
In vlookup function the value you are matching should be 1st column in range.
In dynamic function it can be any column in the range to look to left need to give column no 1,2 etc and to look to right column no 1,2 etc2 votes 
Highlight cells affacted by formula
When a cell contains a formula pressing F2 highlights the cells referred to in the formula. It would be nice to see those highlights by just moving to the cell i.e. not having to press F2. Numbers does that and its bloody handy.
2 votes 
The new Dynamic Array Formulas should include a condition for Sum or count the results of an array
Excel engine should include an extra condtion (optional) concerning the formulas that return arrays , which allow to add a sum or count or average to the end of the results of the formula
2 votes 
Filter and Sortby need to be coordinated
Dynamic array functions Filter and Sortby should be coordinated.
So I want to filter and sort a list of values from a table. For example, I want the list of values Table1[ID] filtered where Table1[Date] <> "" sorted by Table1[Customer].
If you want to return all referenced values you can do SORT(FILTER(Table1[ID]:[ColZ],Table1[Date]<>""),2,1) assuming column 2 is [Customer] but if you only want Table1[ID] returned this won't work.
To use SORTBY and FILTER you have to put SORTBY inside FILTER (not consistent with SORT(FILTER ) and then for every FILTER condition you have to use the entire SORTBY reference. So this…
2 votes 
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 
upgrade vlookup() (and hlookup()) so that you can provide the column header text instead of column number. i.e. database search  dget()
Excel has the DGET() function that allows a database search. You give the name of the column it should find the match in, and the name of the column where the value should be returned to. If vlookup can be upgraded to be similar, then it will be much more powerful:
Example:
newVlookup(value, data range, match column, return column, match type)newVlookup(Sheet1!A1,Sheet2!A:E,"Order Number", "Order Description", false)
7 votes
 Don't see your idea?