Copy List

Allows you to copy marked cells to a sort list.

To access this command...

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

List from

Choose between the options Rows and Columns. Cells without text will be ignored when copying.

Rows

Select the Rows option to summarise the contents of the selected rows in a list.

Columns

Select the Columns option to summarise the contents of the selected columns in a list.