Calc Guide

Range contains column labels
Does not include the column heading in the sort.
Include formats
A cell's formatting is moved with its contents. If formatting is used
to distinguish different types of cells, then use this option.
Copy sort results to
Sets a spreadsheet address to which to copy the sort results. If a
range is specified that does not have the necessary number of cells,
then cells are added. If a range contains cells that already have
content, then the sort fails.
Custom sort order
Select the box, then choose from the drop-down list one of the sort
orders defined in Tools > Options > OpenOffice.org Calc >
Sort Lists.
Direction
Sets whether rows or columns are sorted. The default is to sort by
columns unless the selected cells are in a single column.
Finding and replacing in Calc
In spreadsheet documents you can search for text, formulas, and
styles. You can navigate from one occurrence to the next using Find,
or you can highlight all matching cells at once using Find All, then
apply another format or replace the cell contents by other content.
Text and numbers in cells may have been entered directly or may be
the result of a calculation. The search method you use depends on the
type of data you are searching for.
Tip
Cell contents can be formatted in different ways. For example,
a number can be formatted as a currency, to be displayed with
a currency symbol. You see the currency symbol in the cell, but
you cannot search for it.
By default, Calc searches the current sheet. To search through all
sheets of the document, click More Options, then select Search in all
sheets option.
Chapter 2 Entering, Editing, and Formatting Data 67