Transfering data into locked spreadsheet

[Tim Miser]

Hello all, I need some help on how to transfer data into a protected
spreadsheet. Copy and paste is not working because there are some locked
cells in-between the cells I am trying to paste. Here is an example:

A B C
1 P 0 P
2 0 P 0
3 P 0 P

P=Protected cell
0=Unprotected cell where I'm trying to paste data into

My problem is that I can paste data only when the cells are together and
there are no protected cells between them.

Can anyone tell me if there is a way to paste or move the data into the
above cells without having to enter data into each cell manually?
Unfortunately, I can't unprotect the spreadsheet because it's password
protected.

Thank you for your assistance.

-Tim

 

[Dave Peterson]

You have more responses to your other post.

Hello all, I need some help on how to transfer data into a protected
spreadsheet. Copy and paste is not working because there are some locked
cells in-between the cells I am trying to paste. Here is an example:

A B C
1 P 0 P
2 0 P 0
3 P 0 P

P=Protected cell
0=Unprotected cell where I'm trying to paste data into

My problem is that I can paste data only when the cells are together and
there are no protected cells between them.

Can anyone tell me if there is a way to paste or move the data into the
above cells without having to enter data into each cell manually?
Unfortunately, I can't unprotect the spreadsheet because it's password
protected.

Thank you for your assistance.

-Tim