+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : How to copy evything without chagin formulas

  1. #1
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    How to copy evything without chagin formulas

    hI EVERYONE, i need to copy everything from A2:A5 to AV2:AV5 there are lots of formulas, is there a way to copy paste all without the formulas changing and having to write in all the formulas $ since doing that would make me have to work for at least 2 hours changing all of that...any help please!

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,366

    Re: How to copy evything without chagin formulas

    hello
    try this one.


    Select the range of cells you want to copy.
    Select Edit » Replace...,
    and in the Find What: box, type*=(an equals sign).
    In the Replace With: box, type*symbol you are sure is not being used in any of the formulas.
    Click Replace All.
    All the formulas will appear on your worksheet with your symbol*in place of an*=

    You can simply copy this range, paste it to the destination you desire,
    Then select the range, and select Edit » Replace.... This time, replace the*symbol*with an*=
    Your formulas will reference the same cell references as your originals.
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Contributor
    Join Date
    11-28-2011
    Location
    puerto rico
    MS-Off Ver
    Excel 2007
    Posts
    113

    Re: How to copy evything without chagin formulas

    thks so much!

+ 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