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.

Currently in Excel Online, when I format the colour of text in a single cell it changes the colour of all text in that cell. I would like the ability to change the colour of highlighted text only so I can have multiple colours of text in one cell.

After looking on multiple forums, I can see this has been an issue for many users for a number of years.

Why only release to 15 percent of users?! Let the world have XLOOKUP and XMATCH now()!

stop automatically removing leading zeros from cells. they should stay be default as they are NEEDED for the sheet.

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

Please allow to enter Hex color codes when choosing colors for cell fills, borders, fonts, charts, etc...
RGB and HSV are triple the work!

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

LEAVE THE **** NUMLOCK ON

Provide an option in dark mode in which the cell color defaults to black ( ie "no fill" results in a black background) and the text color defaults to white or light gray

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.

Ctrl + Z should work per workbook, not for all of Excel. I commonly have two workbooks open and work in them simultaneously, but when I use the undo shortcut it backs out through all of excel, instead of just the active workbook.

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.

A formula to convert text to a formula; which is essentially the exact opposite of the FORMULATEXT function, or in a way, what the INDIRECT function does with cell references but with formulas.

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]

Unhiding multiple sheets is a painful task, you have to go one by one. There should be an option to unhide multiple sheets at once.

Please bring in this feature.

Thanks.

Visual Basic for Applications is still version 7.1 from 2012. It's high time that power user portion of the application received updates to the interface, IntelliSense, and features. That portion of the program needs to be aligned with the current features now available within the Microsoft Suite. It also needs a facelift to the Userforms palette. I suggest starting with Excel, where VBA is most widely used, then PowerPoint, Word, Outlook.

Don't go destroying developer's programs, just add interoperability, functions, and facelift.

When using dynamic arrays, it would be nice to have the option of a floating totals row at the bottom of the dynamic spill range.