Locking rows in Microsoft Excel is a helpful characteristic that helps defend the info in these rows from being by chance modified or deleted. Locked rows can nonetheless be seen and edited, however they require the person to first unlock them. This may be useful for stopping unintentional adjustments to essential information, corresponding to formulation or headings.
To lock a row in Excel, merely choose the row or rows you wish to lock, then right-click and choose “Format Cells.” Within the “Safety” tab, examine the field subsequent to “Locked” and click on “OK.” The row or rows will now be locked.
