TransWikia.com

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:

0


The formula for showing formula is:

FORMULATEXT(A5)

0


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!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP