Pasting without updating cell references in formulas

  • Thread starter Thread starter Reg Willems
  • Start date Start date
R

Reg Willems

I am a relatively low end user of Excel. I need to copy a large section of
formulas to create a new section of my spreadsheet. Excel does an excellent
job of changing all cell reference in the formulas based on the number of
cells that you cover in your copy and paste. HOWEVER, in this case I want
almost all cell references to remain the same. I can then edit each one and
change the one that I want changed. Is there any easy way to do this. I'm
sure there is.

Thanks in advance
Reg
 
As long as you are moving to the same sheet, just highlight the cells you
want to move and using mouse, click and drag on the border to new location.
All cell references remain the same.
 
Hey, Dale, that works just great!!!! and how much simpler can you get.
Thanks. I just learned something new and have wracked my brains for a long
time to get Excel to do this.
 
Back
Top