|
In ths
lesson, you will learn how to:
1. Enter data and fill a series.
2. Enter data in a reference list.
3. Create a drop-down list.
4. Identify options for Data Integrity and Validation.
5. Install the Developer's Ribbon.
6. Create a Control with VBA (Visual Basic for Applications
From the Data Ribbon.
1.
Data ->Data Tools-> Data Validation, page 171
From the Formulas Ribbon.
2.
Formulas ->Defined Names-> Define Name, page 175
From the Developers Ribbon
3.
Developer ->Controls->Insert->Combo Box, page 187
4.
Developer ->Controls ->Properties, page 189 |
|
|
|
