How to easily create a drop down list in excel and make it easier to complete the table?
Hello everyone, dear friends and guests of my blog. And again I am with you, Dmitry Kostin, and today I want to tell you more about Excel, or rather about one wonderful feature that I now always use. Have you come across the situation. when you fill out a table and in some column you need to constantly enter one of several values. Eeeee. Let's better tell you with an example.
Suppose, when I created a computer equipment accounting table (a long time ago) at my work, in order to make the whole process more convenient and faster, I made a drop-down list in certain columns and inserted certain values into it. And when I filled in the “Operating system” column (But it’s not the same on all computers), I scored several values (7, 8, 8.1, 10), and then I just selected it all with one click of the mouse button.
And thus, it is no longer necessary to drive a version of Windows into each cell, or copy from one cell and paste it into another. In general, I will not torment you, let's better get started. Let me show you how to create a drop down list in excel using data from another sheet. To do this, we will create some plate to which we can apply this. I will be doing this in the 2013 version, but the process is the same for other versions, so don't worry.
Preparation
Basic actions
Now work with graphs in exactly the same way "Specialist's name" And "Summary of Elimination", then return to the main sheet again and begin to fully work with the table. You will see for yourself how great and convenient it is when you can select data from the available pre-prepared values. Thanks to this, the routine filling of tables is facilitated. 
By the way, in such documents, for a more convenient display, it is better. Then everything will be cool.
Well, for today I finish my article. I hope that what you learned today will be useful to you when working in Excel. If you liked the article, then of course do not forget to subscribe to my blog updates. Well, I look forward to seeing you again on the pages of my blog. Good luck and bye bye!
Sincerely, Dmitry Kostin