Adicionar mais opções, ou deixar o usuário inserir suas próprias opções na formatação especial de célula (Imagem), como placa de carros, documentos com textos, ou até mesmo colocar seu próprio formato ali

Add more options, or let the user enter their own options in the special cell formatting (Image), such as car board, documents with text, or even put their own format there

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.

Um sugestão seria ter um botão na "Caixa de Diálogo"
Medidas no Power Pivot (Excel) para "identar" as funções DAX digitadas, como mostra o anexo.

Excel automatically converts large numbers to scientific notation. This is possibly the most useless and annoying feature ever. Please stop.

Excel should make a feature to allow the user to distribute columns evenly

Conditional formatting is helpful, but it often breaks due to the ranges it applies to being split. So end up with 1000's of little rules create a nightmare.

IT IS ABOUT TIME TO ENABLE THE CONDITIONAL FORMATTING FEATURES SUCH AS FONT TYPE + FONT SIZE.

Thanks,
Michael (Micky) Avidan
MS Excel MVP (2009-2022)
ISRAEL

I use excel to take notes in class and when I copy and paste paragraphs into a cell and want it to look like a paragraph, I have to select the range of cells I want to merge, then merge them,. Then I have to "wrap text", then I have to left align, then I have to top align. Make 1 button that does it all. Stay classy San Diego

Please make it possible to see formatting of individual words in formula bar (bold, italic, font color, superscript, subscript etc). Currently formatting is visible in the cell but not the formula bar.

Add formatting functions to enable formula-driven text output. Such functions could include BOLD(), ITALICS(), UNDERLINE(), and STRIKETHRU(). This is similar to some other user suggestions like functions for superscript and subscript, and it would be especially helpful for concatenated text.

To be able to lock cells or groups of cells without having to protect the whole sheet or workbook.

The only way that I know of to see a cell's format category (e.g., General, Number, Date, etc.) is to right-click and hit Format. I would like if there was an option in the status bar called "Cell Format."

Ich möchte Outlook Converter Software eine kommerzielle Lösung wie TGZ vorschlagen. Dieses Tool importiert TGZ-Elemente wie E-Mails, Kontakte, Journale, Notizen usw. Diese App importiert TGZ in Outlook und verschiedene Dateiformate wie PST, EML, MSG, EMLX, vCard, vCal usw.

Weiterlesen: http://www.zimbra-converter.com/info/export-zimbra-tgz-to-pst.html

Many utilities have zeros in front of the meter or company references(00794411), when paying invoices or bills, that have to be included to pay them and when corresponding with the utility companies, as it's not valid to them if the zeros aren't there. So there should be an option in the number formatting section for reference numbers including zeros in front, where it doesn't take away zeros in front of the reference, but lets you put as many zeros in front of it as you like.

to convert dig sized excel(say 4 lakh line) to 5000 line in each excal file keeping first line in commmon for all record

I have set the header text to wrap and adjusted the height on the pivot table header rows, but every time I refresh or select to filter data, it resizes the header row despite having selected "Preserve Cell Formatting on Refresh". Perhaps have an option "Preserve Heading Row Formatting on Refresh".