This way, you can protect your data in the worksheet from being modified or lost. Go back to the Protection tab and checkmark the locked check box. Excel will select all the formulas in the sheet. While this isn’t an issue in most cases, but if you don’t want the formula to be visible, you need to hide it. On the Protection tab, uncheck the locked checkbox and then click OK. The way in which you go about locking those cells really depends on how many you plan to lock. However, if that cell is selected, the formula in the cell would be visible in the formula bar. Lock certain cells in a spreadsheet If you plan to share your spreadsheet and only want participants to be able to edit specific cells, this is easy to do.
0 kommentar(er)
