![how to protect some cells in excel 2016 how to protect some cells in excel 2016](https://support.content.office.net/en-us/media/a78fd1e9-0d9c-41cf-9170-cbe8136bcfff.png)
The bottom line is that it is virtually impossible to 100% protect the contents of the column so that they cannot be viewed. The contents of the locked and hidden cell are pasted in the unlocked cell. Use F5 to jump to the locked and hidden cell, then press Ctrl+C, move to the unlocked cell, and press Ctrl+V.
![how to protect some cells in excel 2016 how to protect some cells in excel 2016](https://cdn.extendoffice.com/images/stories/doc-excel/lock-cells/doc-lock-cells-2.png)
#How to protect some cells in excel 2016 password
You are prompted to reenter your password (the one from step 8), which you should do.Īt this point someone cannot view what is in the hidden column, even if they use F5 to jump to one of the cells in the column it still won't appear in the formula bar. (These two options are selected by default in a worksheet.) Show Formulas in Excel Instead of the Values.
#How to protect some cells in excel 2016 how to
How to Copy and Paste Formulas in Excel without Changing Cell References. You May Also Like the Following Excel Tutorials: Lock Rows/Columns using Excel Freeze Panes. At a minimum you should choose Select Locked Cells and Select Unlocked Cells. To truly hide formulas in Excel, the cells should have the Locked and Hidden check boxes selected, and then it should be protected.