Data Tab Commands - Worksheet Window

The Data tab contains common commands to edit, sort, find, and manipulate data, format cells, and perform statistics and mathematical transformations.

Clear	Erase the contents of selected worksheet cells
Insert	Insert a block of blank cells in place of the selected cells
Delete	Remove selected worksheet cells and move rows or columns
Delete Unlinked Data	Removes rows from the worksheet that are not used in the active thematic map
Import	Loads the content of a data file into an existing worksheet
Find	Find a particular word or phrase in the worksheet
Find Next	Find the next occurrence of the word or phrase
Replace	Replace the word or phrase with alternate text
Format Cells	Sets the numeric format, alignment, and background color for the selected cells
Column Width	Set column widths for selected columns
Row Height	Sets row height for selected rows
Sort	Sort selected cells
Transform	Apply a mathematical transform to columns, rows, or cells
Statistics	Compute statistics on selected cells
Transpose	Convert columns to rows and rows to columns
Text to Number	Convert text strings to numeric format
Number to Text	Convert numeric data to text strings