Naming cells and clicking cells to retrieve cell name in formula
I like using libreoffice’s Calc but one feature that is in Excel but not in Calc is that you can name a cell and enter a formula in another cell by clicking on the named cell.
A1 contains 5
B1 contains 10
A1 named five
B1 named ten
You click on C1, type =, and click on A1, press +, click on B1
In Excel it will display:
In Calc it will display:
I want to keep it with the named cells. I can do so if I manually type it out but it would be easier if I could click on the cell and have it retrieve the cell’s name instead of the cell’s original reference.
How do I do this? Is there an option?