Steps to hide the Excel formula Step 1. You can select non-adjacent cells or ranges by holding the Ctrl key or the entire sheet by pressing the Ctrl A shortcut. The reason we need to unlock first is by.
To do this select all of the rows and columns in your sheet.
Go to Home Tab - Editing - Find Select - Go to Special. To check the same go. How to Hide Formulas in Excel 1. Press Control1 or Right-click and select Format Cells.