Clicking the ‘Sheet Ordering’ option via the ribbon will open a form* to specify criteria to reorder sheet data.
*Sheet values do not need to be selected prior to opening the form.
Using the form controls, single or multiple columns can be specified with either an Ascending or Descending Sort Order. Criteria can also be removed by using the ‘Clear’ and ‘Clear All’ controls. See below for a re-ordering example:
Original sheet data:
Below, Invoices are out of order and the Installment number orders vary.
Order Criteria:
By specifying ‘Invoice Number’ with an ascending sort order and ‘Installment Number’ with a descending sort order the sheet values will re-order based on the criteria, once ‘Ok’ is clicked.
Post Ordering:
All sheet values have been ordered based on the criteria in the form above. On re-ordering all data hierarchies and structures will be retained.