Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maximum Names - (Insert - Define) | Excel Discussion (Misc queries) | |||
InsertNameDefine | Excel Worksheet Functions | |||
Insert / Name / Define | Excel Discussion (Misc queries) | |||
Insert-Name-Define limit ? | Excel Discussion (Misc queries) | |||
Insert menu...Define | Excel Worksheet Functions |