Protecting data
You can prevent users from changing any data in a spreadsheet by protecting spreadsheet cells. You can allow users to edit only specific cells, unlocking specific cells in a protected spreadsheet.
Protecting spreadsheet objects prevents users from moving, resizing, editing, or deleting objects on the active spreadsheet. Protected objects include floating charts and graphic objects, linked and embedded objects using Dynamic Data Exchange or OLE, drawn objects, and form controls. However, if you disable the sheet protection for objects, Quattro Pro ignores the status of unprotected objects.
To protect all spreadsheet cells |  |
|
1.
|
|
Click Format
 Sheet properties. |
|
2.
|
|
Click the Protection tab.
|
|
3.
|
|
Enable the Enable cell locking check box.
|
To unlock a cell in a protected spreadsheet | |
|
1.
|
|
Select a cell.
|
|
2.
|
|
Click Format
Selection properties. |
|
3.
|
|
Click the Constraints tab.
|
|
4.
|
|
In the Cell protection area, enable the Unprotect option.
|
|
•
|
|
You can also unlock a cell by right-clicking the cell, and clicking Selection properties.
|
|
•
|
|
You can select multiple noncontiguous cells by holding down Ctrl and selecting the cells.
|
To protect all spreadsheet objects | |
|
1.
|
|
Click Format
Sheet properties. |
|
2.
|
|
Click the Protection tab.
|
|
3.
|
|
Enable the Enable object locking check box.
|