Ah, 2007. I'm afraid I'm still using 2003, so I'm not quite sure what the new
layout looks like. In the hopes that Microsoft kept the same shortcut keys,
you could try pressing Ctrl+F3. That, at least it used to be, is the shortcut
to bring up the dialogue.

So if I define "tax" as $H66, and put =tax in $G66, can I copy my 66
row to 67 and have $H67 show up in $G67?

Yes, that is correct. Note that you will want to make sure the active cell
is in row 66 when you setup this defined name.

I have no idea how to do that. I'm reading this newsgroup with Forte
Agent.

That's ok, it's not "all-important", but I appreciate you explaining.
--
Best Regards,

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


"Howard Brazee" wrote:

On Fri, 21 Aug 2009 11:13:01 -0700, Luke M
wrote:

Goto Insert - Names, Define.

I found a tab named Insert, but did not see any items for Names. I
have the newer version of Excel that doesn't work the way the old
menus did, and I never can find anything anymore. I spend lots and
lots of times looking for stuff in the new menus.

Inside the Insert tab, I see categories Tables, Illustrations, Charts,
Links, & Text. I imagine Names, Define is somewhere, but I'm not
finding it.

You can now manage your named ranges, deleting your old values. You can use
absolute references to allow the named range to be in a column, but have a
relative row reference. For instance, define "tax" as
=$H66

So if I define "tax" as $H66, and put =tax in $G66, can I copy my 66
row to 67 and have $H67 show up in $G67?


Remember to click "add" after you setup the name and what it refers to.
--
Best Regards,

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

I have no idea how to do that. I'm reading this newsgroup with Forte
Agent.

--
"In no part of the constitution is more wisdom to be found,
than in the clause which confides the question of war or peace
to the legislature, and not to the executive department."

- James Madison