Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm trying to determine how a series of dropdown lists were creat.
I'm trying to determine how a series of dropdown lists were created in an
existing Excel worksheet that I'm editing. Row 1, Columns A through G have dropdowns with extensive lists in each. If I click on Row 1 itself I see the apparent name of the Row, "Print_Titles". But I cannot determine how the lists were created and where they reside. This is the only worksheet in the workbook. I need to create an additional list - which I want done in the same way as these. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm trying to determine how a series of dropdown lists were creat.
The Print_Titles range name isn't associated with the dropdowns. That name was
created when someone used file|Page setup|page tab and put something in the Rows to repeat at top box. Are those dropdowns used to show/hide the data under the titles? If yes, then the dropdown could have been created by data|Filter|autofilter. Does it look like these examples at Debra Dalgleish's site: http://www.contextures.com/xlautofilter01.html Or is that cell used for data entry? Maybe they were created by Data|Validation http://www.contextures.com/xlDataVal01.html (also from Debra's site) There are a couple of other ways, too. RJJ wrote: I'm trying to determine how a series of dropdown lists were created in an existing Excel worksheet that I'm editing. Row 1, Columns A through G have dropdowns with extensive lists in each. If I click on Row 1 itself I see the apparent name of the Row, "Print_Titles". But I cannot determine how the lists were created and where they reside. This is the only worksheet in the workbook. I need to create an additional list - which I want done in the same way as these. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I'm trying to determine how a series of dropdown lists were creat.
file|Page setup|Sheet tab (not Page tab) created the name.
Dave Peterson wrote: The Print_Titles range name isn't associated with the dropdowns. That name was created when someone used file|Page setup|page tab and put something in the Rows to repeat at top box. Are those dropdowns used to show/hide the data under the titles? If yes, then the dropdown could have been created by data|Filter|autofilter. Does it look like these examples at Debra Dalgleish's site: http://www.contextures.com/xlautofilter01.html Or is that cell used for data entry? Maybe they were created by Data|Validation http://www.contextures.com/xlDataVal01.html (also from Debra's site) There are a couple of other ways, too. RJJ wrote: I'm trying to determine how a series of dropdown lists were created in an existing Excel worksheet that I'm editing. Row 1, Columns A through G have dropdowns with extensive lists in each. If I click on Row 1 itself I see the apparent name of the Row, "Print_Titles". But I cannot determine how the lists were created and where they reside. This is the only worksheet in the workbook. I need to create an additional list - which I want done in the same way as these. -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent dropdown lists | Excel Discussion (Misc queries) | |||
VLOOKUP and Multi Lists | New Users to Excel | |||
How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
How do I determine statistical relationship between two series | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel |