วันศุกร์ที่ 16 ธันวาคม พ.ศ. 2554

Excel security single cell

You can protect specific cells in Office Excel?

Excel security single cell

Question :

You can block a single cell without blocking the whole page?

Or three people use three different sheets individually protected, all accumulate on a single page and everything works just right can change the paper. However, if for example I put a cell with a number I wish it were not editable, or would like to protect only that cell.

Answer :

You select the cells that are used to enter data, in practice the editable ... Then go to the Format Cells menu and Protection then disable the flag where it says Block .

Then protect the sheet Protection Tools and enable Protect Sheet .

The sheet is protected throughout with the exception of cells that had unlocked.

Then if I want to also protect the entire file with another password .... In practice, even opening the files you can edit only the cells that I had selected.

See Pictures and Read more : Excel security single cell

ไม่มีความคิดเห็น:

แสดงความคิดเห็น