David Tetard
My feedback

7 votes2 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment David Tetard shared this idea · 
19 votes6 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment David Tetard commentedIf I enter this formula:
= ln(B6+B7)
whith B6 and B7 having been entered automatically by clicking on the corresponding cell, but if I want:
= ln(B6+$B$7) ,
I have to manually edit the formula.What would be nice is for the B7 to be inserted if I click on the cell without the Ctrl key and $B$7 to be inserted if I click on the cell while the Ctrl key is pressed. You could also imagine the Shift key inserting $B7 and the Alt key inserting B$7, this way all combinations are covered.
David Tetard supported this idea ·
To reproduce, try to enter that formula in a cell of coordinated B2 of standard width where all coordinated are entered by clicking on their cells:
=ln(C8+C7+C6+C5+C4+C2)
You won't be able to enter C2 by clicking on that cell (the caret will go in the formula, not insert the cell's coordinates), you will have to manually edit the formula.