You can use Alt+R+P+S key or Alt+H+O+P to access the ‘Protect Sheet’ tiny window. Default settings are OK to proceed. Go to ‘Review’ Tab > ‘Changes’ Group > Protect Sheet.Select the ‘Locked’ and ‘Hidden’ and click the ‘OK’ button.Select the range containing formulas to hide.Remove the selection against “Locked” as well as “Hidden” and click the ‘OK’ button.Hide Active Cells’ Formulas Appearing on Formula Bar – Excel It will be useful for you at some point in the future and also will help you understand what I meant by hiding formulas. I mean when you copy formula between two different spreadsheet applications, first reveal the formula using the above shortcut key, then copy and paste.īefore going to tell you how to hide formulas in Google Sheets in the real sense, let me explain the Excel steps first. When you copy formulas in this way, you can paste the formula instead of value. When we talk about the awesome “Ctrl+~” shortcut key, it is very useful to copy and paste formulas from Excel to Google Sheet or vice versa. Before that, I should explain the usefulness of the “Ctrl+~” key. I’m talking about the Excel > Format Cell > Protection > Hidden which will fully hide the view of formula from a cell or a range of cells.Įven if someone selects a cell containing a formula, they can’t see the formula in the formula bar. This is only useful to reveal the formula instead of formula results in a spreadsheet. The above is available both in Excel as well as in Google Sheets. I’m not talking about hiding or unhiding formulas using the keyboard shortcuts “Ctrl+~”. But there is a tricky way to do that with a workaround. By default, at the time of writing this Google Sheet tutorial, there is no solution to hide formulas in Google Sheets similar to Excel.

How to show hidden text in google docs