build absolute cells in formulas on mouse click

[jmwismer]

Hi there,

When one creates a cell formula by selecting various cells with the mouse, all cells selected with the mouse appear in the formula as relative coordinates. Is there some way to make some mouse cell 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 get A1=B1+$C$1

thx,
jm

[SamuelT]

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

[jmwismer]

thx!

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

easy one.