Excel 2019 Bible

613 C H A P T E R 26 Using Data Validation IN THIS CHAPTER Getting an overview of Excel’s data validation feature Looking at pra ...

Part IV: Managing and Analyzing Data Excel makes it easy to specify the validation criteria. You can also use a formula for more ...

Chapter 26: Using Data Validation 26 Select the Settings tab. Choose an option from the Allow drop-down list. The contents of t ...

Part IV: Managing and Analyzing Data List The user must choose from a list of entries that you provide. Type a comma-separated l ...

Chapter 26: Using Data Validation 26 FIGURE 26.3 Excel can draw circles around invalid entries (in this case, cells that contain ...

Part IV: Managing and Analyzing Data FIGURE 26.4 This drop-down list (with an Input Message) was created using data validation. ...

Chapter 26: Using Data Validation 26 Using Formulas for Data Validation Rules For simple data validation, the data validation fe ...

Part IV: Managing and Analyzing Data FIGURE 26.5 Entering a data validation formula On the Error Alert tab, choose Stop for the ...

Chapter 26: Using Data Validation 26 Generally, when entering a data validation formula for a range of cells, you use a referenc ...

Part IV: Managing and Analyzing Data Accepting nonduplicate entries only The following data validation formula does not permit t ...

Chapter 26: Using Data Validation 26 Accepting text that begins with a specific character The following data validation formula ...

Part IV: Managing and Analyzing Data FIGURE 26.7 Using data validation to ensure that the sum of a range does not exceed a certa ...

Chapter 26: Using Data Validation 26 This worksheet uses three named ranges: Vegetables: A2:A15 Fruits: B2:B9 Meats: C2:C5 Cell ...

Part IV: Managing and Analyzing Data Making suggested entries The default Style value on the Error Alert tab of the Data Validat ...

627 C H A P T E R 27 Creating and Using Worksheet Outlines IN THIS CHAPTER Introducing worksheet outlines Creating an outline Wo ...

Part IV: Managing and Analyzing Data FIGURE 27.1 A simple sales summary with subtotals FIGURE 27.2 The worksheet after creating ...

Chapter 27: Creating and Using Worksheet Outlines 27 can partially expand the outline to show the detail for a particular region ...

Part IV: Managing and Analyzing Data If you create both a row outline and a column outline in a worksheet, you can work with eac ...

Chapter 27: Creating and Using Worksheet Outlines 27 entering data from scratch, the most flexible approach is to enter it in a ...

Part IV: Managing and Analyzing Data You can include time-based information that is rolled up into larger units (such as months ...