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.

In the last week, whenever I close down a new Excel file without saving it, a new dialog box appears asking "Save changes to this file?". Whereas previously I could use keyboard shortcuts to immediately close down a file (Ctrl-F4, N), this no longer works. Instead, the new box interprets the "N" keypress as something to be entered into the "File Name" text field.

Please add Power BI Dataflows as a data source so that I can import data from a Dataflow into the local spreadsheet/data model.

https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use

Surprisingly Customizations In Keyboard Shortcuts Are Allowed For Excel In Mac And Not Windows Even When Both Excel And Windows Are Microsoft Trademark.
Please Add Feature To Allow Keyboard Customizations To Excel As In Work For Aiding Ease Of Access To Various Commands As Per User Preferences.
Thanks.

I selected multiple sheets and I tried to replace the "=" character with "eq=" in all the selected worksheets at one time. Since the 8/2019 version 1902 update, this find replace didn't work. Only some of the "=" characters were replaced.

The new Dynamic Arrays make possible to automatically fill down formulas. Tables can also fill down formulas. Microsoft Excel Team could make both features be compatible so we could convert Dynamic Arrays into Tables making them expand and shrink according to the main formula.

very simple,VLOOKUPs are case insensitive, VLOOKUPS should be case sensitive. One use case are Salesforce reports. They produce 15 character Ids that require case sensitivity functionality in order lookup against.

This is a major productivity killer for power users such as finance teams, and current UX does not help exit this state efficiently.

STILL HAVE TO HIT ESCAPE WHEN COPYING IN EXCEL. FUCKYOUMICROSOFT. UNFUCKYOURCRAPWARE

I'm entering dates going out to 2032, and when I enter dates like 10/1/32, Excel is changing the date to 1932. Excel should be defaulting to 2032 like it does for dates in the 2020's.

When the user uses the remote desk of the laptop(the system of the laptop is windows 10 1903 rdp) to connect to another computer, the excel document with Macros cannot open or save(the version of the office365 is latest).

it is not a secret that the VBA protection password is very weak, it is very frustrating that I can't defend properly a sensitive code in the one of the biggest and popular software (Excel) in the world.
improving VBA protection is a game changer for lots of people.

It's taken me 10 years to realise this but I've never "unchecked" My Table has headers, it's ALWAYS the other way round, forgetting to remember to tick it because Excel hasn't recognised the header row.

Let's default the tick to always on ?

Give us the possibility to change the background color, of the active cell, to any color suites the user.

Hi We need to open a new instance of Excel by deflaut each time we open an excel file. The following solution are not suitable.

you can start a new Excel instance (process) by doing the following:
run “Excel /x” (without quotes)
or the DisableMergeInstance regkey because it works only when you open excel first and then open the file. It does not works double clicking on an excel file. Don't give one of those solution (https://excelgorilla.com/excel/general/open-multiple-instances-excel/) as we need it to be by default as Excel 2010 behavior.

column() is great, as usually we want the column NUMBER

BUT when you want the column LETTER(s), something like

COLUMNA()

could return it.

I know you can use
=SUBSTITUTE(ADDRESS(1,COLUMN(A1),4),"1","")
but it's pretty long-winded...

to clarify
=COLUMN(AB1) returns 28
=COLUMNA(AB1) returns AB

Existe una errata en la web https://support.office.com/es-es/article/insertar-o-eliminar-una-hoja-de-c%C3%A1lculo-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2#ID0EAACAAA=Office_2010 en el segundo punto donde dice "pestaña Inicio" ya que en la versión de Microsoft Office 2010 los elementos principales de la cinta de opciones se llaman FICHAS y no pestañas. El equipo de contenidos de aprendizaje de Office en la web debe revisar esta incidencia o errata y modificarla en la web del enlace que se ha indicado en el inicio de este comentario.

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

How about keeping the formula intact, returning a #REF result and NOT editing the formula with a #REF comment. This stupid idea prevents one from following the formula back and evaluating what the error is, or what cell it's referencing. Who ever thought of doing this should have some training! If one receives a spreadsheet developed by someone else, they may not know how the formulas work/reference, but leaving the formula intact gives the opportunity to understand what the result should be. CHANGING the formula should NEVER be an automatic option by the software!!!!!