How do I create an interactive drop-down list in Excel?
Ngày đăng:
12/11/2021
Trả lời:
0
Lượt xem:
90
Need to add a drop-down list to your spreadsheet? This can be useful for forms, tracking sheets, and more.The simplest way to create a drop-down list in Excel 2013/2016 involves listing the choices in a dialog box. This method works best if you are going to create just a few cells with drop-down lists, because in order to change the choices you would have to modify every cell where it appears. But for simple situations, its a great method. Follow the steps in the video above, or:
Now, spreadsheet users will be prompted to select from the drop-down menuwhen entering data into that cell. Copy the empty box to other cells to include the drop-down menu there. |