In Powerpoint there is a color picker tool to bring custom colors to the pallete.

Many times we need to do it using PowerPoint to get the RGB combination to be used in Excel.

Could you replicate this color picker into Excel in the same way it exists in PowerPoint?

Portuguese:

Conta-gotas PowerPoint

No Powerpoint existe uma ferramenta para pegar as cores e retornar para a paleta, o conta-gotas.

Vocês podem fazer o mesmo no Excel?

Porque muitas vezes nós precisamos fazer isso usando o PowerPoint para pegar o RGB e colocar no Excel.

That's it: PROCX and CORRESPX in Portuguese versions of Excel to keep the same standard of the other functions.

🇧🇷🇵🇹🇦🇴🇲🇿🇨🇻

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

One of my least favorite messages that Excel provides is:

"Excel found a problem with one or more formula references in this worksheet. Check that the cell references, range names, defined names, and links to other workbooks in your formulas are all correct."

But I can never find the bad references. It's usually buried somewhere very deep, in a chart series formula, or in a name definition, or who knows where else.

If Excel finds a problem, please Excel, tell us where it is.

Create new functions that SUM each column in a dynamic array (SUMCOLS(Ref#)) to produce a row of totals, and SUM each row to produce a column of totals (SUMROWS(Ref#))

Also COUNTCOLS, COUNTROWS, AVERAGECOLS, AVERAGEROWS, but these are less important than SUMCOLS & SUMROWS.

The formula should work like the YEARFRAC function. It should calculate partial months on either end of the dates. So starting 1/15/20 should calculate as 16/31 days or 0.516.. months, and ending at 6/5/20 should calculate as 25/30 day or 0.8333.. months. Currently, I have to use a ridiculously long formula to achieve this.

Make Conditional Formatting Rules Editor window sizable.

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.

Please add support for Tezos in this function.
Tezos is very popular and provides formal verification for Smart-Contracts, on-chain-Governance and it is the first Blockchain which is amendable (without the need of so called "Hardforks"). Ticker symbol is $XTZ.

I want to have a separate excel sheet that can get an updated data from another worksheet and also follows the cell format and style.

I can only get an updated data but it won't follow the cell format and style

If I do a copy/paste, I can get the data with the format and style but it won't update any data if there are changes from the other workbook

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.

Excel To include with time travel feature.This will facilitate to access back the file even if saved for erroneous data which will enable to access file for previous times status like 5min, 10min, 15min etc. back or before. In this way even file saved with heavy mistakes can be retrieved back to previous status and can be utilised for further work without redoing as whole.It is like restore to some known good configuration as in windows registry.

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

For the love of G-d, please, after all these years, make all dialog boxes, especially the GoTo dialog box!

For example, it is IMPOSSIBLE to decipher contents in the GoTo dialog box when using longer Excel file and sheet names.

Most programming languages provide simple ways to define resizable dialog boxes (e.g. Resizable: True, Max Height, Max Width, etc.)
If Microsoft would take 1 extra minute to fix this in Excel, I believe it would save users like me hundreds of minutes per year. That would free me up to use even more Microsoft products!

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.

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.