build absolute cells in formulas on mouse click

[jmwismer]

Hi there,

When one creates a cell formula by selecting various cells with th
mouse, all cells selected with the mouse appear in the formula a
relative coordinates. Is there some way to make some mouse cel
selection appear absolute? here is what I mean:

Say I want to make A1=B1+$C$1

While creating A1, I click B1, "+", click C1 which gives me A1=B1+C1
I would like for instance click B1, "+", shift-click C1 and ge
A1=B1+$C$1

thx,
j

 

[SamuelT]

In the formula bar, if you click in C1 and press F4, you'll get the sam
result. It's nearly as good

 

[jmwismer]

thx!

does it even without interrupting the flow of mouse cell selection.

easy one.