682
Chapter 24 Excel Essentials
Clipboard when filling in forms. Also, if any cell contains a formula as well as a data-
validation rule, Excel ignores the rule.
If you want to triple-check the values in cells protected by data-validation rules to make sure
they’re correct, use the Go To dialog box. Press F5 and click the Special button, and then
select the Data Validation option. Click All to see all cells with data-validation rules, or
Same to see only cells whose rules match the currently selected cell.
Secrets of the Office Masters: Beware of Undo
Like all Office applications, Excel includes an Undo button and a corresponding keyboard
shortcut—Ctrl+Z. ...