+ Reply to Thread
Results 1 to 2 of 2

How to change or delete a defined cell name

  1. #1
    Registered User
    Join Date
    05-02-2005
    Posts
    65

    How to change or delete a defined cell name

    I have a spreadsheet that I define a name to a give cell. For example, Cell A10 is defined as Gross_Margin. Once defined, how do I:

    1) Change that defined name? For example, if I want to change it to Gross_Margin_Percent, how do I do that?
    2) Delete that defined name? In this case, I want to delete it all together?


    The only thing that it appears that I can do it to add a new cell name. But the problem is that when I try to access it, then all names are listed!

    Thanks in advance for your help!
    Jim

  2. #2
    Valued Forum Contributor
    Join Date
    01-10-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    651

    Re: How to change or delete a defined cell name

    in the formulas ribbon you should see Name Manager. You can edit and delete names from there.
    Hope I could help - if your post has been solved don't forget to mark it as such.

    Clicking the * below is a great way to say thanks!

    "Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-08-2014, 04:57 AM
  2. Replies: 3
    Last Post: 04-21-2014, 11:31 PM
  3. [SOLVED] Confirmation Popup Window on Cell Change & Cell Delete. (3 conditions)
    By smk224 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-12-2013, 02:51 PM
  4. Table based on defined name, change defined name, how?
    By Dubrock in forum Excel General
    Replies: 0
    Last Post: 06-27-2012, 09:20 AM
  5. Change the formula of a target cell in a self-defined worksheet function
    By mxcaocao in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2008, 02:50 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1