List Box in Excel 97

J

Jean

I have 3 questions relating to List Boxes in Excel 97:

1. Can it be attached to the cell rather than looking
like a drawn list box. I want dropdown arrow to appear
when I click in the cell. I don't want it to appear
unless I am in the cell.

2. I don't want to link it to data in the spreadsheet. I
want to type independent data in the List Box.

3. Can this cell default to being blank? (I suppose I
could have one of the entries as a blank one.)

Thank you.
 
L

Lee

Click in the cell where you want the dropdown
Go to the Data menu/Validation
Change criteria to a "List" and type your source
information in separated by commas and no spaces.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Possible to Combine reports to's to a single box? 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Merging from an Excel file with graphics 1
Combo box 0
DROP DOWN ARROW NOT APPEARING ON ANOTHER USERS EXCEL SHEET WHEN SETUP IN ORIGINATORS SHEET 6
Creating Multi Level list using Header Style 1
list or combo box 0

Top