|
![]() |
![]() |
This feature, applied to a named range, allows the range to grow beyond its defined size when new information is added. Use the Label Inspector to define a range as Autogrow. Use the enter key to move the cell cursor past the bottom row of the range and see that a new row is added to the range each time you press the key. The formula and formatting information is copied from the line above. AutoGrow ranges are useful for data entry templates, because you don't need to pre-allocate and format a range for data entry. Set the range to AutoGrow and as more data entry space is needed, the range will expand automatically. See also |
||
|
||