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.
Google-sheets – How to hide the display of formula in Google Sheets
formulasgoogle sheetskeyboard shortcuts
Related Topic
- Google Sheets – Keyboard Shortcut to Select Whole Column During Formula Entry
- Google-sheets – Formula not working on Google Sheets #error! Formula Parse Error
- Google-sheets – Auto hide row based on cell text (formula based)
- Google Sheets Formulas – How to Add a Note or Comment
- Google-sheets – 3D Formula Google Sheets – sum across sheets
Best Answer
The shortcut key for hiding/unhiding of the formula is:
The formula for showing formula is:
If you want to hide actual formulas in sheet from other people, create a new spreadsheet and use
IMPORTRANGE