Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names
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(H660,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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Howard Brazee" wrote: 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(H660,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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names
On Fri, 21 Aug 2009 12:06:01 -0700, Luke M
wrote: 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(H670,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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names
Terrific, glad it worked!
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Howard Brazee" wrote: On Fri, 21 Aug 2009 12:06:01 -0700, Luke M wrote: 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(H670,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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
converting email address names in a range of cells to real names | Excel Worksheet Functions | |||
using the Excel generic worksheet names instead of user-given names in code | Excel Discussion (Misc queries) | |||
how to copy workbook names and worksheet names to columns in acces | Excel Programming | |||
Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
Change names of files in a folder to match names in Excel Column | Excel Programming |