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 |