|
Dynamic Range Wizard
A wizard for creating Defined Names that expand and contract automatically.
Creating Dynamic Range Names
Use the Dynamic Range Wizard when you need to refer to tables of data that can change in size. The Dynamic Range Wizard gives you an easy way to create range names that dynamically expand and contract as the amount of data changes.
The ranges can dynamically expand and contract by rows or by columns or by both rows and columns.
There are a variety of methods available to handle embedded blanks and multiple tables on a worksheet.
Starting the Dynamic Range Wizard
You start the Dynamic Range Wizard from the Wizard button on the Name Manager form.
.png)
The wizard will then guide you through the 5 steps to create your dynamic range name.
|
