Discussion Groups Home

Excel: hold a reference to a single cell when copying formulas? in Excel Worksheet Functions

5/18/2005 7:53 AM PST

Question

	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?

Was this post helpful to you?

5/18/2005 8:14 AM PST

Answer

	Did you remember to use the $ for both Column and Row? ie $A$5 vs. $A5 HTH, -- Gary Brown gary.DeleteThis2SendMeAnEmail.Brown@kinneson.com "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? > >

Was this post helpful to you?

	Return to Microsoft Communities		Notify me of replies