Data
The Datatab contains commands to edit the worksheet appearance and cell values. The Data Tools tab is only available when viewing a worksheet.
|
Group |
Command |
Description |
|---|---|---|
| Edit | Open Data | Import the data from a file into an existing data file at the active cell |
| Clear | Erase the contents of selected worksheet cells | |
| Merge | Loads the contents of a data file into the existing worksheet | |
| 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 | 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 | 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 | |
| Data | 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 | |
| Worksheet | Save to Multi-sheet Excel File | Save some or all of the open worksheets to a multi-sheet Excel XLSX file |
| Reload | Reloads the worksheet into the program discarding unsaved changes |