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.

Make Conditional Formatting Rules Editor window sizable.

I create Conditional Formatting on whole columns. I should be able to insert, delete, blank within my range without Conditional Formatting breaking up into formatted sections which eventually causes some rows not to format correctly. I am constantly correcting the Conditional Formatting which is very time-consuming! It is such a handy tool but very frustrating tool to work with.

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.

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.

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

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.

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.

• Open a new Excel worksheet




• Format the entire worksheet with Accounting Format, 0 Decimal places, Symbol: None




• Enter 100 into cell A1




• In cell A2 enter the formula =A1*5/12




• Note that the format has now changed to show 2 decimal places

This only seems to occur with the Accounting Format. Using the Number Format this change won't occur. However the Accounting Format is a convenient format for someone like me in the financial professional that likes their worksheets to show "-" instead of "0"

I always change my number format to accounting and remove the decimals or number with thousand separator and no decimals. While this task is easy it's annoying to do in every single workbook. It would be super helpful if there was an option somewhere that would let me change my default number format. I know there is an option to automatically add a decimal, this would be pretty much the same thing except instead of a decimal, it would add a thousand separator.

In a given workbook, I frequently use several different colors over and over again for both fill and text. Wouldn't it be great to have those few colors constantly in the ribbon rather than simply the last? Even having just one extra color (last used and second to last used) would be a significant improvement since it is most often that I go back and forth between two colors, whether for cell or text color. If not that, then perhaps a hover/drop down feature that goes to the recent colors when you point at the last.

The plus sign is meant to amplify the positive value. So far, I have only found this formatting for negative numbers.

Named conditional formatting rules - If you could name your rules they would be easier to identify. Also, it would be nice if you could right click a cell and have a choice to add it to a named conditional formatting rule. Excel would need to be intelligent enough to be able to add the cell or group of cells to the rule correctly.

A KEYBOARD SHORTCUT TO INSERT A ROW BENEATH THE SELECTED ROW OR TO THE RIGHT OF THE SELECTED COLUMN

Most of my pivot tables end up having wrap text applied to the header rows to avoid them being too wide. This would be a useful option to set in the default pivot table layout or the table element formatting.

When I type a date, I would like it to take the format I type in, instead of auto changing to a format that I do not want, and having to go through all the hoops to change it back. If I type 4/15/19, that is what I want, if I type April 15, 2019, that is what I want, yet both default to auto correct to 15-APR-2019