When rendering a report in Excel format and the report has more than one worksheet, you may want to control the way the worksheets are ordered.
Worksheets are not ordered alphabetically by the list frame name or ordered by the left-to-right and top-to-bottom order of the respective list frame. Rather, the order is set by the creation and z-order of the list frame in Impromptu. The first list frame created in the z-order generates the first worksheet, the second list frame created generates the second worksheet, and so on. To change the worksheet order, you must change the list frame z-order.
Select the list frame.
From the Format menu, click Stacking, and click a stacking command such as Send Back or Bring Forward.