Data menu commands

 

The Data menu offers the following commands:

 

Sort

Sorts the table or selection according to the specified options.

 

Sort Ascending

Sorts the table or selection in ascending order.

 

Sort Descending

Sorts the table or selection in descending order.

 

Split Range

Splits each component of a range into additional rows or columns.

 

Join Range

Joins a selected range into one row or one column.

 

Reverse and Transpose

Reverses and transposes a selected data range.

 

Text Value Classification

Converts text to numerical values.

 

Remove Forced Text

Removes forced text from a selected data range.

 

Recalculate All

Recalculates all formula cells in the currently active document worksheet.