98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Copying and pasting
Copying and pasting
Resolved · Low Priority · Version 2007
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Hide separate columns in Excel 2010If you want to hide columns not adjacent to each other for example, Columns A, C and E then:- |