VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » Geeks Tutorial
How to Create a Drop Down List in Excel 2016

How to Create a Drop Down List in Excel 2016

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
were going to show you how to create a drop-down list in Excel 2016. Don't forget to check out our main channel for more free how-to videos! Join us on Facebook Our App Well first create a new Sheet by hitting the plus sign located in the bottom left of the screen. Within this second sheet, well write out the list of options the user can choose within the drop-down list. The example will be numbered, so I will start by typing [Qtr 1] in the first cell. Then, move the cursor to the bottom right of the selected cell until the cursor changes and click and drag it down to however many you want. The list should automatically be numbered. Select the entire list and right-click it. Choose Define Name Create a name for the list and remember it. Leave the Scope set to Workbook to allow the list to be used in different Sheets. Go back to Sheet 1 and select the first cell you want the drop-down list to be in. Go to the Data tab and click Data Validation. Open the drop-down Allow: , and choose List. In the Source area, type in the equals (=) sign followed by whatever you named your drop-down. Finally, hit OK. You should now have the option to open the drop-down list of the cell and choose one of the options. You can copy and paste this cell to other areas of the worksheet, and you can also move your cursor to the bottom right of the selected cell until it changes, and click and drag it to duplicate the contents to all selected cells. You should now have drop-down capabilities in affected cells
Date: 2023-07-08

Comments and reviews: 6


Thanks! starting to get it but I need more! Need some help to create a drop down list for my teaching standards in an excel lesson plan worksheet. Each sheet will represent a weeks worth of lesson plans and some standards will be repeated. I only want the standard code/name to appear not the whole description for space saving reasons. Please point me to the right direction!
reply

For individuals who are learning, you moved way too fast. I'm sure it's good information but trying to keep up with your pace was difficult. If you want to stay at a pace like that, just repeat the steps again to ensure people got it. But thanks for posting and sharing.
reply

Really disapoiinted when someone like yourself, very good at this, doesn't slowly explain things. Go a bit slower, be a better instructor please
reply

But what happens if we delete the other document from which we created the drop-down list data?
Will the newly created list remain?

reply

Is there a button you can type to easily access the reference rather than having to click the arrow every time?
reply

why do people showing you something you obviously dont yet know have to do it at a 100 miles an hour?
reply
Add a review, comment






Other channel videos