Copy and Paste Formula

Discussion in 'Excel' started by marste7, Aug 27, 2013.

  1. marste7

    marste7

    Joined:
    Aug 27, 2013
    Messages:
    1
    Likes Received:
    0
    I have this formula in one book ='Page 2c'!C10+'Page 2c'!F10

    When I copy it to another book it adds the name of the book I am copying from

    ='[c_534156_NCRRC_1130_2013.xlsx]Page 2c'!C10+'[c_534156_NCRRC_1130_2013.xlsx]Page 2c'!F10


    How can I copy this formula and have it refer to the current book?

    Thanks
     
    marste7, Aug 27, 2013
    #1
    1. Advertisements

  2. marste7

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Copy only the text of the formula and paste INTO a cell in the other workbook. Here's how:
    1. Select the cell the formula is in
    2. Press F2 key
    3. Shift + Home
    4. Ctrl-C
    5. Esc key
    Select the cell in the other book where you want the formula to be pasted
    1. F2 key
    2. Ctrl-V
    3. Enter key
     
    XLPadawan, Jun 16, 2016
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Nago
    Replies:
    0
    Views:
    574
  2. jushin100
    Replies:
    1
    Views:
    993
    madonaalbert
    Jun 21, 2012
  3. CarolB
    Replies:
    2
    Views:
    1,007
    XLPadawan
    Jun 15, 2016
  4. baldi
    Replies:
    1
    Views:
    820
    Sohail
    Dec 25, 2014
  5. asyluma
    Replies:
    0
    Views:
    500
    asyluma
    Oct 9, 2013
  6. teza2k06

    Conditional Formatting Formula

    teza2k06, Aug 23, 2014, in forum: Excel
    Replies:
    2
    Views:
    634
    XLPadawan
    Jun 16, 2016
  7. DSnuh
    Replies:
    1
    Views:
    362
    XLPadawan
    Jun 15, 2016
  8. Kyle Hinterman

    How to paste the same cell one tab over

    Kyle Hinterman, Nov 20, 2015, in forum: Excel
    Replies:
    1
    Views:
    419
    XLPadawan
    Jun 10, 2016
Loading...