Pasting to unlocked cells

[koconnell]

Hello, I have a simple question but can't figure it out. I have a sheet with locked cells (a template essentially) and I want to be able to paste data into the unlocked cells of this sheet without unprotecting it however Excel won't allow this. Any help is appreciated. Thanks in advance!

 

[miss_ell]

Hello,

Are you sure that you've unticked the "Locked" checkbox under Format Cells, Protection tab? I've tried it with some sample data and it worked...