To reorder columns in a table

You can reorder columns within a table. Note the following:

Columns that have merged squares are moved as a group; columns within the merged squares can only be moved within their merged groups.
When columns that are part of a keep together are moved, the keep together is broken unless the columns are merged. In the case of a merged column where all the columns are designated keep together, then all columns within the merged square are moved as a whole and the keep together is maintained.
Using the following procedure, you can shuffle columns based on one base row at a time. To move columns based on multiple base rows, use the Shuffle Table Columns event.
Column-relative calculations that use the # sign are re-referenced after a table column shuffle, so that after the shuffle the cells pointed at are the same. For example, if you have a cell with RC(2#) in column 1, and you shuffle columns 2 and 3, the calculation in column 1 will be updated to RC(1#).

Note that all the R(#) relative calculations in the table will be adjusted after a shuffle. However, cells that use other ways of referring to cells in the table, either directly (B3) or with relative calculations without the # sign (RC(5)), will be re-referenced only if they are in a column that was shuffled. In the example above, cells in columns 2 and 3 will be referenced, but not cells in column 1.

To reorder columns in a table:

In Design mode, (View | Design Mode), place the cursor in the table whose columns you want to reorder.
Select Table | Shuffle Columns. The Shuffle Table Columns dialog box opens displaying the table with each column under a numbered header.
Select the base row of the column you want to reorder. Do this by clicking the left side of the dialog box to move the base row indicator $images\table_column_shuffle_triangle_shg.gif$ to a specified row. The base row defines the criteria used to shuffle columns. For example, if you select a row that contains some merged squares, the group of merged squares is shuffled as a whole. If the base row does not contain merged squares but the column is part of a merged square, you can only move the column within the merged squares.
Click the column you want to move. Arrows pointing to the left and to the right of the column appear on the header indicating which directions the column can be moved.
Click the appropriate button:
- To move the column to the right, click Move Right.
- To move the column to the left, click Move Left.
If an arrow is not present in the header, the column cannot be moved in that direction.
Once you click the appropriate button, notice that the column numbering shifts in the header so you can see the reordering.
If at any time, you want to go back to the original order, click Reset to discard all changes made in the Shuffle Table Columns dialog.
Click OK. If the column is part of a keep together that is not part of a merged square, a message is displayed indicating that the keep together will be removed. You can choose whether or not to continue with the reordering.