Can you lock just formulas in Excel?

Protect and hide formulas

First, select the cells with formulas you want to hide and protect, cells E4:E7 in our example sheet. Right-click the selection and choose Format Cells from the resulting submenu. In the resulting dialog, click the Protection tab. Check the Hidden option (Figure C), and then click OK.

How do I lock a formula in a single cell in Excel?

For locking the cell reference of a single formula cell, the F4 key can help you easily. Select the formula cell, click on one of the cell reference in the Formula Bar, and press the F4 key. Then the selected cell reference is locked.

How do I lock a formula in Excel but allow input?

How do I lock an F4 formula in Excel?

How do I hide a formula in Excel 2016 without protecting sheet?

Right-click on then select “Format Cells” from the popup menu. When the Format Cells window appears, select the Protection tab. Uncheck the “Locked” checkbox. Click on the OK button.

How do I lock cells in Excel without F4?

Laptop keyboards are smaller than stationary ones so typically, the F-keys (like F4) are used for something else. This is easily fixed! Just hold down the Fn key before you press F4 and it’ll work.

What does F4 do in Excel formula?

When you are typing your formula, after you type a cell reference – press the F4 key. Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities.