resortwhe.blogg.se

You can then configure any specific cell in the Excel form to point to this list of data. Since you can make multiple worksheets in one Excel workbook, most people use a separate sheet to populate the data list. Set Up the Listīefore you create a dropdown list in Excel, you need a list of data to use.

You can make it easier to fill out forms in Excel 2019 using data lists, and this article shows you how to create them. For instance, you might want to select a state from a dropdown list in a column that stores the state for a customer address. Some of the data items are repetitive, meaning that you don't type data into a cell but rather select from a data list. Excel 2019 is used in many organizations to fill out information on customers, orders and products.