In Excel, you can add many types of picture files, including BMP, GIF, JPG, PNG, and TIF files.

You can also add 3-D models, icons, and SmartArt to an Excel spreadsheet.

You can also resize the image by moving your mouse pointer to the corner of the image, then click and drag to the desired size.

But there are few situations when this insert option disabled in Excel or the Excel Insert Button greyed out and will not allowing you click.

Please let us know if you find some other reason for insert option disabled excel.

I have got the opportunity to work for Genpact, Hewlett Packard, MModal and Capgemini in various roles and responsibilities, starting from an Associate to a Manager.

Learning anything new has always been my passion and if related to Business and Technology then I love it.

Keygeek.com is an outcome of my passion towards the same and I have been into asKeygeek since 2012.

In short, a Consultant by Profession a Geek by Interest a Filmmaker by Passion.

You can add drop-down lists to cells in Excel containing options such as Yes and No, Male and Female, or any other custom list of options.

Drop-down lists are created using the Data Validation feature.

Were going to create a drop-down list with a selection of age ranges to show you how its done.

We entered our age ranges into cells A9 through A13 on the same worksheet, as shown below.

You can also add your list of options to a different worksheet in the same workbook.

To do this, select all the cells containing the drop-down list items and then enter a name for the cell range into the Name box above the grid.

On the Settings tab, select List from the Allow drop-down list (see, drop-down lists are everywhere).

Enter Age in the Source box (if you named your cell range something else, replace Age with that name).

This means that the user can select the cell and then deselect the cell without selecting an item.

If you want to require the user to select an option from the drop-down list, uncheck the Ignore blank check box.

To do this, click the Input Message tab on the Data Validation dialog box.

Make sure the Show input message when the cell is selected box is checked.

Enter a Title and an Input message and then click the OK button.

The down arrow button only displays when the cell is selected.

Click OK to remove the drop-down list and restore the cell to its default format.

If you have many drop-down lists you need to add on a worksheet, you may want to put the lists of options on another worksheet in the same workbook.

You can hide the worksheet containing your lists of options to prevent them from being changed.

Shes been a senior technical writer, worked as a programmer, and has even run her own multi-location business.

Since we launched in 2006, our articles have been read more than 1 billion times.

Insert Picture In Excel 2017 For Mac