Software

Ask something
Discussion Locked

Excel Drop down box

0 helpful
3 replies

by teresa.conrad

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a user in need of a drop-down box in an Excel 97 spreadsheet. I can insert the combo-box, but when I get to the
properties, it does not contain an Input Range or Cell Link. I looked
this up in an Excel book and my options are no where near what they
show. Any hints.......

3 replies

by peyison

You can add a combo box via the Data Validation function.

Select Data -> Validation

On the "Settings" tab, in the "Allow" dropdown, select List. You can then enter the range for your list in the "Source" box.

Hope this helps.

This discussion is closed to new replies.