Everyone is using Data Validation in Excel for simple or complex projects. However if you decide to clear your data validation rules there is No direct command on the ribbon to do that: So you have to go to the Data Tab >> Open the data Validation dialog box >> Click on Clear All >> Close the dialog Box.
My suggestion is to integrate this functionality with the Data Validation button in the ribbon (as explained in the attached Graphic) which will enable the user with a click to either clear Data Validation from a selected range or from the entire worksheet (as in case of Conditional Formatting)
I designed the proposed look of the Data Validation button.

Corrigir descrição da opção "Remover Duplicatas" no Microsoft Excel

No caminho Dados>Ferramentas de Dados temos a opção "Remover Duplicatas".

"Duplicatas" no Comércio significa: "título de crédito nominativo pelo qual o comprador fica obrigado a pagar, em determinada data, a quantia correspondente à fatura de mercadoria vendida a prazo."

Ao deixarmos o mouse na opção já aparece "Duplicatas" que está errado por fazer confusão ao comercio, e no texto em seu "balão" aparece como "Duplicadas", onde o seu único significado é "que ou o que se duplicou; que foi copiado por uso de artefato próprio ou manuscrito (diz-se de documento ou escrito).

O mesmo erro ocorre ao selecionarmos a opção na janela de opção de colunas à remover onde na mesma linha consta inicialmente como "Duplicadas" (correto) e no final como "Duplicatas" (errado)

Segue anexos para melhor entendimento.

Hello

When I start typing text into any empty cell in Excel (without first hitting F2) I want to be taken into full-on "Edit Mode".

This would mean that when I hit the Back Arrow [probably because I have made a mistake in the text that I am trying to enter] I would NOT have my text to be submitted into my spreadsheet so that Excel can put into the CELL on the left of where I am.

No other applications behave like Excel. I find it very, VERY annoying.
Yes, I know I could remember to press F2 first in order to edit a cell, but when entering text into an empty cell it's very hard to remember to do that.

I've lost count of the number of times have made this mistake when adding text into Excel. Probably well over 1000!

It's such a simple thing. And it has annoyed me for about 15 years.

J

PS Please note that it is important that the OTHER arrow keys (particularly Down Arrow) must still submit what the user is editing. Otherwise editing a long column of numbers gets to be very slow.

In Microsoft Office, certain actions lead to various boxes popping up (do these have a name? "Annoying boxes"?). Throughout Office there is a Paste Options box after you paste copied material; Excel also has a Quick Analysis box when you select appropriate data. These boxes frequently over-lie the thing you are trying to do next, so can be very annoying. In most cases, you can dismiss them by pressing the Esc key, but the Paste Options Annoying Box doesn't go in Excel (it does in Word, but not in PowerPoint).

I don't want to disable them, as they are sometimes useful, but can't we just be consistent here?

This important bug has been known for YEARS and I've reported it several times on the FEEDBACK APP. It's a pain in the **** becasue I use drop-down lists with Names in everything.
If you use data validation with dropdown lists and the source is a named range, if you check the "ignore if empty" then the data validation won't work, i.e. the user can enter anything they want. If you uncheck the "ignore if empty" it will always display the annoying green corner even if an empty cell is part of the selection list.
Either way it's an abnormal behavior.