When we will enter any text in the cell, it will never change the formula and a pop up will appear. Settings > Allow > Custom & Formula > =””.Or use ALT + D + L shortcut keys for Data Validation.
Now, we want to protect all those cells in which formulas are applied. We have data in which some cells are containing the formula for the calculation purpose. Let’s take an example and understand how we can protect the formula containing cells. If you favor, you can allow users to enter invalid data & display a warning message when they enter data in the cell.
You can prevent users from entering data that is not valid. In this article, to protect cells containing formula in an unprotected sheet, we will use Data validation option.ĭata validation is an awesome feature of Excel that you can use to describe limitations or restrictions on what type of data can be used in a cell.
