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.

Pull Current Stock Prices and Historical Data Into Excel
Now that our ability to use Yahoo! Finance's API to pull in stock information via the WEBSERVICE() function and import historical information is officially dead (thanks Verizon!), the only viable option currently is to use Google sheets to pull in stock information.
It would be awesome if Excel could import data from MSN Money so us users can continue to use spreadsheets to monitor our portfolios.
649 votesProgress! As of this morning, we’ve begun enabling the first iteration of Excel’s new data types for a percentage of Office Insiders, including the ability to pull and refresh live stock quotes (and other financial data) straight in to Excel! We’ll be increasing the percentage of Insiders with access to the feature over the coming days and weeks, so if you don’t see it right away please hang in there!*
We acknowledge that right now this is only half of the suggestion (pull current stock prices), but historical data is in our sights and we’re planning to add this and many other improvements to stock and financial data. Your feedback thus far has been immensely valuable in helping us plan and design this work, and we look forward to your continued suggestions for how we can improve to better meet your needs
Again, we genuinely appreciate your involvement as we…

Formular Editor
Large formulas become very confusing. It would be nice if there is a formula editor that inserts, coloring and evaluates the formulas like Visual Studio and that can also be provided with comments and other hints. These formulas must then be displayed in the editor in exactly the same way.
40 votes 
Allowing MultiSelect Functionality Through an Option List (Data Validation List)
As a Web developer and data management professional, my job relies on many functions that help me to get the work done faster. I was asked to create an excel sheet to import data faster into our website through a massive update. I got stuck at a task where one of the attributes had multiple options. I didn't know how to do so without having to create a list of all possible combinations which passed 40k possible combinations. I was losing my head until I searched online. I found a Macro Code that helped me select multiple options for a…
4 votes 
VBA abilty to refresh a Power Query Group (a.k.a. folder of queries) using a single script line
We need a VBA solution to allow a module/macro to refresh a Power Query Group by name. This solution would allow a single line of VBA code to refrence the Power Quer Group (folder) Name and refresh all queries within that folder.
It could be something as clean as:
ThisWorkbook.Connections.Group("My Folder of Queries").Refresh
25 votes 
Add new Split formula
I want to add new formula called "split"
The formula will split cells or text upon a delimiter like "split" in vba
formula syntax:
=split(delimiter,cell or text)5 votes 
Improve the way Excel handles dates in a regular spreadsheet formulas
It is just RIDICULOUS that Excel still can't handle dates before
1900. If Excel was an also run to Lotus 123 or some other ancient spreadsheet, I could understand them sticking with that, but it isn't.
There are tens of millions of people who would like to do calculations on dates before 1900 historians, astronomers, archeologists, scientists, and just plain genealogists  professional or amateur.
From https://www.techonthenet.com/excel/formulas/date.php
The DATE function returns a serial date value. A serial date is how Excel stores dates internally and it represents the number of days since January 1, 1900.
If the year is greater…2 votes 
User defined 'functions' in a worksheet with input and output cells
Create a new type of 'worksheet' which acts in the same way as a VBA function, but instead of writing code you use the worksheet itself to create the logic.
A designated set of cells would be used to specify inputs, which the rest of the sheet could refer to as normal using formulae.
Then one cell would be designated as the 'output' cell.
Finally a function name is assigned to the worksheet which can be called from anywhere else within the workbook
e.g. =MySheetFunction("Input1", 234.56)
In the background, Excel calculates what the output cell would equal given these two…
1 vote 
Please fix the M3 bug!
It needs to be easier to reference cell M3. As it stands, the 3 is automatically superscripted.
1 vote 
There should be numeric data type restrictions
I am working on some custom functions in VBA and the range of values for data types are absurd.
Double data types can run to hundreds of digits even though they couldn't be seen on the screen.
1 vote 
Graphical wizard to assist with VLOOKUP and similar FOrmulas
When configuring VLOOKUP in Excel, there should be a graphical wizard which will walk a user thru setting up the VLOOKUP.
1 vote 
Evaluate Formula Box Apply color coding
Evaluate Formula Box Apply color coding for most recent calculation and upcoming calculation, instead of underline and italic!
1 vote 
Numbers converting in words function
Pls add the function of converting numbers in words, doing it through VB insert option is quit hectic problem.
1 vote 
Error in Textjoin formula
Textjoin sometimes gives empty results:
==============================
Textjoin formula is found in "Annual_leaves" Sheet
=TEXTJOIN("+",TRUE,IF((Report!$B$10:$B$200=$A2)*(Report!$C$10:$AD$200="A"),Report!$C$8:$AD$8,""),"")
examples of the results:
"16" or"16+21+23" or "02+11+24+27"
My formula usage:
==============
It brings annual leaves dates from sheet "Report" for every employee
The problem:
==========
>>>When you edit a cell in another sheet rather than "Report",textjoin will show blank results
Steps to produce the problem:
======================
1Edit any cell in sheet "Attendance"
2then go to sheet "Annual_leaves" ,you will find textjoin show empty results
see the attachment2 votes 
1 vote

Why does Excel STILL LACK equivalents for some Google Sheets functions?
Specifically FILTER, SORT and UNIQUE.
I spend too much time in Excel usertouser support forums, yet one of the most frequently asked questions is how to find conditional matches. Google Sheet's FILTER function makes these tasks almost elementary. Excel equivalents require INDEX(..,MATCH(1,(condition1)*(condition2)*...,0)) and array formula entry.
When are certain portions of Excel functionality FINALLY going to progress from the 1980s?
1 vote 
Formula bug in Excel (?)
Hello,
I've probably found a formula bug. I've attached a replicate scenario (pdf document) and also the Excel sheet to reproduce the bug.
Sorry if there are some mistakes, English is not my native language.
Regards,
Sophie2 votes 
Inserting Formula
When you insert a FORMULA from the FORMULA ribbon or when you select INSERT FUNCTION in the formula bar, you get a helpful graphic that guides you in building the formula with the option of selecting HELP ON THIS FUNCTION for more detailed help.
When you are working on a formula, if you click the formula name (e.g. SUM in the example attached), it opens up a HELP window. It would be more useful if it opened up the FORMULA build window instead (which also has the ability to click a link for further help).
This would allow users more…
1 vote 
STANDARD ERROR OF THE MEAN
Please add a formula for Standard Error of the Mean as well as an option to use this statistic for error bars. This is a standard statistic used in data visualization. I can't believe it hasn't been added at least 10 years ago.
1 vote 
Add chmistry data type. at the minimum it should recognize elements.
Add chemistry data type. At the minimum it should recognize the elements and properties.
1 vote 
Button to Flatten formulas in visible cells
Need a button that replaces the need to unfilter an entire sheet full of large amounts of data in order to copy and paste values in a column that were formulas. The large amount of data results in major slowness when unfiltering or sorting. To avoid the slowness, I will unfilter the sheet then copy the column and paste values to flatten the formulas. The unfilter part of the process can take forever and often crashes excel. There is a need for a button that after selecting visible cells (column or selected cells), can flatten the formulas to values. This…
1 vote
 Don't see your idea?