Excel Instructions to lock cells in a spreadsheet

Posted by Rosslyn T.



Due date
Monday, 10th Sep 2012
Calling all Excel Gurus,

I need to lock selected cells in a spreadsheet, so that some cells can be edited, but the rest of the cells can't be edited (Important: this includes not being able to copy the cells so they cannot be pasted into a new spreadsheet)

I have been able to make locked/unlocked cells in Windows Excel 2010 by selecting which cells to unlock/lock in the Protection Tab in the Format Cells dialogue box , and then using the Protect Sheet dialogue box.... However I find that as soon as I open the protected spreadsheet on a different computer which has an older version of Excel, even though I can't edit the locked cells or individually select them, I can "select all" in the spreadsheet, then copy, then paste into a new spreadsheet. This pastes the entire spreadsheet including the locked cells, which is not acceptable, as they can then be edited.

The file I created can be downloaded from https://[Content Moderated] /download/TEhYTGt[Content Moderated]

I need instructions emailed to me on how to create a spreadsheet with locked cells that cannot be copied/pasted into a new spreadsheet, even if opened in older versions of Excel.

The Airtasker will be paid when I can successfully create a basic sample locked/unlocked spreadsheet (which I cannot copy/paste) by following their instructions.


No offers were made on this task.
Task Activity
50 comments about this Task
Comments are now closed
0 new tasks