Debra Dalgleish has some notes here that may help:
http://contextures.com/xlNames01.html#Dynamic

The instructions are written for xl2003 and below, but once you see that dialog
box (Define Name), it's the same procedure.

Robin wrote:

Dave is there a way a dynamic list can be made of multiple columes. Also I am
unsure as to how to type the data.

"Dave Peterson" wrote:

Try
Format tab|defined names group

ctrl-f3
is still the shortcut for this, too.

Robin wrote:

I go to the top of my excel page and can find insert; however, I cannot find
namedefine. Where do I need to look. I have 2007 version.

Sincerely,

Robin

--

Dave Peterson


--

Dave Peterson