Today, the computer has become a necessary part of our lives. Various programs simplify all work so much that even an inexperienced novice user cannot do without them. Excel has become one of them - convenient, simple and quite effective. Due to its many functions, it can be used both on a home computer and in office work. For some, it has become simply irreplaceable.
Of course, to start working with Excel is quite difficult, but over time, having understood its functions, it becomes much easier. It is sometimes difficult for a novice user to understand all the nuances of work, so the article will discuss a specific question that interests many: “How to make a drop-down list in Excel?”. Let's try to figure it out.
, , Excel. , Excel-, . . - , , . , .
, Excel . , . , . , : «» – «» – «».
( , – ). «». , . . «» – «». «». «». «» «» . . Excel .
, , -. , Excel. . , , .
. Excel 2007-2010 «» ( , «»). , , , . Excel.
« ». : « » ( , ), « » ( , ), – « » ( ). «». , .
A very simple way to create drop-down lists, which is suitable even for those who are little versed in computers, is as follows. Two or three values are entered in the column (as many as possible). One of them is hovered over and the keyboard shortcut Alt + Down arrow is pressed , or the item “Select from the drop-down list” is selected using the right mouse button.