+ Reply to Thread
Results 1 to 10 of 10

Copy and paste formulas without changing cell references

  1. #1
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Copy and paste formulas without changing cell references

    This is the best solution I have found so far (not the Kutools bit, the bit before)

    http://www.extendoffice.com/document...-formulas.html


    Does anybody have any better ideas. Thanks

  2. #2
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,741

    Re: Copy and paste formulas without changing cell references

    Hi,

    Have you experienced difficulties with that particular solution?

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Copy and paste formulas without changing cell references

    No its just more time consuming than anything. I was hoping for something along the lines of a paste special shortcut, thanks

  4. #4
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,741

    Re: Copy and paste formulas without changing cell references

    Interesting, as I find it extremely quick (perhaps we differ on this definition!), i.e. when I apply a Find and Replace en masse, copy, paste, reverse Find and Replace.

    Perhaps you have many separate ranges on which you need to perform this operation, which rules out an en masse Find and Replace?

    Regards

  5. #5
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Copy and paste formulas without changing cell references

    Well I find that when you highlight a selection, you have to click replace, replace, replace, replace 100 times, because if you choose replace all, that will replace all items even outside the area you highlighted before selecting Ctrl f.

    Do you suffer the same?

  6. #6
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,741

    Re: Copy and paste formulas without changing cell references

    No.

    Using Replace All, Excel will only perform the replace for those cells within the area you have highlighted , provided it is more than one cell and provided that you have the Within: box set to Sheet, NOT Workbook.

    Regards

  7. #7
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Copy and paste formulas without changing cell references

    Wow what a bizarre set of rules, how on earth did you learn them? and thanks

  8. #8
    Forum Guru XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,741

    Re: Copy and paste formulas without changing cell references

    Haha!! Through experiencing the agony of doing what you were previously doing!

    And you're welcome.

  9. #9
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Re: Copy and paste formulas without changing cell references

    Haha nice very much appreciated

  10. #10
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Copy and paste formulas without changing cell references

    I found that this works pretty well. Highlight the formula in the formula bar, Ctrl +C + Esc. Select the cell where you want the formula and Ctrl +V.

    Just selecting the cell with the formula and copying will not do what you want.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 10-07-2012, 11:01 AM
  2. [SOLVED] Copy / Paste without cell references changing.
    By Big Rick in forum Excel General
    Replies: 6
    Last Post: 05-08-2012, 03:15 PM
  3. Replies: 3
    Last Post: 10-20-2006, 03:33 PM
  4. Copy formulas exact without references changing
    By mikeburg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2005, 11:18 AM
  5. [SOLVED] Copy/Paste without changing location references
    By Tom in forum Excel General
    Replies: 3
    Last Post: 03-31-2005, 09:06 AM

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