Tips

How to insert a drop down in Excel immediately only 60s

How to insert a drop down in excel faster and easier in only a few minutes that is effective immediately ? 

If you feel it is difficult to insert a drop down in excel? Wait a minute… Let’s read this one to find a useful solution. It is take about 60s.

(You can watch video before using)https://support.microsoft.com/en-us/office/video-create-and-manage-drop-down-lists-28db87b6-725f-49d7-9b29-ab4bc56cefc2

How to insert a drop down in excel?

I am going to share some ways to with a drop-down list you can limit your data moreover, it also saves time and increases efficiency.

S1: Open Excel and choose a blank workbook.

25A96598 C88A 45B9 AEFC 2CDB094F3077
(How to insert a drop down in excel?)

S2: Choose a column to highlight drop-down menu

FBCA1063 2386 42F7 A0E4 6F08917DC6C7

S3: See on the top of the screen, you click Data which is between Formulas and Review and put it in the toolbar.

7B3694F7 AD7F 4ACB 91BF 4C0797486AB9

 

S4: click the Data validation which is between Remove Duplicates and Consolidate.

S5: When you choose a setting, a table will be opened, let’s find a menu which has Allow word, next choose List between Decimal and Date from the table.

B7523C16 0D12 4BD3 BCC4 0B338616DCFE

S6: Highlight the box that you want to select the options and then choose OK. It is done.

S7:Insert a drop down list is done. By contract, if you wait just a few minutes but it is not run for you immediately, please choose a box marked Source first and next highlight this with colour.

Only some simple steps you can insert a drop down conveniently and fastly. Above that, with only 7 steps you can use it for almost any situation and at any time only just a minute

How to use a drop-down in an Excel Table conveniently?

We can open on the Table topic, because if you add a data validation drop-down to the first cell in a Table, Excel will extend the drop-down to each new record. Let’s take some time to see at this bit of magic:

Create a quick Table by selecting F2:G4. So, choose Ctrl + T, press the My Table has Headers, and then click OK.

Select D4, the box will occur the drop-down and continue creating earlier, and click Ctrl + C.

Select G3, the first cell in that column and press Ctrl + v to copy the drop-down to that cell.

Select a part from the drop-down and click a Tab to insert a new record into the Table. Tab to G4 and you’ll see that the Table copies the drop-down automatically (Figure E). If you’re using Excel to serve for work, right-click the Table, click Insert from the resulting submenu, and next select Table Rows Above. The Excel will copy the drop-down as the desktop version does.

You could have established the Data Validation list using the border so that you did it easier. However, you should know how to insert a drop down in Excel because that is a benefit and a skill which is used oftenly in work.

Remove a Drop-down List

Only some simple steps, you can delete a drop down list easily.

S1: highlight the cells with a drop down list.

66339D5F FA5F 4FA1 8E6E 0947AB8313EB

S2: on the top, in the Data Tool group you choose Data Validation.

966B5B0E C59C 4D08 BC3A F45C42832BCA

S3: choose clear all in the left corner.

2A7CEB35 8500 4B18 8F3A 6C1CBAD3D0AF

(This video is detail instruction about remove a drop down list). https://support.microsoft.com/en-us/office/remove-a-drop-down-list-01b38366-f5bb-43f8-9df9-8a707b9502f0

Conclusion, to save time and save my mind and money I have some advice for you: take notes on this one and do it frequently. I recommend you choose a format, such as a fill color, so it’s easy to find.
Now, adding a drop down in Excel any longer is difficult if you know this way.

 

 

Related Posts

Spice of  Lifetime : An Australian Dating Site   Using   Simple Tools  introducing  Local  Singles

Spice of Lifetime : An Australian Dating Site Using Simple Tools introducing Local Singles

Lo information: Spice of lifestyle in realtà un sito di annunci incontri Sesto San Giovanni australiano che mantiene situazioni veloce. The purpose dovrebbe migliorare genuine interazioni tra quante…

Babel Review  –  Genau was tun   Wir verstehen  Über irgendetwas davon?

Babel Review – Genau was tun Wir verstehen Über irgendetwas davon?

Contents1 Wie kann Babel Arbeiten? 2 Registrierung – ist-es nicht so schwer ? 3 Wie wäre es mit Design und Benutzerfreundlichkeit? 4 Sicherheit & amp; Sicherheit 5 Preise…

Three explanations you desire Him to inquire about, ‘Why are You Still Single?’

Three explanations you desire Him to inquire about, ‘Why are You Still Single?’

What makes you will still unmarried? You asked yourself this countless times, but it’s a great deal different if you are expected by that appealing brand new man you…

Intuition Spezialist  Joan Marie Whelan  Hat Ihre psychischen Fähigkeiten   einfach zu helfen  Kunden   Entwickeln   Größer  Beziehungen  Durch Erkunden

Intuition Spezialist Joan Marie Whelan Hat Ihre psychischen Fähigkeiten einfach zu helfen Kunden Entwickeln Größer Beziehungen Durch Erkunden

Kurz Anpassung: Joan Marie Whelan ist ein intuitiver – jemand mit natürlichem inhärentem} präzisem Einsicht â € ”seit der Frau ersten Gedanken. Intuition oft bedeutet psychisch Fähigkeit, aber…

Genau warum Viele Leute Entscheiden Sie sich für Bleiben Sie Single

Genau warum Viele Leute Entscheiden Sie sich für Bleiben Sie Single

Contents1 Love is great when it is pure and real.2 Staying one is someone option.3 Für Männer: 4 Für Frauen: 5 Ich bin sicher es gibt viele verschiedene…

Co-genitorialità e  really love:  specialist tips to  help  your  blended   family   prosperare

Co-genitorialità e really love: specialist tips to help your blended family prosperare

Contents1 L’armonia inizia dentro di te 2 Perché noi fare questo ancora una volta? 3 Come fare dimenticare persistente negatività 4 Tutti noi in aggiunta ex aiuta a…

Leave a Reply

Your email address will not be published. Required fields are marked *