Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

copying and pasting

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying and pasting

Copying and pasting

ResolvedVersion 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

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.