Locking cells in a Microsoft Excel spreadsheet is a super useful thing to know how to do. It’s used to protect a certain segment or an entire worksheet from being modified by anyone other than ...

In Microsoft Excel, each cell is locked automatically. In enabling protection of a spreadsheet, it will often be faster to unlock everything and then re-enable the lock on chosen cells.

Steps to freeze multiple rows in Excel. Click on the cell in column A of the row immediately below the rows you want to lock. For example, if you wish to lock rows 1 and 2, you should click on ...