1. Home
  2. Reorder Spreadsheet Table Margins

Reorder Spreadsheet Table Margins

Select menu: Spread | Manipulate | Reorder Table

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 Spread | Manipulate | Transpose menu.

  1. From the menu select Spread | Manipulate | Reorder Table.

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 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.

See also

Reorder Factor Levels
Sort Spreadsheet
Spreadsheet Manipulate Menu

Updated on March 15, 2019

Was this article helpful?