How to add list in excel 2016

July 21, 2022
1.3K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

The simplest approach to build a dropdown list in Excel is to manually enter the list. When only one cell needs a dropdown list and it won't need to be updated regularly, this is the best option.

How to create a list using simple method in excel online, 2016 and 2019

  1. The cell or cells where you wish to make your list should be selected.

  1. Data Validation may be found on the ribbon after choosing Data from the menu.

  1. A Data Validation window will appear as a result. List may be found by selecting the dropdown list next to Allow.

  1. You may manually type the items you want in your list using this method. Simply enter each item in the Source area, using commas to separate each item.

  1. Choose OK. You may now see a dropdown arrow next to the cell you choose. All of the things you wrote will be present in this list after you click this arrow.

It takes the longest to maintain, while being the quickest way to generate a dropdown list in Excel. Returning to the validation settings and changing the Source field is necessary in order to modify the list.

Modifying these dropdown lists might be time-consuming if you generate a lot of them in Excel. Because of this, it's crucial to limit the usage of this approach to single cells and lists that you don't intend to update.

Add list  using a range in excel

You may choose items for your list from a variety of other Excel columns if you'd prefer a more adaptable option.

  1. First, enter each item you wish to include in your list into a separate cell in any column. These can be entered on either the current spreadsheet or another one.

  1. To pick the cell and open the Data Validation window, repeat the previous procedure. Specify List in the Allow field. This time, choose the up arrow symbol to the right of the Source field rather than entering anything into it. You may choose the field from which to draw the list items using this range selection option.

  1. The Data Validation window will collapse, revealing the full sheet. Drag the mouse down the complete range of cells that include every item you wish to include in the list. When you're finished, click the down arrow symbol next to the selection area on the right. The Data Validation window will reopen after doing this.

  1. The range you choose will now be shown in the Source box. To accept these choices, simply click OK.

  1. Now, all of the items included from the range you just selected will be visible when you pick the dropdown arrow to the right of the cell you've designated as a dropdown list.

The wonderful thing about this method is that any item in that list may be changed by just changing any cell in the range. Every dropdown list you've made with this range as the source will be updated by any changes you make there.

Creating list in excel:

Excel makes it simple to create drop-down lists, and there are many alternatives available. How many cells you want to enable with a single list of things and how flexible you want the list of items to be will simply determine the way you choose. Use the dynamic technique without a doubt if you want to often update the list elements.

Note: This was an attempt to show you how to add list in excel online, 2016 and 2019 in both windows and mac. 

To get the newest version of WPS Office, you must first access this operating interface.

You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.