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:

Open Data	Open data file in a new worksheet
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.

Data Tab Commands

See Also