A Quick way?

[UpTheArgyle]

Does anyone know of a quick way to make all of the following exact cell referances, without clicking 13 times and pressing F4 13 times?

Looks like this

=STDEV(K5,K355,K705,K1055,K1405,K1755,K2105,K2455,K2805,K3155,K3505,K3855,K4205)


Wants to look like this

=STDEV($K$5,$K$355,$K$705,$K$1055,$K$1405,$K$1755,$K$2105,$K$2455,$K$2805,$K$3155,$K$3505,$K$3855,$K$4205)


Thanks

 

[rs2k]

Could you create a named range?

Highlight each cell that you want, then 'Insert>Name>Define' and give them a name, say 'MyRange'

Then your formula would be;

=STDEV(MyRange)

I've just tried it with a sum formula and it worked for me,

HTH
Colin

 

[Fazza]

CTRL-H to find K & replace all by $K$

Maybe pick the cell of interest & 1 other first: not just one cell if you don't want all worksheet cells to change.

HTH

 

[RoryA]

Select the whole formula in the formula bar and press f4.

 

[rs2k]

rorya wins...

I like that one