Login Page - Create Account

Support Board


Date/Time: Sat, 23 Nov 2024 05:25:51 +0000



Post From: spreadsheets. any method to see formulas

[2024-09-17 14:55:30]
User335019 - Posts: 9
Hello there

The only way i know to reach and see a formula is..
1. Go to the cell
2. double click the cell
3. see the formula
4. generally press ">>" and use mouse to enlargen the area to see formula in full.

afterwards go to another cell.
do the same.. but already forgot the previous cell formula :)

a)is there a way to see formula of a cell easily... like pointing mouse on it only

b) Or some way to export "all row 3 formulas as text" to pdf etc
PLEASE NOTE
(save as .txt option is not really readable. either by word or wordpad or notepad
please see attached picture)


İ have all 60 - full formula spreadsheets, many cells reference a cell which reference another cell and even one more deep referencing.
It is insanley hard to follow formula link by going to each cell, double clicking, enlarging and trying to memorize formula and continue to the next cell


Is there a way for easy seeing the formulas that i am unaware of.


(ps i tried copying selected range as formulas or value/formulas options and pasting in excel, but did not work)

Thank you
imagenotepad_S2dPJnrZmu.jpg / V - Attached On 2024-09-17 14:55:25 UTC - Size: 524.24 KB - 32 views