Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Relative vs absolute references in formulas | Excel forum
Resolved · Low Priority · Version 2003
Lucia has attended:
Excel Introduction course
what is a quick way to figure out whether to use one or the other?
Dear Lucia
Thank you for attending Excel Introduction course. I hope you enjoyed the course and have benefited from it.
The best way to figure out if you need to use relative or absolute referencing then simply start with the relative referencing and copy the result to other cell. If you expected the one of the cell to remain same then you go back to the original formula and make the relevant cell Absolute.
I hope this helps!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007
|
Excel tip:Editing a formula quicklyIf you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key |
We'll call during UK business hours
Server loaded in 0.07 secs.