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.

Now we can do that for current worksheet only. These days it's quite desirable to have an option to keep greedlines off on permanent basis for each new workbook. That could be done using template or by changing/adding registry key https://www.quora.com/What-are-some-ways-of-removing-gridlines-in-Excel-2007.
That will be much more suitable if we have such option in Advanced section of Options.

currently the amount of characters allowed per tab is 31 maximium. THIS IS NOT ENOUGH. please make an option to extend the amount to at least 100. If you do this you are good. If you don't you are bad. It is that simple.

I use an array formula (e.g. RANDARRAY) to insert some numbers. The size of this array may vary, as the array formula is based on cells with values, which may vary.
In the spilled array I want to highlight some values using conditional formatting. It would be useful, if the conditional formatting could be based on the size of the array, so that the area the conditional formatting applies to shrinks and grows with the size of the array.

Can the window on the Conditional Formatting Rules Manager be able to be adjusted so I can see more of my rules?

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.

There should be a drop-down choice in formats the provide a formatting especially for phone numbers that can cope with +61 without trying to treat it as an equation and leaves the leading zero as is. Also you can click and dial from there if you have a phone function on you PC like cisco jabber.

formatting should assume your number is in the same country as your timezone. It should offer some choice of format i.e. +61 456 654 456 vs 0456 654 456.

As it sounds: If the column is empty, the automatic sizing when you double-click should make it the default width instead of doing nothing.

Can't write 7560000100022061 in cell.

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.

Given the ubiquitous use of Excel among Finance professionals, it is a pain to type in CUSIPs (9 digit unique identifiers of securities), as if the security has an "E" as the 2nd or 3rd last character (which is more often than you think), it automatically converts to scientific notation. If Excel could add a special "CUSIP" format where this didn't happen, that'd be a game changer for an entire industry

So you can maintain formulas in cells you maybe don't want shown (onto power point for example) without having to colour the background and text the same colour.

Copying from excel to Outlook (or any other app) should keep the content and format, borders, alignment of the cells. It takes so much time to adjust everything after pasting data into an Outlook e-mail, for example...

know excel was to be scientific, but bet it is used in 'financial' spreadsheets more than inventors could have envisioned.
'A' on adding machine, means 12 equals 12.00 saves 3 keys

                                                12.1               12.10  saves 1 key

                                                1210               12.10 saves 1 key

                                                12.10               12.10 saves 0 keys

Large Numbers are used in for documentation and inventory when using excel. The scientific notation feature causes confusion and frustration. Can you put an option to disable the scientific notation feature in the Options menu, for those who use excel for inventory and documentation.

We often export from Power BI into Excel, and the URLs are not automatically clickable hyperlinks. Please make this data automatically hyperlinks.

Can you please give the users freedom to change icon colors while using conditional formatting. This is cruel to not give format icon set option