excel 'name box'

[firedog]

how to delete entries in excel 'name box'

 

[Jason Morin]

Ctrl+F3. Select the name and delete.

HTH
Jason
Atlanta, GA

 

[Norman Harker]

Hi firedog!

For Versions of Excel before Excel 2003

Tools > Options > Transition
Check "Transition Navigation Keys"
OK

Then

/ r n r

Resets all names.

There's no equivalent Excel command other than doing it one at a time
or using a VBA subroutine.

But be aware that there is no "are you sure?" and if you haven't saved
the file recently you could get pretty upset as you can't undo.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Dave Peterson]

If you work with names a lot, do yourself a favor and get this addin:

Jan Karel Pieterse's (with Charles Williams and Matthew Henson) Name Manager.

http://www.jkp-ads.com/Download.htm

Life will be a lot nicer!

 

[RagDyer]

I got burned on this a week or two ago Norman.<g>
You *also* have to check "Lotus 1-2-3 Help", don't you?
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Hi firedog!

For Versions of Excel before Excel 2003

Tools > Options > Transition
Check "Transition Navigation Keys"
OK

Then

/ r n r

Resets all names.

There's no equivalent Excel command other than doing it one at a time
or using a VBA subroutine.

But be aware that there is no "are you sure?" and if you haven't saved
the file recently you could get pretty upset as you can't undo.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi RD!

I always thought that the absence of a "Health Warning" was a Pythonesque
approach to programming especially as it is so easy to use:

/rnr
instead of
/rnt

The t is next to the r and with too many beers or not enough coffee and
instead of getting a table you smash everything on it. If you've saved
recently, no probs! But then we all save frequently, don't we?

I think that with a suitable Health Warning this is a command that Microsoft
could add in to the naming options. At present, they've just deleted the
"Lotus" option from Excel 2003.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.