what is the difference between relative and absolute reference?
J JE McGimpsey Apr 7, 2007 #3 Did you look at Help? See the "The difference between relative and absolute references" subtopic in the "About cell and range references" topic.
Did you look at Help? See the "The difference between relative and absolute references" subtopic in the "About cell and range references" topic.
L L. Howard Kittle Apr 8, 2007 #4 After following Don's & JE's advice take a look at the F4 key when entering references. HTH Regards Howard
After following Don's & JE's advice take a look at the F4 key when entering references. HTH Regards Howard
C challa prabhu Apr 10, 2007 #5 Hi, Check this "Switch between relative, absolute, and mixed references" in the on-line help. It will give a lot of clarity in understanding and using this treminology. Challa Prabhu
Hi, Check this "Switch between relative, absolute, and mixed references" in the on-line help. It will give a lot of clarity in understanding and using this treminology. Challa Prabhu