How to lock Excel files from editing
You want to send an Excel file that can only be read by the recipient and cannot change the data information in the file. In this article, TipsMake.com would like to show you how to lock Excel files from editing correctly.
How to lock Excel files from editing Picture 1
Method 1: Set a password for a certain Sheet in Excel file
Step 1 : You open the Excel file and go to the Sheet page to be secured:
(1) Right-click on a sheet cell.
(2) Select Protect Sheet.
How to lock Excel files from editing Picture 2
Step 2 : Enter the security password and click OK .
How to lock Excel files from editing Picture 3
Step 3 : Confirm the password again. Then click OK.
How to lock Excel files from editing Picture 4
Step 4 : Then you can see the tools are all gray. You cannot edit any parameters or data on this Sheet without a password.
How to lock Excel files from editing Picture 5
To be able to edit this sheet, you put your cursor in the sheet cell then click the mouse to select Unprotect Sheet .
How to lock Excel files from editing Picture 6
For how to lock this sheet page, you can edit the Excel file if there is something wrong. However, there are many ways to break the security code, from there, you can still edit Excel files.
To face that phenomenon, we can install the entire Excel file into Read-only mode through method 2.
Method 2: Set Readonly mode for Excel file
Step 1 : You open the Excel file you want to change the mode. Select File on the toolbar.
How to lock Excel files from editing Picture 7
Step 2 : Then you select Save As and double-click select This PC .
How to lock Excel files from editing Picture 8
Step 3 : Click the Tools sectionin the right corner of the window, then select General Options .
How to lock Excel files from editing Picture 9
Step 4 : Check the Read-only recommended line and select OK .
How to lock Excel files from editing Picture 10
Step 5 : Go back to the Save As window, select a location to save the file, name the file and then select Save .
How to lock Excel files from editing Picture 11
Thank you for watching the article!
You should read it
- Steps to lock columns in Excel
- How to lock PDF files from editing
- Applications that read Excel files on iPhone / iPad quality
- How to use PDF Page Lock to lock PDF files
- Lock cells with formulas in Excel - Lock and protect cells containing formulas in Excel
- Instructions for locking Google Drive files to prevent editing
- How to retrieve unsaved Excel files, restore unsaved Excel files
- How to hide formulas in Excel
- How to create a password protection for Excel sheets
- How to lock formulas in Excel
- How to Copy Secure PDF Files on Windows or Mac Computers
- Lock one or more data columns on Excel worksheet - Freeze data in Excel
May be interested
How to separate text strings by commas or spaces in Excel
How to sort data in Excel Ascending and descending, according to ABC
How to fix word errors in Word are spaced, words are far away in Word
Instructions on how to create input forms in Excel extremely fast and simple
How to cut a PDF file into any small number of pages
How to cross cells in Excel