Reorder Spreadsheet Table margins

This allows the order of the classifying factors for a table in a spreadsheet to be changed. A two-way table can also be rearranged using the Transpose item on the Manipulate submenu on the Spread menu.

Classifying factors for a table can also be rearranged by dragging and dropping the factor columns. Dragging a factor column into the body of the table will make this the factor that is used to classify the data across the columns. Dragging factors into a new position within the classifying factor columns will reorder these columns. Dragging a table body column into the factor column positions will cause the last factor column to become the factor across columns, and the old factor the across columns will be moved into the new position with the factor columns.

Classifying Factor order

This lists the classifying factors in the N-way Table spreadsheet. For a one-way table the classifying factor will be displayed as a column. For tables that have two or more classifying factors the first N-1 factors will be displayed in columns and the last factor will classify the data across the columns.

Action Buttons

OK	Change the order of the factors and close the dialog.
Cancel	Close the dialog.
Top	Move selected factor to the top of the list.
Up	Move selected factor up one place in the list.
Down	Move selected factor down one place in the list.
Bottom	Move selected factor to the bottom of the list.

Classifying Factor order

Action Buttons

See Also