Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Re-name a cell

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have named a cell to act as a bookmark. I now wish to cahnge the name of the cell but going through the same process as initially nameing the cell does not seem to work.

    I am using Excel 2000

    Any suggestions

  2. #2
    Guest

    Default

    delete the name and rename it

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-13 08:29, Lewis wrote:
    I have named a cell to act as a bookmark. I now wish to cahnge the name of the cell but going through the same process as initially nameing the cell does not seem to work.

    I am using Excel 2000

    Any suggestions
    Do you mean you gave a name to a cell thru the Name Box on the Formula Bar?

  4. #4
    Guest

    Default

    Deleting and re-naming does not work.

    Yes I used the name box on the formula bar

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-13 08:59, Anonymous wrote:
    Deleting and re-naming does not work.

    Yes I used the name box on the formula bar
    Activate Insert|Name|Define.
    Select the culprit.
    Click Delete.
    Click OK.

    Now you can give the cell another name either via the Name Box or Insert|Name|Define.

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Easy when you know how. Thanks!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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