I know this sounds to simple but i can't absolute a cell in excel anyone guide me through it please

I take it by 'not able to do absolute referencing', you mean you do not know the syntax of using it. I am assuming you know the difference between absolute and relative referencing.

Relative = A1

Absolute = $A$1

You can mix them;

A$1 = 'A' (the column) is relative '1' (the row) is absolute. The column will adjust relative to how far you copy the formulae from left to right, or vice versa), but the row will ALWAYS point to row 1 (it's absolute).

$A1 = 'A' (the column) is absolute. '1' (the row) is relative. The column will ALWAYS point to column 'A' (it's absolute), but the row will adjust relative to how far you copy the formulae up or down the column (it's relative).

When typing the formulae into the formulae bar, pressing F4 will toggle the cell reference between A1,$A$1,A$1,$A1 and back to A1 but you must press F4 immediately after typing the cell reference (it only affect the cell ref immediately to the left of the cursor bar.

Sorry if this reply is a bit long winded, but (as you suggest) it really IS simmply once you have got the grasp of it.

Many thanks for that it was a great help and has cleared things up for me