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. 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 .
In the Format Cells dialog box, select the Protection tab and uncheck Locked and click OK .
Step 2: Select the data area to lock, then right-click and select Format Cells .
Reappears the Format Cells dialog box, select the Protection tab , select Locked and click OK .
Step 3: You can choose Review -> Protect Sheet (or Home -> Format -> Protect Sheet ).
The Protect Sheet dialog box appears, enter the password in the Password to unprotect sheet box -> OK .
Confirm the password in Reenter password to proceed -> OK .
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.
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!
You should read it
- How to protect spreadsheets in Excel
- Add captions to spreadsheets in Excel 2013
- Tips with spreadsheets (sheet) in Excel
- Lock one or more data columns on Excel worksheet - Freeze data in Excel
- How to open multiple spreadsheets side by side in Excel 2013
- Steps to lock columns in Excel
- Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
- How to fix formulas in Excel, fix data ranges in Excel
- Instructions for formatting data in Excel
- 5 source to get macro to automate Excel spreadsheets
- Extract Excel content into image format
- How to lock Excel Sheet, set a password for the sheet in Excel
Maybe you are interested
How to get data from web into Excel
What information does a VPN hide? How does it protect your data?
How to transfer data between 2 Google Drive accounts
6 Data Collecting Apps You Need to Delete for Better Privacy
How to master numerical data in Google Sheets with the AVERAGE function
How to delete white space in a table in Word - Appears right below the data