|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 16th, 2003, 10:10 PM
|
|||
|
|||
drop down
Does anyone know how to create a drop-down menu in Excel?
For example in Cell A1 I want there to be a list that I can choose from. 
|
|
#2
September 16th, 2003, 10:20 PM
|
|||
|
|||
|
drop down
Check out Data Validation on the Data menu
-- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "anita" wrote in message ... Does anyone know how to create a drop-down menu in Excel? For example in Cell A1 I want there to be a list that I can choose from.
|
|
#3
September 16th, 2003, 10:34 PM
|
|||
|
|||
|
drop down
You can use DataValidation. There are instructions in Excel's on-line
help, and he http://www.contextures.com/xlDataVal01.html anita wrote: Does anyone know how to create a drop-down menu in Excel? For example in Cell A1 I want there to be a list that I can choose from. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
