hi guys,
suppose i've used a formula for cell C18 and the formula is =A3*D3/E3 . now if i drag the cell C18 to copy the formula in for the cell C19, the formula will become =A4*D4/E4 automatically. but i dont want cell reference of E3 to change in the formula. so i want my formula to be =A4*D4/E3.
So are there any ways to fix the cell reference of E3 in the first formula so that when i drag the formula, every other reference will change accordingly except E3?
Bookmarks