If you plan to copy your drop-down lists to other cells, then use mixed cell references when creating the name for the cell(s) with your first drop-down list. For the drop-downs to copy correctly to other columns (i.e. To the right in the worksheet), use relative column (without the $ sign) and absolute row (with $) references like = Sheet2!B$1. Creating a drop-down list in Excel using tools or macros A drop-down list means that one cell includes several values. When the user clicks the arrow on the right, a certain scroll appears. He can choose a specific one. A drop-down list is a very handy Excel tool for checking the entered data. The following features of drop-down lists allow you to increase the convenience of data handling: data substitution, displaying data from another sheet or file, the presence of the search and dependency function. To make your Excel worksheet more efficient, use the drop-down list in the cell. It is easy to select from the list instead of typing in each cell particularly. It also saves time. In this article, I have tried to show you how you can easily make a cell into a drop-down list. So Let us proceed with steps of How to Create a Drop-Down List in MS Excel 2016? Steps to Create a Drop-Down List in MS Excel 2016: Step 1: In the image below you can see that I have prepared an Excel sheet which contains Sr no., Name and City columns. Now I want to create a drop-down list for the City column. I have also prepared the list of cities which I want in the drop-down list in the same Excel sheet. How to disable a program from popping up on startup for mac. If you want, you can prepare the content of drop-down list in the separate sheet also. Now, select the cell to which you want to convert into a drop-down cell. Step 2: Go the Data tab. Under Data Tools group you have Data Validation drop-down button, click it. Select Data Validation from the options. Step 3: A Data Validation Dialog box is opened. ![]() Under Settings tab, you have Allow: drop down box click it and among the options select List. Step 4: After you select List, a Source fill box appears. Click inside the source box. Step 5: After you click inside the Source box, select the content of which you want to create a drop-down list. You will see that inside Source box the code for the content is generated. Step 6: Now you can see that the cell you selected in step 1, is converted to a drop-down cell. Click on the drop-down arrow that appears on the right-hand-side of the cell and the entire drop-down list will appear. Step 7: Now, if you want to apply data validation to all the cells below the City cell. ![]() Just drag the Autofill handle of the drop-down cell up to the cell you want to apply data validation. Hence by doing this, you can make all the selected cells as the drop-down cells. Or The other method to apply data validation to the other cells connected to data validated cell is, select the cells including the data validated cell. Go the Home tab, Under Editing group you have Fill drop-down button. Click Fill button and as I have selected the cells in the vertically downward manner, I selected Down. If you have selected the cells in horizontal, you can choose Right or Left according to your requirement. In this way, you can apply data validation to adjacent cells in bulk. Hope the content is useful. Keep reading.
0 Комментарии
Оставить ответ. |
АвторНапишите что-нибудь о себе. Не надо ничего особенного, просто общие данные. АрхивыКатегории |