Lock Cells Or Specific Areas To Protect. Ctrl A to select all the cells of the sheetRight click and choose Format cellsGo to the Protection tab and uncheck Locked option and click Ok. Locking and protecting multiple rows and cells Similarly if you want to lock and password protect multiple rows or two and more cells then select those rows and cells after unlocking all cellsrows.
To enable some cell editing while leaving other cells locked its possible to unlock all the cells. Now select only the cells or columns rows that you want to protectRight click and choose Format cells again. On the Review tab click Unprotect Sheet in the Changes group.
Lock only specific cells and ranges in a protected worksheet.
Select cells ranges columns or rows you want to protect. After protecting a worksheet by default each and every cell are locked. Unlock specific cells or range of cells. Open an existing worksheet on which you want to lock or unlock particular areas of a protect worksheet in Excel.