Thank You Chip you just made everything easier for me

"Chip Pearson" wrote:


If you don't want part of a reference to change, put a $ character
before that part of the reference. Excel won't change it when you copy
it down. E.g.,

=$G$4 change neither row nor column
=G4 change both row and column
=$G4 change row but not column
=G$4 change column but not row

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 18 Oct 2008 14:10:00 -0700, ed
wrote:

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