Cells with formulas in Google Spreadsheets display the answers to all formulas and functions in the worksheet, not the formula or function itself.
Little trick to hide your formulas in Google Sheets!
In large spreadsheets, it can be difficult to find cells that contain formulas or functions. Learn multiple ways to display formulas in Google Sheets to find the method that best suits your purposes.
You no longer have to guess when it comes to viewing formulas in Google Sheets. Use a simple keyboard shortcut to view all formulas in Google Sheets: Ctrl+` (grave accent).
This key combination acts like a toggle in Google Sheets, meaning that you can press the same key combination again to hide the formulas when you're done viewing them. The worksheet will display all of the formulas in the cells they're in, instead of the formula results.
