+ Reply to Thread
Results 1 to 9 of 9

Formula in f2 does not show cell reference

  1. #1
    Registered User
    Join Date
    12-20-2012
    Location
    Beirut, lebanon
    MS-Off Ver
    Excel 2007
    Posts
    5

    Formula in f2 does not show cell reference

    I'm working on an excel sheet which relies alot on formulas, but the formula in the cell when I click f2 does not give me a cell reference:

    For example:

    In my cell A1 I have : Training Center
    If I choose cell A2 and put : =A1
    and when I click back (f2) instead of seeing :=A1
    Instead I see : =Training_Center

    How can I change it back to a cell reference?

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Formula in f2 does not show cell reference

    Hi

    Can you post a sample when I tried it on my workseet I got the required cell reference

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.



    Chris
    Click my star if I helped Thanks

  3. #3
    Registered User
    Join Date
    12-20-2012
    Location
    Beirut, lebanon
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Formula in f2 does not show cell reference

    In cell A1

    Thanks!

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Formula in f2 does not show cell reference

    you have named ranges. if you type = and then select the cell the formula will contain its name but if you simply type =a1 for example, it should remain as =A1
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  5. #5
    Registered User
    Join Date
    12-20-2012
    Location
    Beirut, lebanon
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Formula in f2 does not show cell reference

    How can I fix it so that when I remove the name range (I'm assuming from Name Manager in the data tab), my excel workbook will have a cell reference instead of the name range.

    If i remove the name, and I save, whatever was as a formula will become #NAME. Is it possible to remove the name range so that it will become =A1 without having to re-enter all the formulas?

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Formula in f2 does not show cell reference

    you have to use the find/replace dialog unless you have the FastExcel version of the Name Manager add-in (not the Name Manager that is built into excel 2007)

  7. #7
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Formula in f2 does not show cell reference

    these methods should work in excel 2007
    http://www.excelforum.com/excel-gene...ack-again.html
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  8. #8
    Registered User
    Join Date
    12-20-2012
    Location
    Beirut, lebanon
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Formula in f2 does not show cell reference

    Quote Originally Posted by martindwilson View Post
    these methods should work in excel 2007
    http://www.excelforum.com/excel-gene...ack-again.html
    Ok great I tried the Macro in the other post, initially it worked.. Haven't checked all the cells yet..

    Thank you!!! this saved me

  9. #9
    Registered User
    Join Date
    12-20-2012
    Location
    Beirut, lebanon
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Formula in f2 does not show cell reference

    Quote Originally Posted by martindwilson View Post
    these methods should work in excel 2007
    http://www.excelforum.com/excel-gene...ack-again.html
    Ok great I tried the Macro in the other post, initially it worked.. Haven't checked all the cells yet..

    Thank you!!! this saved me

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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