Excel 2010 Bible

Chapter 31: Protecting Your Work 639 Unlocking cells In many cases, you will want to allow some cells to be changed when the wor ...

Part IV: Using Advanced Excel Features 640 FIGURE 31.3 Excel warns you if you attempt to change a locked cell. Sheet protection ...

Chapter 31: Protecting Your Work 641 Assigning user permissions Excel also offers the ability to assign user-level permissions t ...

Part IV: Using Advanced Excel Features 642 To add a password to a workbook, follow these steps: Choose File ➪ Info ➪ Protect Wo ...

Chapter 31: Protecting Your Work 643 Excel provides another way to add a password to a document: Choose Office ➪ Save As. In th ...

Part IV: Using Advanced Excel Features 644 FIGURE 31.7 The Protect Workbook dialog box. Protecting a workbook’s windows To preve ...

Chapter 31: Protecting Your Work 645 Enter a password (twice). Click OK and then save your file. When the file is closed and th ...

Part IV: Using Advanced Excel Features 646 Note Only the active sheet is saved. If your workbook has multiple sheets, you must s ...

Chapter 31: Protecting Your Work 647 FIGURE 31.9 The Document Inspector dialog box identifies hidden and personal information in ...

Part IV: Using Advanced Excel Features 648 FIGURE 31.10 This document has a digital signature. To add an invisible digital signa ...

649 CHAPTER Making Your Worksheets Error-Free IN THIS CHAPTER How to identify and correct common formula errors Using Excel audi ...

Part IV: Using Advanced Excel Features 650 l (^) Semantic errors: An example is a function name that is spelled incorrectly. Exc ...

Chapter 32: Making Your Worksheets Error-Free 651 Tip Excel can help you out with mismatched parentheses. When you’re editing a ...

Part IV: Using Advanced Excel Features 652 For example, the following formula returns the number of nonempty cells in range A1:A ...

Chapter 32: Making Your Worksheets Error-Free 653 Formulas returning an error A formula may return any of the following error va ...

Part IV: Using Advanced Excel Features 654 FIGURE 32.2 #DIV/0! errors occur when the data in column C is missing. This formula c ...

Chapter 32: Making Your Worksheets Error-Free 655 The #N/A error also occurs when a LOOKUP function (HLOOKUP, LOOKUP, MATCH, or ...

Part IV: Using Advanced Excel Features 656 #REF! errors A #REF! error occurs when a formula uses an invalid cell reference. This ...

Chapter 32: Making Your Worksheets Error-Free 657 Absolute/relative reference problems As I describe in Chapter 10, a cell refer ...

Part IV: Using Advanced Excel Features 658 Notice that the negation operator symbol is exactly the same as the subtraction opera ...