![how to lock certain cells in excel worksheet how to lock certain cells in excel worksheet](https://www.exceldemy.com/wp-content/uploads/2018/02/sharing-2.png)
To protect rows in Excel, select them in a similar manner.
![how to lock certain cells in excel worksheet how to lock certain cells in excel worksheet](https://www.repairmsexcel.com/blog/wp-content/uploads/2018/09/Lock-and-Unlock-Cells-Formulas.jpg)
To select non-adjacent cells, select the first cell or a range of cells, press and hold the Ctrl key, and select other cells or ranges. To lock cells or ranges, select them in a usual way by using the mouse or arrow keys in combination with Shift. Select cells, ranges, columns or rows you want to protect.
![how to lock certain cells in excel worksheet how to lock certain cells in excel worksheet](https://support.content.office.net/en-us/media/a78fd1e9-0d9c-41cf-9170-cbe8136bcfff.png)