Sort Lists

All user-defined lists are displayed in the Sort Lists dialogue box. You can also define and edit your own lists. Only text can be used as sort lists, no numbers.

To access this command...

Open a spreadsheet document, choose Tools - Options - Office Calc - Sort Lists.

Lists

Displays all the available lists. These lists can be selected for editing.

Entries

Displays the content of the currently selected list. This content can be edited.

Copy list from

Defines the spreadsheet and the cells to copy, in order to include them in the Lists box. The currently selected range in the spreadsheet is the default.

Copy

Copies the contents of the cells in the Copy list from box. If you select a reference to related rows and columns, the Copy List dialogue box appears after clicking the button. You can use this dialogue box to define if the reference is converted to sort lists by row or by column.

New/Discard

Enters the contents of a new list into the Entries box. This button will change from New to Discard, which enables you to delete the new list.

Add/Modify

Adds a new list into the Lists box. If you would like to edit this list in the Entries box, this button will change from Add to Modify, which enables you to include the newly modified list.

Delete

Deletes the selected element or elements after confirmation.