To add the drop-down list in our example to an Excel cell, do the following: Select D2 to follow the example, but you can put the drop-down anywhere. Click the Data tab and then click Data ...

The PDF File has been inserted into an Excel sheet as an object similar to a chart or any shape. We can drag it or resize it as we want. Repeat the same steps to insert more PDF files into the sheet.

Open Excel and click on the File tab ... It does not matter if this list is located on the same or a different worksheet as your combo box. Click the "Insert" button on the Developer tab and ...

How to edit a drop-down list in Excel based on a cell range 1. Go to the worksheet or area of your current worksheet where your list items are, and then add or delete the desired item.