Thread
:
Excel: hold a reference to a single cell when copying formulas?
View Single Post
#
1
Gary Brown
Posts: n/a
Excel: hold a reference to a single cell when copying formulas?
Did you remember to use the $ for both Column and Row?
ie $A$5 vs. $A5
HTH,
--
Gary Brown
"Jim in Texas" wrote:
I used to use '$' signs to keep a refererence to a single cell in a formula
but that doesn't seem to work in the new version. How should I do that?
Reply With Quote