Olivia has attended:
Excel Intermediate course
Copying and pasting
If I copy and paste information from one group of cells to another, what happens to any formulae that are applied to those cells? I find I get confused with with absolute and relative referencing in this situation
RE: Copying and pasting - Formulae Absolute and relative
Dear Olivia
Thank you for attending Excel Intermediate course. I hope you enjoyed the course and benefited from it.
Please refer to the following link and I am sure that concept of relative and absolute referncing will be much clear to you!!
Please let me know if you need any extra resources for furtehr clarification!!
http://www.educ.uvic.ca/compined/Level1/excel/cellref.htm
Please mark this post as resolved if yousatisfuied with the answer.
Many thanks
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007