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 ...

Once you’ve selected a cell in Excel, this command freezes the rows and columns before the highlighted cell. Step 2: Freeze the top row: Press Alt+W+F+R.

How to lock cells in Excel. 1. Select your whole sheet, done most easily by pressing Crtl + A on your PC keyboard, or Command + A on a Mac.. 2. In the "Home" tab, click on the arrow under ...