Many users of Microsoft's standard office suite clearly underestimate the Excel spreadsheet editor. A drop-down list in a cell, saving time spent on entering or searching for data, is created in it in a couple of seconds, unlike Access, where this procedure is more complicated. Below are three main methods for creating such lists and some important parameters for managing them.
What are dropdown lists for?
. , , .
:
, Excel. . , .
Excel :
, . Excel ? . , - , . «», – « ». .
() , «». , . , . - .
Excel 2007:
. , Excel , , . , . . : .
. , : A2 A4. . . , «(A2:A4)», , «=$A$2:$A$4».
. , , .
()
, , , Excel . . , . , . Excel 2007 , , .
, Excel . , , – . , . , , " ". , . , . . .
, , Excel , . : ? , . . . , . . , .