How to lock cells in Excel Open the Excel workbook and select all cells in the worksheet with the cells you want to lock by pressing the Ctrl + A buttons on your keyboard.

Excel selects the contiguous rows adjacent to the clicked cell, D5, which happens to be A3:E6 — a partial selection. The blank cells in rows 7 and 10 make it impossible to quickly select this ...

You’ll see that Excel made a non-adjacent selection of all the blank cells in the spreadsheet. This makes it easy to delete the cells you don’t want. After having done this, from the Home tab ...