• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HOW TO DISABLE/INACTIVE THE EMPTY CELLS IN A SPREADSHEET

Raj Lalwani

New Member
I am doing my thesis wherein I am preparing an excel based model. I want the user of this model to enter text in specific cells and lock rest of the cells in the sheet.
I have attached an excel file in which similar thing is done. Please help me on how to do that. I have tried Protect Sheet and Allow Users to Edit Range options, but this didn't give the desired output. Please download the attached excel file for better understanding.
 

Attachments

  • csv2gsi_v42.xlsx
    851.4 KB · Views: 5
What is Your the desired output?
Screen Shot 2017-03-10 at 10.06.41.png
... is there always three rows?
If Yes, then You could protect those cells too...
 
Back
Top