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
> 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