When a Spill range changes (eg due to the source data changing) it would be nice if any Formatting that is applied to the Spill Formula Cell is also applied to the entire Spill Range.

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.

still have to hit escape to deselect copied items. FUCK_YOU_MICROSOFT.

While editing VBA code within the Developer window, there should be some basic syntax highlighting such as paired parentheses. This would help while coding complex nested conditions.

STILL HAVE TO HIT ESCAPE WHEN COPYING IN EXCEL. FUCK_YOU_MICROSOFT. UNFUCK_YOUR_CRAPWARE

Trying to sort out multiple columns in Excel but received an error!! This is possible on earlier versions of Excel desktop. Need to sort multiple columns at once.

leave the ******* NUMLOCK on.

In wrapped text, need to be able to indent all but the first line

Allow conditional formatting to be applied so that cell widths and heights can be specified.

Excel's own documentation recommends pairing the ISNUMBER and SEARCH functions to accomplish this, but I still have team members asking on a regular basis for a function that returns whether a string is found within a given cell. An out of the box CONTAINS() function would go a long way for usability.

Make The [Search mode] parameter to accept values as below
1,2,3 etc to mean 1st instance, 2nd instance etc from the top
-1,-2,-3 to mean 1st instance , 2nd instance etc from bottom

The search algorithm is already specified in the [Match Mode] parameter so there is no need to duplicate it again in [Search mode]

A very much need function which should allow Excel users to convert number to word.

Example :
1. $ 450.00 it should convert to US Dollars four hundred fifty and zero cents only.
2. SAR 450.00 it should convert to Saudi Riyals four hundred fifty and zero halalas only.

Note : the conversion should be based on regional setting and user should be able define the currency code.

=SpellNumber([cellReference],"CurrencyCode")

Mohammed A Elrify
Mohammed A Elrify Occasional Contributor

4m ago

Suggested to Microsoft EXCEL
By creating the advantage of the proposed Function and formulas recommended
Such as recommended pivot tables and recommended charts

For example, the work of options for the user
For example if he wanted to compile on terms, he would have the formula SUMIFS ready and only a choice
Also like the search that VLOOKUP uses
And so on
I hope the Microsoft community will support and encourage this idea

When selecting the data ranges that have the information you want, enter the $ on the range: XLOOKUP(A5,$D$1:$D$80,$G$1:$G$80)
I'm working 30 years with spreadsheets and I've probably use VLOOKUP without the $ 5 times. People with less skills forget to include the $ and the formulas don't work properly and they have to call me for help.

FIX SLICER RED X ON FILTER
Since upgrading to Office 365, all my slicers now have red X on the filter button, regardless of any filtering. In 2016, the X turned red only when the slicer was filtered, otherwise it was greyed out. Now, in 365, ALL slicers ALWAYS have a red x. No way of scanning quickly to see which slicers are filtered. They all LOOK like they are filtered, whether they are or not.

LEAVE THE FUCKING_NUMLOCK ON. FUCK_YOU_MICROSOFT.

Make linking options available for Map Chart Types.
I would like to be able to link the title of my maps to cells within my workbook to make it quicker and easier to update them but it is currently not available for Maps.
See the first note on the following link:
https://support.office.com/en-us/article/Link-a-chart-title-label-or-text-box-to-a-worksheet-cell-efc8173a-2a8a-423b-b4e2-b10c62fca6f5

Can you make it so that features are less useful and more difficult to access with future version of excel?