How to hide the display of formula in Google Sheets?
Web Applications Asked by Prodip on November 12, 2021
How to hide the display of formula in a protected range of Google sheet? In Excel, I can do that, but in Google sheet not finding any function. Please help.
One Answer
The shortcut key for hiding/unhiding of the formula is:
The formula for showing formula is:
FORMULATEXT(A5)
If you want to hide actual formulas in sheet from other people, create a new spreadsheet and use IMPORTRANGE
=IMPORTRANGE("ID_OR_URL_OF_ORIGINAL_SPREADSHEET", "Sheet1!A:Z")
Answered by user0 on November 12, 2021
Add your own answers!
Ask a Question
Get help from others!
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?
Recent Answers
- Joshua Engel on Why fry rice before boiling?
- haakon.io on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Jon Church on Why fry rice before boiling?
- Peter Machado on Why fry rice before boiling?