Question

How to add dropdowns to Microsoft Excel 2007??
(Add Video or Screenshots

Answer 1

Answer:

to insert screenshots:

In your Excel spreadsheet, select the Insert tab.

Click Screenshot.

A drop down menu will appear with the option to take a screenshot of a window open on your desktop, or take a screen clipping of only a portion of your screen.

Select the option that suits your need.

The screenshot or screen clipping will insert straight into your Excel spreadsheet.

Adjust sizing and placement of the image as needed.

u can add dropdown from transactions which is only available in Microsoft excel 2010 onwards 2007 excel does not have the feature of dropdown.

hope this helps you.

pls mark as brainliest.

Answer 2

Answer:

1.. Select a cell or range for your drop-down list.

2. Use Excel Data Validation to create a drop-down list.

3. Enter the list items and choose the options.

finished...