HOW TO MAKE A DROP DOWN LIST IN EXCEL WITH PICTURES HOW TO
HOW TO MAKE A DROP DOWN LIST IN EXCEL WITH PICTURES MANUAL

HOW TO MAKE A DROP DOWN LIST IN EXCEL WITH PICTURES HOW TO

YouвЂ™ve just learned how to create drop-down lists. To make changes to an existing rule, click on Edit RuleвЂ¦ at the bottom left. Manage rules will show you the conditional formatting rules youвЂ™ve set up. You can always modify your rules by going to Manage RulesвЂ¦ canвЂ™t join: red background + white font.will join: green background + white font.We want the values for вЂwill joinвЂ™В to appear with green background and white font color:Д¬lose the dialog and repeat the step for each of the possible values: To choose the actual color style, go to Custom FormatвЂ¦ To enable conditional formatting with different color schemes, select the first cell and choose New Rule вЂ¦ from the menu.Д¬hoose the classic style and set up a rule of the following kind:ДЇormat only cells that contain a cell value equal to вЂwill joinвЂ™ Step 2: Enable conditional formattingДЇor this step, you need to have the drop-down list ready and the cells modified accordingly (see image). Repeat the same steps as above to set a up a selection list with the above entries. Step 1: New create a new list with statusesД®nter the options people can choose from: This is where colleagues can enter their workshop attendance. You can make your spreadsheet even prettier by color-coding different entries.ДЇor this example IвЂ™m first creating an options list with three statuses. Bonus: Using conditional formatting for option lists Next IвЂ™m gonna show you how to use conditional formatting for list option entries. Make sure you copy the cell content to adjacent cells below in order to turn them into drop-downs.Д«y the way, you can also hide the options sheet so people canвЂ™t change it:ДЇinito вЂ“ this is the end of the first tutorial. You can now easily pick an entry from the department list. If it looks different youвЂ™ve made a mistake.Дone! You have just created your first drop-down list in Excel. Then press EnterВ to get back to the following screen. Now open the departments tab and select the entire column: To select the department list as data source, click on the right button: Excel of course needs to know what list to pull the values from. Because we want the cell to accept certain list values only, you must choose List. In the next dialog window you specify how Excel should validate cell values. For this, select the cell you want to format and choose Data Validation from the menu: Enable data validation to pull list values Now we have to modify the cell such that it accepts list entries. You could store them in your main sheet, but I recommend to create a separate tab so nobody else can mess around with them.Д¬reate new tab departmentsВ and enter possible values: Add as many entries to your option-list as you want Step 2: Enable data validation for cells The selection values have to be stored somewhere in your Excel. Step 1: Create a new tab for selection values Column D in addition uses conditional formatting to set the color based on the entry. HereвЂ™s the template we are going to create. Tutorial: Create a drop-down list in Excel Learn how to set up a drop-down list yourself.

HOW TO MAKE A DROP DOWN LIST IN EXCEL WITH PICTURES MANUAL

Why not have people select their department with two clicks? The other downside of manual entry is thereвЂ™s a high probability of data entry mistakes.ДЄ drop-down list can be very helpful in such cases. Manual entry of general data like department is bad for two reasons: First people have to do a lot more typing ( вЂA-c-c-o-u-n-t-i-n-gвЂ™ has 10 characters). Then, using the data further for sorting or filtering will mean you have to fix typos like the following first: Without having some sort of mechanisms to ensure the correctness of data, your sheet will become messy soon. Suppose you are organising a workshop and you want to poll attendance.В You create a simple spreadsheet where people can enter their name, department and whether they want to join or not. One of those advanced features IвЂ™m gonna show you in this tutorial: Drop-down lists. ThatвЂ™s because many processes can be sped up and made safer - if youвЂ™re familiar with advanced Excel features. If youвЂ™re the average Excel user, youвЂ™re probably wasting tons of minutes every week to get your work done.

How to make a drop down list in excel with pictures