insertnamedefine
 

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

insertnamedefine
 

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

insertnamedefine
 

"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

insertnamedefine
 

Where is the format tab is it at the top of the screen. I truly am
appreciative of your help.

Robin

"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

insertnamedefine
 

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

insertnamedefine
 

It's the formula tab (sorry about the typo).

(I actually verified first and then just typed the wrong thing!)

Robin wrote:

Where is the format tab is it at the top of the screen. I truly am
appreciative of your help.

Robin

"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

insertnamedefine
 

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