F
firedog
how to delete entries in excel 'name box'
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jason Morin
Ctrl+F3. Select the name and delete.
HTH
Jason
Atlanta, GA
HTH
Jason
Atlanta, GA
N
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
D
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!
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!
R
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
N
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.