Copy and Paste a Locked Cell

[dxz156]

Smart People,

This may be the dumbest question ever but, how do I lock a cell so someone can not edit the data or formula but still allow them to copy and paste the cells? I can easily lock a cell but then you can't copy it. People need to be able to paste it into a powerpoint slide.

Thanks!!!

-DXZ

 

[FormR]

I don't have power point at home - but am able to copy and paste a locked cell into word (and other un-locked cells in Excel) without any problems.

 

[Redwolfx]

When you lock the sheet click the option to be able to select locked cells.

 

[Snakehips]

dxz156,

If when you Protect the sheet you have the topmost option 'Select Locked Cells' ticked then the cell will be protected but you will be able to select it and copy /paste it elsewhere.

Hope that helps.

 

[dxz156]

Hahaha thanks! I got it working. Sorry I knew it was a dumb question when I asked it.

 

[Redwolfx]

Glad we could help. Thanks for the Response