Question:
Can I set any particular cell in a read only sheet for Editable in a Excel Sheet?
Answer:
Yes, It is possible by using "Allow Users to Edit Ranges" link on Excel. We Provide you step by step process of Editable cell in a read only sheet.
First we sure that your Sheet is not a read only on the time of using this process. Process is given below:
- go to Review tab => Changes => Allow uses to Edit Ranges
- In Allow users to Edit Ranges Click on New Button
- On New Range window and fill the detail.
Title: Give the Title as you want,
Refers to cells: Give the Cell name that you want to allow for Editing
Range Password: If we want to edit range with password.
and the click OK Button.
- Now Click on Permissions Button on Allow uses to Edit Ranges Window.
Now click on add Button.
- Enter your Computer user name for permission or Write "Everyone" on "Enter the object name to select" and click on "Check Names" Button.
and click OK Button.
- Now use Apply and OK Button to all opened window.
- Now go to Review tab => Changes =>Protect Sheet
- Now Click OK Button.
- that's it your all sheet cell is read only except your range that you want.