Lock Excel Formatting

How to Lock Cells and Protect Worksheets in Excel

Lock Excel Formatting. Select the cells you need to protect their formatting but only allow data entry, then press ctrl + 1 keys simultaneously to open.

How to Lock Cells and Protect Worksheets in Excel
How to Lock Cells and Protect Worksheets in Excel

Select the cells you need to protect their formatting but only allow data entry, then press ctrl + 1 keys simultaneously to open.

Select the cells you need to protect their formatting but only allow data entry, then press ctrl + 1 keys simultaneously to open. Select the cells you need to protect their formatting but only allow data entry, then press ctrl + 1 keys simultaneously to open.