The data grid is the main part of the data table that contains your data. Figure 1.10 illustrates how to interact with the data grid. See also Select Rows in Enter and Edit Data.
Figure 1.10 Interacting with the Data Grid
Copies attributes (data types, modeling types, numeric formats, and so on) or properties (formulas, notes, list and range checks, and so on) from one column to other columns. Also deletes selected attributes or properties from columns. See Standardize Attributes and Properties Across Columns in The Column Info Window.
Contains a list of column properties. Select one to open the Column Info window and apply it to the column. This list is also available from the Column Info window. See Column Properties in The Column Info Window.
Labels or unlabels selected columns in all plots. See Label Rows and Columns in Enter and Edit Data.
Used in virtually joined data tables to mark a column in the auxiliary data table as the ID column. That is, the rows of the data table are uniquely identified by the values of the ID column. The Link ID column property checkbox is selected if the column is the ID column for the data table. See Virtual Join Properties in The Column Info Window for details.
Used in virtually joined data tables to map a column in the main data table to the ID column in the auxiliary data table. The Link Reference column property specifies the path name of the auxiliary data table. See Virtual Join Properties in The Column Info Window for details.
Sorts all of the rows in the table by the values in the selected column. You can choose to sort the rows in ascending or descending order. See Sort Data Tables in Reshape Data.
Pastes all of the copied column properties into the selected adjacent or non-adjacent columns. For example, select column one and column two and then select Copy Multi Column Properties. Select column three and column five and then select Paste Multi Column Properties. Column one properties are pasted into column three. Column two properties are pasted into column five.
Hides the selected rows in all plots and graphs and excludes them from analyses. See Hide and Exclude Rows in Enter and Edit Data.
Provides a color palette. Select a color to apply it to the selected rows. The color is used in plots and graphs. See Assign a Color to Rows in Enter and Edit Data.
Provides a palette of markers or symbols. Select a marker to apply it to the selected rows. The marker is used in plots and graphs instead of points. See Add Markers to Rows in Enter and Edit Data.
Colors the row the same as the current row state color. For more details, see Assign Colors or Markers to Rows Based on Column Values in Enter and Edit Data.
Selects rows in the active data table with values that match the selected row(s). See Select Cells in Enter and Edit Data
Clears all active row states in the data table. All rows become included, visible, unlabeled, and show in plots as black dots. It does not affect row states saved in row state columns. See Delete Row Characteristics in Enter and Edit Data.
Removes all selected rows from the data table. Use the Undo command on the Edit menu to undo an accidental deletion. See Delete Rows and Columns in Enter and Edit Data.
–
|
The cursor changes form when you move the mouse over values in columns that have data validation in effect. It becomes a small, downward-pointing arrow on a column with list checking. When you click, the value is highlighted and the cursor becomes the I-beam. Enter or edit data as usual with any values defined as valid text or valid numbers. See List Check in The Column Info Window, for details.