In the below link, I have made a simple example where A1=1, A2=2 and A3=3 and then at A5 the formula "=A1+A2+A3" is written.
What I now wonder, is there any special keyboard shortcut or icon-shortcut which would change view on the "Input line" so that the view changes from "formula mode = normal mode" to "numeric mode" (i.e. it shows values of the references... it would then show "=1+2+3" instead.)
I do not know if this function exist, and if it does not it would be super if it could be implemented. Spreadsheet is a very powerful tool, but when you are using a lot of references, it would really help if you could switch between "formula mode" and "numerical mode"...
Thanks in advance!