Names

[Howard Brazee]

I decided to simplify a spreadsheet by naming some columns, but messed
up and only named the particular cells I was working on.

I tried to create a new range with the same name, but was told that
the name already existed.

1. How do I delete that old name?
2. Can I give a name to a column without giving that column a range?
3. If so, how do I replace, say =IF(H66>0,F66-I66-K66-H66,"") with
meaningful names, for instance net=gross-labor-depreciation-tax? (each
field is referenced multiple places for that row).

--
"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

 

[Luke M]

Goto Insert - Names, Define.

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
Remember to click "add" after you setup the name and what it refers to.

 

[Howard Brazee]

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

 

[Luke M]

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.

 

[Howard Brazee]

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.

Ctrl-F3 works. It shows for "tax"
=Data!$I$67

So I edited it to
=Data!$I67

Then I referenced tax =IF(H67>0,F67-tax-K67-H67,""). The number is
right but I got a ! and a triangle showing an error.

I then copied that cell up one row. That fixed it, apparently my
version of Excel thinks I have an error if cells look different.

Thanks.

--
"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

 

[Luke M]

Terrific, glad it worked!