i have excel 2003 and am learning how to use it i have written a formula
and am using g4 as constant part of the formula .when i try to copy the
formulato the rest of the column g4 changes to g5, g6 ,g7 how do i keep g4 as
constant?

example the formula is =g4*a7*4
when i copy to cell directly below the formula changes to g5*a7*4