If you do not want to have Excel adjust the cell references, you would have to make them absolute before copying them.
Follow these steps: When you copy an Excel formula in this manner, the formula copies as text and will not adjust its cell reference. For example, you may want to include the formula as part of an If statement in another part of the worksheet.
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.
You'll be able to ask any tech support questions, or chat with the community and help others.
As said before, you can freeze the selected cell by putting a $ in front of 1.
You could also use the key F4 when you selected the cell reference in the formula bar.Normally Excel adjusts the cell references if you copy your formulas to another location in your worksheet.You would have to fix all cell references with a dollar sign ($) or press F4 key to toggle the relative to absolute references to prevent adjusting the cell references in formula automatically.You can now choose when you want to update your formulas on the spreadsheet.This allows you to avoid constant formula updates that can drastically slow down editing time on large spreadsheets.In this case, the workbook calculation was set to Automatic on all the machines – that’s the first thing we checked.