|
![]() |
![]() |
AutoGrow Ranges This lesson will show you how to create an AutoGrow range and do direct data entry. An AutoGrow range is a data entry range that automatically grows when you need to enter more data into it. This lesson will also demonstrate how to do direct data entry rather than using the formula bar at the top of the worksheet window. First, move to cell A2. Open the Label Inspector via the Inspector Icon on the Toolbar. Select the label named Checking by clicking on it in the browser. Click on the check-box marked AutoGrow. You have just designated this range as an AutoGrow range. Select the Checking label and click on the button marked Goto.... This will select the checking range on the worksheet. Drag the Workbook Input Area Resize Dimple fully upwards. This allows you to enter and edit data directly in the cell, not in the larger formula bar in the top of the worksheet. Direct Input is useful when doing data entry because you can watch the data that you are entering rather than shifting your eyes between the formula bar and the place that you are doing the data entry in the worksheet. This lesson has taught you how to mark a range as AutoGrow, how to select a range from the Label Inspector, and how to select Direct Input rather than Formula Bar input. Please save your worksheet. Your worksheet should look similar to the worksheet in Lesson5.Mesa.
|
||
|
||