protect

How to lock cells in Excel 2013 : Excel Tutorial

0:00
Toggle fullscreen Fullscreen button

Sharing buttons:

hi friends do you want to protect the

cells of an Excel 2013 worksheet from

being edited you need to lock the cells

to do so here's how open Excel 2013 open

the Excel workbook whose cells you want

to lock select all the cells of that

workbook right click and then click on

format cells click on the protection tab

uncheck the checkbox next to locked and

then click on OK now right-click on the

cell you want to lock and then click on

format cells click the protection tab

select the check box next to locked and

then click on OK to protect the sheet

right-click on a worksheet tab click

protect sheet enter a password check the

actions you want to allow the users of

your worksheet to perform if you won't

check any action the users can only view

the excel file click on OK re-enter the

password to proceed and then click on OK