Data Tab Commands 

The Data tab contains commands for editing the cell and worksheet, finding and replacing cell contents, formatting the cells, manipulating data, and assigning or projecting coordinate systems. The Data tab is only available when viewing a worksheet.

 

The worksheet ribbon Data tab has the following commands:

 

Clear

Remove the selected cells

Merge

Combines a worksheet file with the existing worksheet

Insert

Displace selected cells and insert new cells into the worksheet

Delete

Delete selected worksheet cells and move rows or columns

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

Sets column widths for selected cells

Row Height

Sets row height for selected cells

Transform

Applies a mathematical transform to columns

Sort

Sorts selected cells

Spatial Filter

Spatially filters X, Y and optional Z coordinates

Statistics

Computes statistics on selected cells

Text to Number

Convert the text in selected cells to numbers

Transpose

Convert columns to rows and rows to columns

Assign XYZ Columns

Specifies the default columns for X, Y, and Z coordinate data

Assign Coordinate System

Specifies the existing coordinate system

New Projected Coordinates

Specifies the columns containing the source X, Y coordinates and target X, Y columns for a new coordinate system

DMS to DD

Convert DMS latitudes and longitudes to decimal degrees

Track Cursor

Track cursor location across plot, worksheet, and grid editor windows for a maps, data files, and grids.

 

 

See Also

Menu and Tab Commands