Excel Hack: Copy Formula Without Changing Cell References (or Without File References)


Would you like to copy your Excel formulas from one place to another without the cell references changing? In this video I show you a simple trick that does that.
Check the Excel Essentials Course:

Excel default behavior is to adjust the cell references when you copy a cell and paste to another one. You can choose to fix the cell reference by using the dollar sign ($). A $ for the row number, fixes the row and a $ on the column number fixes the column.

You might however need to copy a set of formulas that have relative references from one location to another or from one file to another and keep the existing cell references. This video shows a very simple trick you can use.

★ My Online Excel Courses ★

Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free


Get Office 365:
Microsoft Surface:

Screen recorder:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!





  1. This worked perfectly in 24,875 cells !! 😂
    I have been trying to copy Table from one workbook to another, but it was pasting link before formulas.

    After being tired i searched on Google and got your video, that made everything perfect within minutes…
    Thank you so much !!

  2. Or you know…just use dollar sign "$" to lock the reference in the forumla , for example to lock both rows and columns =A1 * $B$2 , copying and pasting won't change the reference B2

  3. Could you please suggest me any formula which could give me answers in two columns : I have two column data debit and credit and a variance about $ 0.2 but I want that if variance would be in negative that will added to credit column's highest value and if it is positive then it would add into debit column highest value and other value would remain same ?


Please enter your comment!
Please enter your name here