Adil has attended:
Excel Introduction course
Absolute Refs
i'm not sure how to practically apply this function..
But i'm taking the intermediate course,next week
RE: Absolute Refs
Hi Adil
Thanks for the post - sorry my reply is late
All you need to remember is how to put in $ signs and why
How is by pressing the F4 function key until you place the $ signs where you need them
Why - is because you want to always calculate with a cell or part of a spreadsheet
EG: $d$4 = cell, d$4 = row, $d4 = Colunm
Hope this helps
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn