Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SSS148 on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Pulldown Menus in Excel

Status
Not open for further replies.

HarvCLAUtilities

Electrical
Apr 24, 2008
5
NKT's answer works well, but it only works in the same sheet. I would like to create the list or lists on one sheet (Hidden) and use it throughout the workbook. Is this possible? thanks in advance


NKT (Structural) 11 Apr 08 16:22
Data --> Validation ... opens a "Data Validation" dialog box
on the "Settings" tab:
Allow --> List
Source --> (select cells with your desired input value list)

Then highlight the cell and drag with the right mouse button to select your column of input cells, and select "fill formatting only". This will copy the data validation (pull down menus) to your column of input cells.

 
Replies continue below

Recommended for you

You can use a namded range from different sheet within the same workbook.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor