Now the worksheet is protected, and the cell formatting is not changed. Please specify and conform your password in the Protect Sheet and Confirm Password dialog boxes. Now go to click Review > Protect Sheet.Ĥ. In the Format Cells dialog box, uncheck the Locked box under the Protection tab, and then click the OK button. Select the cells you need to protect their formatting but only allow data entry, then press Ctrl + 1 keys simultaneously to open the Format Cells dialog box.Ģ. Protect cell formatting but only allow data entry with Kutools for Excelįor protecting cell formatting but only allow data entry, you need to unlock these cells firstly, and then protect the worksheet. Protect cell formatting but only allow data entry with VBA code Protect cell formatting but only allow data entry by protecting worksheet
This article provides three methods to achieve it. In many cases, you may need to protect the formatting of a range of cells and only allow data entry in Excel. How to protect cell formatting but only allow data entry in Excel?
