1. Select the range of cells, table, or PivotTable for which you want to clear
conditional formats.
2. On the Home tab, in the Styles group, click the arrow next to Conditional
Formatting, and then click Clear Rules.
3. Depending on what you have selected, click Selected Cells, This Table.
Protect worksheet or workbook elements
To Prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can protect certain worksheet or workbook elements, with or without a password.
Protect worksheet elements
When you protect a worksheet, all cells on the worksheet are locked by default, and users cannot make any changes to a locked cell. For example, they cannot insert, modify, delete, or format data in a locked cell. You can, however, specify which elements users will be allowed to change when you protect the worksheet.
1. Select the worksheet that you want to protect.
2. To unlock any cells or ranges that you want other users to be able to change, do the following:
· Select each cells or range that you want to unlock.
· on the Home tab, in the cells group, click Format, and then click Format Cells
· On the Protection tab, clear the Locked check box, and then click OK.
3. To hide any formulas that you don't want to be visible, do the following:
conditional formats.
2. On the Home tab, in the Styles group, click the arrow next to Conditional
Formatting, and then click Clear Rules.
3. Depending on what you have selected, click Selected Cells, This Table.
Protect worksheet or workbook elements
To Prevent a user from accidentally or deliberately changing, moving, or deleting important data, you can protect certain worksheet or workbook elements, with or without a password.
Protect worksheet elements
When you protect a worksheet, all cells on the worksheet are locked by default, and users cannot make any changes to a locked cell. For example, they cannot insert, modify, delete, or format data in a locked cell. You can, however, specify which elements users will be allowed to change when you protect the worksheet.
1. Select the worksheet that you want to protect.
2. To unlock any cells or ranges that you want other users to be able to change, do the following:
· Select each cells or range that you want to unlock.
· on the Home tab, in the cells group, click Format, and then click Format Cells
· On the Protection tab, clear the Locked check box, and then click OK.
3. To hide any formulas that you don't want to be visible, do the following:
No comments:
Post a Comment