Locking rows in Microsoft Excel is a helpful characteristic that helps shield the information in these rows from being by accident modified or deleted. Locked rows can nonetheless be seen and edited, however they require the consumer to first unlock them. This may be useful for stopping unintended modifications to vital information, similar 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, test the field subsequent to “Locked” and click on “OK.” The row or rows will now be locked.
