How to protect some cells in a worksheet
How to protect some cells in a worksheet
(OP)
I want to protect some cells of my spreadsheet not the whole worksheet. I want my spreadsheet in a way that, even though it is copied to another sheet, only the values will be pasted not the formula. How can I do that? Thanks!





RE: How to protect some cells in a worksheet
To protect part of a spreadsheet:
1 - Use format / cells / protection and check locked or hidden. Make sure the other cells are not protected or hidden.
The protection is not in place yet. First you need...
2 - Tools/Protection/Protect-sheet or Protect-workbook
To allow someone to copy only the results and not the formula, I think you need to allow them to see only the results and not the formula. Put the formula in some part of the workbook which will later be hidden. In the cell the user will have access to, just add the value of that hidden cell to display it. Then hide that cell so the user can't get to it. I think this will work.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: How to protect some cells in a worksheet
RE: How to protect some cells in a worksheet
RE: How to protect some cells in a worksheet
To set the hidden property use the format:cells menu item to open the "Format Cells" dialogue. Then select the protection tab. To hide formulae ensure that hidden is checked.
HTH
RE: How to protect some cells in a worksheet
Excel also allows the use of an image of another sheet within a sheet. This can be used where you want to show cells in a layout that do not match the layout of the sheet.