Absolute Reference

I have calculated salary for one employee using =$A$2* 45 %. Now I want to
drag this for all employees, but Fill Handle does not work
Please help me

Good afternoon Aziz

Take the $ signs out so the formula references just A2 rather than A$2$ (or only make the column absolute ($A2) and then copy it down.

HTH

DominicB

hi,

Just remove the $ sign

"Aziz" wrote:

> I have calculated salary for one employee using =$A$2* 45 %. Now I want to
> drag this for all employees, but Fill Handle does not work
> Please help me
>