relative vs absolute references

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Relative vs absolute references in formulas | Excel forum

Relative vs absolute references in formulas | Excel forum

resolvedResolved · Low Priority · Version 2003

Lucia has attended:
Excel Introduction course

Relative vs absolute references in formulas

what is a quick way to figure out whether to use one or the other?

RE: relative vs absolute references in formulas

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 quickly

If 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

View all Excel hints and tips


Server loaded in 0.07 secs.