Block Out Formula Certificate For Free

In addition to protecting workbooks and worksheets, you can also protect formulas. Excel for the web can't lock cells or specific areas of a worksheet. If you want to lock cells or protect specific areas, click Open in Excel and lock cells to protect them or lock or unlock specific areas of a protected worksheet.

1 Answer. Select the whole sheet, right click and then select Format Cells... . In the popup window, select Protection tab. Unselect both options and press OK button.

Lock cells with formulas. Now, go to lock the selected cells with formulas. To do this, press Ctrl + 1 to open the Format Cells dialog again, switch to the Protection tab, and check the Locked checkbox. The Locked option prevents the user from overwriting, deleting or changing the contents of the cells.

To hide formulas:Select the cells for which you to want to hide the formulas.Right-click the cell (or cells) and choose Format Cells.In the Format Cells dialog box, click the Protection tab.Check the Hidden box. Note: Hidden is what prevents the user from seeing the formula.Click OK.

Making formula results permanent with copying and pasting Select the formula cells you need to make them permanent, then press the Ctrl + C keys simultaneously to copy them. Now the formulas in selected cells are replaced with corresponding results immediately.

Prevent a formula from displaying in the formula barSelect the range of cells whose formulas you want to hide.Click Home > Format > Format Cells.On the Protection tab, select the Hidden check box.Click OK.Click Review > Protect Sheet.More items...

Select the range of cells whose formulas you want to hide.Click Home > Format > Format Cells. On the Protection tab, select the Hidden check box. Click OK.