Lock a range of data on Excel spreadsheets

After you have finished processing data in Excel spreadsheets, sometimes for some reason you do not want others to edit the data of a range of data in Excel spreadsheets.

After you have finished processing data in Excel spreadsheets, sometimes for some reason you do not want others to edit the data of a range of data in Excel spreadsheets. You are trying to lock the important data area but can not lock it.

The following article shows how to lock the data area on Excel worksheet, you do as follows:

Step 1: Open the sheet containing the data area to lock, then select all the sheets by pressing Ctrl + A. Then right-click and select Format Cells .

Picture 1 of Lock a range of data on Excel spreadsheets

In the Format Cells dialog box, select the Protection tab and uncheck Locked and click OK .

Picture 2 of Lock a range of data on Excel spreadsheets

Step 2: Select the data area to lock, then right-click and select Format Cells .

Picture 3 of Lock a range of data on Excel spreadsheets

Reappears the Format Cells dialog box, select the Protection tab , select Locked and click OK .

Picture 4 of Lock a range of data on Excel spreadsheets

Step 3: You can choose Review -> Protect Sheet (or Home -> Format -> Protect Sheet ).

Picture 5 of Lock a range of data on Excel spreadsheets

The Protect Sheet dialog box appears, enter the password in the Password to unprotect sheet box -> OK .

Picture 6 of Lock a range of data on Excel spreadsheets

Confirm the password in Reenter password to proceed -> OK .

Picture 7 of Lock a range of data on Excel spreadsheets

So your data area is locked, to unlock you go back to Review -> Unprotect Sheet (or Home -> Format -> Unprotect Sheet ) then enter the password into the Unprotect Sheet dialog box and click OK to open. Data area lock.

Picture 8 of Lock a range of data on Excel spreadsheets

Thus, with very simple actions, you can quickly lock the necessary data area so that other people cannot edit the data in it. But you need to remember the password to unlock when you need to fix it. Good luck!

Update 19 May 2020
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile