Unnaming cells already named
 

I was wondering if someone knows how to "unname" (or delete the name) a range
of cells I gave a name (1st mistake) and then saved it ( 2nd mistake).
Thanks for helping.

--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

Unnaming cells already named
 

hi
on the menu bar....
Insertnamedefine.
high light the roque name, click delete button, click ok.
done

regards
FSt1

"Learning Excel" wrote:

I was wondering if someone knows how to "unname" (or delete the name) a range
of cells I gave a name (1st mistake) and then saved it ( 2nd mistake).
Thanks for helping.

--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

Unnaming cells already named
 

Thanks FST1, exactly my solution.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"FSt1" wrote:

hi
on the menu bar....
Insertnamedefine.
high light the roque name, click delete button, click ok.
done

regards
FSt1

"Learning Excel" wrote:

I was wondering if someone knows how to "unname" (or delete the name) a range
of cells I gave a name (1st mistake) and then saved it ( 2nd mistake).
Thanks for helping.

--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

Unnaming cells already named
 

hi
you're welcome.
glad to help

Regards
FSt1

"Learning Excel" wrote:

Thanks FST1, exactly my solution.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"FSt1" wrote:

hi
on the menu bar....
Insertnamedefine.
high light the roque name, click delete button, click ok.
done

regards
FSt1

"Learning Excel" wrote:

I was wondering if someone knows how to "unname" (or delete the name) a range
of cells I gave a name (1st mistake) and then saved it ( 2nd mistake).
Thanks for helping.

--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

Unnaming cells already named
 

You can copy and paste a blank cell.

"FSt1" wrote in message
...
hi
on the menu bar....
Insertnamedefine.
high light the roque name, click delete button, click ok.
done

regards
FSt1

"Learning Excel" wrote:

I was wondering if someone knows how to "unname" (or delete the name) a
range
of cells I gave a name (1st mistake) and then saved it ( 2nd mistake).
Thanks for helping.

--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

Unnaming cells already named
 

That only clears the contents of the named cell. The cell retains its name.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob" wrote in message
...
You can copy and paste a blank cell.

"FSt1" wrote in message
...
hi
on the menu bar....
Insertnamedefine.
high light the roque name, click delete button, click ok.
done

regards
FSt1

"Learning Excel" wrote:

I was wondering if someone knows how to "unname" (or delete the name) a
range
of cells I gave a name (1st mistake) and then saved it ( 2nd mistake).
Thanks for helping.

--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.

Unnaming cells already named
 

Yep, you're right.

"Jon Peltier" wrote in message
...
That only clears the contents of the named cell. The cell retains its
name.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob" wrote in message
...
You can copy and paste a blank cell.

"FSt1" wrote in message
...
hi
on the menu bar....
Insertnamedefine.
high light the roque name, click delete button, click ok.
done

regards
FSt1

"Learning Excel" wrote:

I was wondering if someone knows how to "unname" (or delete the name) a
range
of cells I gave a name (1st mistake) and then saved it ( 2nd mistake).
Thanks for helping.

--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.