Worlds best microsoft office tutorials content. Find anything about microsoft office tutorials needs on this site.
Lock Cells To Protect Them. 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. Full Feature Free Trial 30-day.
How To Lock A Formula In Google Sheets Google Sheets Sheets Google from www.pinterest.com
On the Protection tab select the Locked check box and then click OK to close the popup. On the Home tab in the Alignment group click the small arrow to open the Format Cells popup window. Follow these steps to lock cells in a worksheet.
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.
To prevent other users from accidentally or deliberately changing moving or deleting data in a worksheet you can lock the cells on your Excel worksheet and then protect the sheet with a password. How to lock cells in Excel 1. This means they cant be reformatted or deleted and the content in them cant be edited. On the Protection tab select the Locked check box and then click OK to close the popup.
