Edit DA Formats
Select any cell in a formatted Dynamic Array and click Edit DA Formats.
.png)
If the dynamic array expands/contracts vertically select the formatted row(s) you want to repeat copy down and check the floating Row Totals box if required.
If the dynamic array expands/contracts horizontally select the formatted column(s) you want to repeat copy across and check the floating Column Totals box if required.
.png)
In this example the dynamic array only expands/contracts vertically and the $K$9 is a cell in the first row. This tells SpeedTools to use the first row as a formatting template for the other rows.
Because the dynamic array has a floating totals row which is formatted differently the Floating Row Totals box is checked.
Changing the filter to 200 contracts the dynamic array and it is dynamically reformatted.
.png)
You can use more than one row and/or column as the formatting template to repeat:
.png)
In this example there are both floating row totals and floating column totals, and the first two columns are used as the horizontal formatting template.
Resizing to 8 rows and columns gives this:
.png)
Reformat This DA
Use this button if you want to see the result of applying the chosen formatting template rows and columns.
|