How to Make Excel Read Only

How To Make an Excel File Read Only
Excel is a powerful tool for data management, and it's often necessary to protect your spreadsheets from being modified accidentally or intentionally. One way to do this is to make your Excel file read-only. You can also make it password protected which will allow you to control who can read and modify. Here's how to make Excel read-only and password Protected:
*Step 1: * Open the Excel file you want to make read-only.
*Step 2: * Click on the "File" tab in the top-left corner of the screen.
*Step 3: * Click "Save As" in the list of options.
*Step 4: * Choose a location to save the file, and give it a name if you haven't already.
*Step 5: * Click on the "Tools" dropdown menu located at the bottom of the Save As dialog box.
*Step 6: * Click on "General Options".
*Step 7: * Now write the “Password to Open” and “Password to Modify” and Re-enter them again sequentially.
*Step 8: * Check the box that says "Read-only recommended".
*Step 9: * Click "OK" to save the changes.

Now, whenever someone opens the file, they'll see a message asking for “Password to Open”. Once the password is given excel will recommend that they open the file as read-only. If you want to modify the file, you’ll need to enter the “password to Modify”. Now they are allowed to modify the file otherwise it will be read only.


#ReadOnly #Excel #PasswordProtect #ExcelTips
Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
Patreon: excel10tutorial
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://bit.ly/2UngIwS

Playlists:

Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Intermediate Excel Tutorial: https://tinyurl.com/59a837py
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Text Case Conversion Techniques: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
All About Comments in Excel: https://bit.ly/excelcomments
Excel VBA Programming Course: http://bit.ly/excelvbacourse
ChatGPT Excel Mastermind: https://tinyurl.com/46kn7tmd

Social media:
Facebook: Facebook: excel10tutorial
Twitter: Twitter: excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: Tumblr: excel10tutorial
Instagram: Instagram: excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial
Quora: https://bit.ly/3bxB8JG
Website: https://msexceltutorial.com/

• #education
• #excel_10_tutorial
• #excel_tutorial
• #excel
• #tutorial
• #microsoft_excel
• #excel_2019
• #excel_tricks
• #excel_tips
• #msexceltutorialcom
• #ms_excel_tutorial
• #how_to_make_excel_read_only
• #make_an_excel_file_read_only
• #make_an_excel_workbook_read_only
• #read_only_excel_file
• #read_only