| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DROP DOWN LIST
I am working on a spreadsheet that requires a choice between Yes or No. There
are 4 tabs for each area I cover, all spreadsheets contain the same basic information; template where the areas will need to be populated. How can I do a drop down menu for a range of cells in each of the tabs of this one workbook? -- Thanx, CA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DROP DOWN LIST
Watch this 5 min video:
How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "CA" wrote in message ... I am working on a spreadsheet that requires a choice between Yes or No. There are 4 tabs for each area I cover, all spreadsheets contain the same basic information; template where the areas will need to be populated. How can I do a drop down menu for a range of cells in each of the tabs of this one workbook? -- Thanx, CA |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DROP DOWN LIST
Videos are blocked by employer; any other method or answer?
-- Thanx, CA "T. Valko" wrote: Watch this 5 min video: How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "CA" wrote in message ... I am working on a spreadsheet that requires a choice between Yes or No. There are 4 tabs for each area I cover, all spreadsheets contain the same basic information; template where the areas will need to be populated. How can I do a drop down menu for a range of cells in each of the tabs of this one workbook? -- Thanx, CA |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
DROP DOWN LIST
Select the cells where you want the drop downs to appear.
Goto the menu DataValidation On the Settings tab, AllowList As the source type in the desired items separated by commas: Yes,No Make sure "In-cell dropdown" is checked OK out -- Biff Microsoft Excel MVP "CA" wrote in message ... Videos are blocked by employer; any other method or answer? -- Thanx, CA "T. Valko" wrote: Watch this 5 min video: How to setup a data validation drop down list: http://youtube.com/watch?v=t2OsWJijrOM -- Biff Microsoft Excel MVP "CA" wrote in message ... I am working on a spreadsheet that requires a choice between Yes or No. There are 4 tabs for each area I cover, all spreadsheets contain the same basic information; template where the areas will need to be populated. How can I do a drop down menu for a range of cells in each of the tabs of this one workbook? -- Thanx, CA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Linear Mode
