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.

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

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