Monday, 20 October 2014

Allow user to Edit Excel Sheet cell in Read only Sheet

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.
     

Search on This Blog