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 the data from a file into an existing data file at the active cell


Erase the contents of selected worksheet cells


Insert a block of blank cells in place of the selected cells


Remove selected worksheet cells and move rows or columns


Find a particular word or phrase in the worksheet

Find Next

Find the next occurrence of the word or phrase


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


Apply a mathematical transform to columns, rows, or cells


Compute statistics on selected cells


Sort selected cells


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


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