+ Reply to Thread
Results 1 to 4 of 4

Pasting formulas without changing them.

  1. #1
    Registered User
    Join Date
    11-02-2006
    Posts
    46

    Post Pasting formulas without changing them.

    I have a series of formulas I want to copy and paste. The problem is that everytime I copy and paste the formula (even using 'paste special') it changes it, I want it to remain the same!

    For example if you had the formula B2 + C2 and you pasted it in the row below it would change it to B3 + C3. How do I tell excel to not try and be helpful and not do this (without having to copy everyline of text) and keep the formula as B2 + C2?

    Thanks,

    Dave

  2. #2
    Registered User
    Join Date
    05-13-2004
    Posts
    42
    =$B$2 + $C$2

    Hope this helps,
    Jill

  3. #3
    Registered User
    Join Date
    11-02-2006
    Posts
    46

    Talking

    Ah! I'd wondered why people were put the $ signs in!
    That's much better!
    Thanks!

    Dave.

  4. #4
    Forum Contributor
    Join Date
    07-13-2006
    Posts
    400
    as an add-on to jill you can edit your formula (press f2) when it's higlighted and put your active cursor over A2 and press f4
    it'll alternate between the absolute reference formulas
    i.e. $A$1 will always reference A1
    $A1 will always reference column A but the row will adjust if copied down
    A$1 will always reference row A but the col with adjust if copied across

    if you just want to move the formula to a new location but want to keep it a relative formula (i.e. no $) then you can edit your formula, copy the formula itself, and paste the formula in a new cell.

    hth
    --Mark

    Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?

+ 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