Data Tools Tab Commands

The Data Tools tab contains commands to edit the worksheet appearance and cell values. The Data Tools tab is only available when viewing a worksheet.

Import Import the data from a file into an existing data file at the active cell
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
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
Transform Apply a mathematical transform to columns, rows, or cells
Statistics Compute statistics on selected cells
Sort Sort selected cells
Transpose Convert columns to rows and rows to columns
Text to Number Convert text values to numeric values
Number to Text Convert numeric values to text values
Reload Data Reloads the worksheet into the program discarding unsaved changes

See Also

Grapher User Interface

Ribbon

Quick Access Toolbar

File Menu Commands

Home Tab Commands

Insert Tab Commands

Layout Tab Commands

View Tab Commands

Automation Tab Commands

Graph Tools Tab Commands

Grid Tools Tab Commands