insert>name>define

Robin · Jul 30, 2009

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

Sincerely,

Robin

Dave Peterson · Jul 30, 2009

Try
Format tab|defined names group

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

Robin · Jul 31, 2009

Dave Peterson said:
Try
Format tab|defined names group

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

Robin · Jul 31, 2009

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

Robin

Robin · Jul 31, 2009

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 · Jul 31, 2009

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

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

Dave Peterson · Jul 31, 2009

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 · Jul 31, 2009

Dave, I have looked at that but have difficulty putting it all together. You
went with me in excel and really were a big help. I spent many hours and I
thank you. I wrote the question better and this is what was replied this is
the respnse that I got I am getting ready to try it out .

you look at the arguements for OFFSET, you'll see that the last number
controls how many columns to return. (the previous controls length). For your
situation, I'd write:

=OFFSET(Sheet1!$C$1,0,0,MAX(COUNTA(Sheet1!$C:$C),COUNTA(Sheet1!$D$D)),2)

The MAX function is there to determine which column (C or D) is controlling
the size of your range.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Thank you again.