The operation can be undone, but it has to be done by the user who did it in the first place. It is also locked to prevent users who do not have permission to work on a document from rewriting data. There is another way to lock a column which can. By default all the cells are locked and you need to protect these cells to prevent changes.
#Lock individual cells in excel how to
Now from the Protection tab of Format Cells, check the box of LOCKED with a tick. In this tutorial, you'll learn how to lock cells in Excel. Then click right anywhere on the selected column and select the Format Cells option from the right-click menu list. Click on OK to apply the changes: Checkbox to lock cellsĪgain, locking a cell means that it is impossible to modify what is written in the cell it is not possible to rewrite or change attributes of the cell, such as formatting.Ĭell locking can be useful in situations where you are working with a large amount of sensitive data, where changing a number or a character by mistake can ruin a huge amount of working hours by changing the final result, and therefore, its interpretation. To lock a column in Excel, we first need to select the column we need to Lock. In this tab, select the Locked check box so that the contents of the selected cells cannot be altered. Freezing rows and columns in Microsoft Excel versions 2013, 2010, and 2007 can be helpful if you want to keep a section of your spreadsheet visible at all times while you move to and work in other sections of your document. This will insert the dollar () symbols in the formula.
the 2nd module will insert 'unlocked' row after the activecell, thus will allow copy paste, with the copied-from-cell still protected. the 1st module will allow protection and insert row. Click E2 in the formula to place the cursor between E and 2. try this: this assumes that ALL cells of the worksheet are 'Locked'. Remove the check mark next to Locked, then click OK. This button will remain each time you use Excel. For the locking of the cells to take effect, you must also protect the worksheet. When the Format Cells window appears, select the Protection tab. Right-click and then select 'Format Cells' from the popup menu. When you select this option, the button will be added to the Quick Access Toolbar at the top of the workbook. Next, select the cell (s) that you wish to protect. Right-click on a selected cell and choose the Format Cells option. If you right-click on the Lock Cell option, another menu appears giving you the option to add the button to the Quick Access Toolbar. Select the cells that you DON’T want to lock. Say you want to lock cell E2 to remain constant as you copy the formula to adjacent cells. Use these steps to lock a cell in Excel 2010. There, go to the Protection tab: Location of the Protection tab Here are some quick steps to lock cells in Excel using this formula: C5D5E2.