Force change

M

MrJim005

When copying formulas, the $ sign stops excel from changing to the next
column letter. Is there a symbol to force excel to change to the next
letter?



Thank You
 
R

Ron Coderre

When editing the cell....if you remove any of the dollar signs that will
"unlock" that part of the reference.

For more information search Excel Help for "range reference"
and read the topic: About cell and range references"

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Top