1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Copy cell to cell without excel modifying

Discussion in 'Business Applications' started by noveltech, Feb 8, 2004.

Thread Status:
Not open for further replies.
  1. noveltech

    noveltech Thread Starter

    Joined:
    Sep 29, 2002
    Messages:
    73
    Is there a way to copy a col of formula's/math cells to a new col without excel modifying the coordinates?

    Scenario: 150 cells of diff equations "located from a1 thru a150" you wish to move to d1 thru d150.

    Problem: Excel modifies the coordinates of each pasted formula rendering garbage.

    Individual f2, highlite,copy and then paste takes too much time if there are thousands of formulas to move.


    thanks, nt
     
  2. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Use absolute instead of relative references, ie:

    $A$1:$A$150

    Rgds,
    Andy

    EDIT: better explanation. You have 5 in A1, and the formula =A1 in B1. If you copy B1 to C1, C1 will read =B1. But if you make B1 =$A$1 and then copy it to C1, it'll hold.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/201981

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice