Enter Data
This section describes how to add rows and columns, fill columns with sequential data, and enter cell formulas.
Add Rows
To add any number of rows to the table:
1. Select Rows > Add Rows.
2. Enter the number of rows to add.
3. Specify where to add the new rows (at the start or end of the data table, or after a specific row).
4. Click OK.
To add a single row to the end of the table:
• Below the last row, click anywhere in a cell and begin typing.
• Below the last row, double-click in the empty row number area.
Add Columns
To add new, empty columns:
• Double-click the empty space to the right of the last data table column.
• Select Cols > New Column. You can then specify more details about the column. You can also add subsequent columns by clicking Next. See “The Column Info Window” in the “Set Column Properties” chapter.
• Select Cols > Add Multiple Cols. See “Adding Multiple Columns”.
Note: When you initially create a column, you can choose to fill it with initial data values. See “Fill in Initial Data Values” in the “Set Column Properties” chapter. However, after you modify the cells, this option no longer appears.
Adding Multiple Columns
Using the Add Multiple Columns command to define multiple columns is different from using the New Column command. All of the columns that you add using the Add Multiple Columns window have the same data type. Right-clicking anywhere to the right of the last column in a data table to add multiple columns defaults to After Last Column.
To add multiple columns:
1. (Optional) Change the Column prefix.
By default, the new column names are Column 1, Column 2, and so on.
2. Enter the number of columns to add.
3. (Optional) Specify if the columns should be grouped. See “Group Columns”.
4. Select the data type (Numeric, Character, or Row State) for all of the columns. See “About Data Types and Modeling Types” in the “Set Column Properties” chapter.
5. Specify where you want to put the new columns.
6. (Optional) Select initial data values for all of the columns. See “Fill in Initial Data Values” in the “Set Column Properties” chapter.
7. Click OK.
Figure 4.2 The Add Multiple Columns Window
Tip: To change the data type after the columns are created, click on the modeling type icon in the Columns panel and select a different type.
Fill Columns with Sequential Data
To fill columns with a repeating sequence of data or with a continuation of values:
1. Create a sequence of data in a column. See Figure 4.3.
Figure 4.3 Example of a Sequence of Data
2. Highlight the cells containing the sequenced data. The cells can be in different columns.
3. Right-click the selected cells and select an option under Fill.
Fill Options
Repeat sequence to end of table
cells below the selection are filled with repeats of the selected cells.
Continue sequence to end of table
cells below the selection are filled with a continuation of the pattern found in the selected cells. For example, if the selected cells contain the numbers 1 and 2, then the remaining cells are filled with 3, 4, 5, 6, and so on. If the selected cells contain the numbers 2 and 4, then the remaining cells are filled with 6, 8, 10, 12, and so on.
Repeat sequence to
JMP repeats the pattern found in the selected cells to the row number that you specify.
Continue sequence to
JMP continues the pattern found in the selected cells to the row number that you specify.
Enter Cell Formulas
In numeric columns, you can enter cell expressions preceded by an equal sign (=). JMP evaluates the expression and stores the new number as the cell’s value. Unlike column formulas, a cell expression is not stored. Cell expressions can contain operators, constants, and global and column variables.
To enter an expression:
1. Click the cell where you want to enter the expression.
2. Type an equal sign (=), and then type the expression. See Table 4.1.
3. Press the ENTER key.
|
Example expression
|
Cell value
|
|
=sqrt(2)
|
1.41
|
|
=456+890
|
1346
|
|
=height+weight
|
Sums the values of cells in columns height and weight located in the same row as the cell that you entered the expression.
|
|
=height[1]
|
Displays the value found in row 1 of the height column
|
Select Rows
To select one entire row:
• Click in the empty space that contains the row number.
To select a specific row number:
• Select Rows > Row Selection > Go to Row and type in the desired row number.
To select multiple rows:
• For continuous selection:
‒ Click and drag the cursor over the row numbers.
‒ Hold down the SHIFT key and click the first and last rows of the desired range.
‒ Hold down the SHIFT key and press the up or down arrow key.
• For discontiguous selection:
‒ Hold down the CTRL key and click on each row.
To select or deselect all rows:
• To select all rows, select Rows > Row Selection > Select All Rows.
• To deselect all rows, select Rows > Clear Row States.
or
• Hold down the SHIFT key and click the lower triangular area in the upper left corner of the data grid to select. Click again in the same area to deselect all rows. See Figure 4.4.
• To clear all highlighted areas in the data table, press the ESC key.
Figure 4.4 Lower Triangular Area
To select random rows:
1. Select Rows > Row Selection > Select Randomly.
2. You can randomly select either a specific number of rows, or a proportion of the total number of rows:
‒ Enter a whole number to select that number of rows.
‒ Enter a value between 0 and 1 to select that proportion of rows.
For example, enter 10 to select 10 rows. Enter 0.1 to select 10% of the rows.
To invert the row selection:
• Select Rows > Row Selection > Invert Row Selection.
To assign a dominant column:
1. Select Rows > Row Selection > Select Dominant.
2. Choose the column(s).
3. Select high or low values for each column.
4. Click OK.
To save the current row selection in a new column:
1. Select Rows > Row Selection > Name Selection in Column.
2. Type a column name.
3. Label the selected and deselected rows.
4. Click OK.
To select excluded, hidden, or labeled rows:
1. Select Rows > Row Selection.
2. Select from the following options:
‒ Select Excluded
‒ Select Hidden
‒ Select Labeled
Note: For details about excluded, hidden, or labeled rows, see “Assign Characteristics to Rows and Columns”.
Locate Next and Previously Selected Rows
You can locate the next selected row after the current row and cause it to flash by selecting Rows > Next Selected. Similarly, you can locate the previously selected row before the current row and cause it to flash by selecting Rows > Previous Selected.
Each time you select Rows > Next Selected or Rows > Previous Selected, the next or previously selected row is found and flashes. A beep signals when the last selected row is located.
You might want to use this feature when you have selected rows intermittently in a large data set and want to look through the selected rows in the data table.
Example of Locating Next and Previously Selected Rows
1. Open the Diamonds Data.jmp sample data table.
2. Select Analyze > Fit Y by X.
3. Select Carat Weight and click Y, Response.
4. Select Price and click X, Factor.
5. Click OK.
6. Select Tools > Lasso.
If you cannot see the menu bar, place your mouse pointer over the blue bar below the title bar to reveal it.
7. Lasso some of the points near the 10,000 dollar price at the bottom of the plot. See Figure 4.5.
8. In the data table, select Rows > Next Selected (or you can press the F7 key).
You can easily navigate through the selected rows to see the data for each.
Figure 4.5 Points Selected
Select Columns
There are several ways to select columns:
• Select columns in the data table itself. See “Select Columns in a Data Table”.
• In a data table that has many columns, select columns by attributes, properties, and statistics in the Columns Viewer. See “Select Columns in the Columns Viewer”.
Select Columns in a Data Table
To select one entire column:
• In the data grid, click in the empty space around the column name.
or
• In the Columns panel, click the column name.
To select a specific column number:
1. Select Cols > Go to.
2. Enter the column number or name and click OK.
To select multiple columns:
• For continuous selection:
‒ Click and drag the cursor over the column name.
‒ Hold down the SHIFT key and click the first and last columns of the desired range.
‒ Hold down the SHIFT key and press the left or right arrow key.
• For columns that are not next to each other:
‒ Hold down the CTRL key and click on each column.
To select or deselect all columns:
• Hold down the SHIFT key and click the upper triangular area in the upper left corner of the data grid to select. Click again in the same area to deselect all columns. See Figure 4.6.
Figure 4.6 Upper Triangular Area
Tip: To clear all highlighted areas in the data table, press the ESC key.
Select Columns in the Columns Viewer
The Columns Viewer helps you quickly select columns by attributes, properties, and statistics, particularly in a data table that has many columns. You can view summary statistics and properties for those columns, view quartiles in the summary statistics, subset the data, and more. And columns in the Columns Viewer window are also linked to the data table columns (Figure 4.7).
Figure 4.7 Linked Columns in the Column Viewer
The Columns Viewer gives you a quick view of data table characteristics. For example, the Summary Statistics report shows which columns contain missing values (Figure 4.8). You can select those columns in the report and then exclude them in the data table.
Figure 4.8 Identify Missing Values
Other options include the following:
Clear Select
Deselects columns in the data table and in the Columns Viewer. This option ensures that no columns are selected before you begin selecting columns.
Subset
Creates a linked subset data table from the selected columns.
Show Summary
Creates a linked Summary Statistics report for the selected columns. Right-click to select options such as sorting by column or creating a linked data table from selected columns. Select Show Quartiles to include lower quartiles, upper quartiles, and interquartile ranges. And to create a linked data table from all columns in the report, select Data Table View from the Summary Statistics red triangle menu.
Find Columns with Properties
Shows a list of column properties in the Columns with Properties report. Select the properties that you want to find and then click OK to create a linked report from all columns. Or you can select columns first in the Select Columns list and then show the list of properties just for those columns.
Tip: Each time you click the Show Summary or Find Columns with Properties buttons, a new report is added to the window. To delete a report, select Remove from the report’s red triangle menu.
Example of Finding Columns with a Specific Property
This example shows how to find columns that have a Formula property and then view all formulas at once.
1. Open the Consumer Preferences.jmp sample data table.
2. Select Cols > Columns Viewer to open the Data Table Columns Viewer window.
3. Select Find Columns with Properties, select Formula, and click OK.
The Columns with Properties report appears. Several columns include the Formula property (Figure 4.9). Because the list is so long, you want to view all formula columns together.
Figure 4.9 Select the Formula Column Property
4. Right-click the report, select Sort by Column, Formula, and then click OK.
Columns that have a Formula property appear at the top of the report (Figure 4.10).
Figure 4.10 Sort by Column
5. Select the Employee Tenure, Position Tenure, and Salary Group columns and select Column Info.
Formulas for the selected columns appear in the data table’s Column Settings window.
Example of Showing Summary Statistics
This example shows how to find columns with a low standard deviation. This can be helpful if you want delete or exclude that data from an analysis.
1. Open the Semiconductor Capability.jmp sample data table.
2. Select Cols > Columns Viewer to open the Data Table Columns Viewer window.
3. In the Select Columns red triangle menu, select Name Starts With.
4. Type PNP and press Enter to select the PNP columns (Figure 4.11).
Figure 4.11 Filter Columns by Name
5. Click Show Summary to add the Summary Statistics report (Figure 4.12).
The rows show the minimum, maximum, mean, and standard deviation for each column.
Figure 4.12 Summary Statistics for Selected Columns
6. Right-click in the report and select Sort by Column.
7. Select Std Dev and Ascending, and then click OK.
Notice that PNP6 has no standard deviation, because the minimum, maximum, and mean values are 0.
Figure 4.13 Sorted Std Dev Column
8. In the Summary Statistics report, select the row for PNP6 and then display the data table.
9. View the data table and press Delete to remove the selected column.
The column is instantly removed from the data table.
10. To close the Columns Viewer, click the X button in the upper right corner (Windows) or upper left corner (Macintosh) of the window.
Select Cells
To select a block of cells:
• Drag the arrow cursor diagonally across the cells.
JMP can find all cells whose values are the same as the ones you currently have highlighted. You can do this within one data table or throughout all open data tables. Highlight the cells that contain the values that you want to locate.
To find all matching cells within the active data table:
• Select Rows > Row Selection > Select Matching Cells
or
• Right-click one of the highlighted row numbers and select Select Matching Cells.
To find all matching cells across all open data tables:
• Select Rows > Row Selection > Select All Matching Cells. The rows that contain the same values as the selected ones are highlighted.
To select cells that contain specific values:
JMP can search for a specific value (or text string) and highlight all of the cells in the data table that contain the specific value.
1. Select Rows > Row Selection > Select Where.
Figure 4.14 Specify Criteria for Selecting Rows
2. From the column list, highlight the name of the column whose rows you want to select.
3. Use the drop-down menu to select a condition from the list (equals, does not equal, and so on). See Figure 4.14.
4. Type the search value. To search for missing values, leave the box empty.
5. Click OK.
You can also specify the following optional features:
• To compare the values of two columns, click the Compare column check box. Select from the list of columns for comparison.
• To make the search case-sensitive, click the box beside Match Case.
If you currently have rows selected in the data table, you can specify the following optional features:
• Click an option under Action on currently selected rows to tell JMP how to handle that current selection:
‒ Clear Current Selection removes the highlight from currently selected rows and selects all rows that contain the specified value.
‒ Extend Current Selection keeps the currently selected rows selected and also selects the rows in which the specified value has been found.
‒ Select From Current Selection selects the rows in the currently selected array that contain the specified values.
• Click Add Condition to add a condition to the list.
• To add more conditions to the search, repeat the previous steps. Click the appropriate item in the Select Rows area to specify if you would like JMP to select rows conditionally: if all conditions are met, or if any of the conditions are met.
• To keep the window open after you click OK, select Keep dialog open.
Edit Data
This section describes how to edit data in a table, including editing cells and making changes to rows and columns.
Delete Rows and Columns
To delete rows:
1. Highlight the rows that you want to delete.
2. Press the Delete key, or right-click on the row numbers and select Delete Rows.
Caution: When you try to delete thousands of rows, an alert might appear if your computer has insufficient memory. Click No to cancel the deletion, and then try to delete fewer rows.
To delete columns:
1. Highlight the columns to delete.
2. Press the Delete key, or right-click and select Delete Columns.
Edit or Delete Cells
To edit or delete the contents of a cell:
1. Click the cell containing the value that you want to edit or delete.
2. Press the Delete key.
3. To edit the value, click the cell a second time, and then edit the cell’s value.
Edit Column Names
To edit a column name, select the column and begin typing. You can also edit the column name in the Column Info window.
Recode Data
If you have data that is coded incorrectly (for example, contains typographical errors or incorrect wording), you can recode it so that it follows a consistent format. You can also use the recode feature to replace missing or empty values.
Note: If you need to recode similar values within multiple columns, use the Recode option in Cols > Standardize Attributes. See “Recode Values” in the “Set Column Properties” chapter.
To recode data:
1. Select the columns containing the data that you would like to recode.
2. Select Cols > Recode.
Figure 4.15 Example of the Recode Window
3. Type the new value in the text box corresponding to the old value that you want to change.
4. Specify how you would like the text to be recoded. See “Recode Options”.
5. Click OK.
Recode Options
In Place
applies any change to the original data column.
New Column
creates a new column for the changed data and retains the original column.
Formula Column
creates a new column with the changes as a formula instead of values.
Script
creates a new script called Recode in the data table. You can run this script to perform recoding in-place. If you add more recodes later, the script updates (assuming that you select Script as the destination). You can run this script later, to new data, and copy it to other data tables, or run it from your own scripts.
Red Triangle Options for Recode
The red triangle menu contains options for the Recode window. The first three commands apply to all items in the data table list.
Convert to Titlecase
converts to title case, that is, an initial uppercase character and subsequent lowercase characters for each word.
Convert to Uppercase
converts all items to uppercase.
Convert to Lowercase
converts items to lowercase.
Tab characters, space characters, and line separators are often imported into a data table. Remove these characters using the following commands:
Trim Whitespace
removes leading and trailing whitespace characters. For example, if an extra space was imported before and after the name John, this command would delete the spaces.
Collapse Whitespace
trims leading and trailing whitespace characters and removes duplicate interior white space. That is, if more than one whitespace character is present, the Collapse Whitespace command replaces the two spaces with one space.
View Patterns of Missing Data
If your data table contains missing data, you might want to determine whether there is a pattern to the missing data. The pattern might help you make discoveries about your data.
To view patterns of missing data:
1. With your data table open, select Tables > Missing Data Pattern.
2. Select the columns for which you would like to find patterns of missing data.
3. Click Add Columns.
4. Select the Count Missing Value Codes check box if you want to count missing value codes as missing values.
5. Click OK.
Example of Viewing Patterns of Missing Data
1. Open the Missing Data Pattern.jmp sample data table.
2. Select Tables > Missing Data Pattern.
Figure 4.16 The Missing Data Pattern Window
3. Highlight all of the columns.
Note: For details about the options in the red triangle menu, see “Columns Filter Menu” in the “JMP Platforms” chapter.
4. Click Add Columns.
5. Click OK.
Figure 4.17 A Missing Data Pattern Table
Tip: To quickly create a Treemap or Cell Plot of the data, select Run Script from the red triangle menu next to Treemap or Cell Plot in the Table panel.
Figure 4.17 shows the following patterns:
• Row 1 shows that there are two instances where all rows in Trial 1, Trial 2, Trial 3, and Trial 4 have no missing values.
• Row 2 shows that there are two rows in the source table whose one missing value is in the Trial 4 column.
• Row 3 shows that there are two rows in the source table whose missing values are in the Trial 3 and Trial 4 columns.
• Row 4 shows that there is one row in the source table whose three missing values are in the Trial 2, Trial 3, and Trial 4 columns.
In the Missing Data Pattern table, JMP automatically assigns the Count column the analysis role of frequency. If you now use the Missing Data Pattern data table to run an analysis, JMP automatically uses Count as a frequency. So you do not have to specify Count as the role each time. For details, see “Assign Column Properties” in the “Set Column Properties” chapter.
Find and Replace Cell Values
You can find and replace cell values by selecting the Edit > Search options.
Figure 4.18 The Find Window
The following rules apply to searching for values:
• To find values in hidden columns, unhide the column.
• Values found in locked columns cannot be modified.
• The Undo command works only with Replace. You cannot undo Replace All.
• If your data table contains value labels, using the Search commands searches for actual values, but does not search for labels. See “Value Labels” in the “Set Column Properties” chapter.
• If your data table contains formatted values (such as dates, times, or durations) using the Search command searches for the formatted values, not the actual values.
Find Window Options
Refine your search with the following options:
Match Case
Performs a case sensitive search, which can be useful for locating proper nouns or other capitalized words.
Match entire cell value
Detects empty spaces, which lets you search for a series of words in a character column, or locate strings with unwanted leading or trailing empty spaces.
Tip: To find missing character values, leave the Find what box empty and check Match entire cell value. To find missing numeric values, insert a period into the Find box and check Match entire cell value.
Use regular expressions
Assumes the find string to be a regular expression instead of the literal string that you enter in the Find what box. The regular expressions follow standard semantics.
Restrict to selected rows
Restricts the search to selected rows.
Restrict to selected columns
Restricts the search to selected columns.
Search data
Searches only data cells (omitting column names).
Search column names
Searches only column names (omitting data cells).
By column
Searches the table column by column, from top to bottom, until it reaches the last cell in the rightmost column, or until you stop the search.
By row
Searches the data table row by row from left to right, to the rightmost cell in the last row or until you stop the search.
Multiple lines
Increases the Find and Replace boxes to 3 lines long instead of 1. The Enter key inserts a return into the field.
Tip: You can alternatively click and drag on the Find and Replace boxes to make them larger. If you copy and paste, the boxes resize to 1 line long, but all of your text is still there.
Keep dialog open
Keeps the Find window open during your search.
Search Actions
This section describes some common searches that you might perform.
Begin by searching for a value in the data table. The search begins with the first cell in the first column and searches every cell until it locates the value or reaches the end of the table.
To replace the currently highlighted cell value:
Enter a value in the Replace with box and click Replace. Or, if the Search window is closed, select Edit > Search > Replace. If the replace value is a missing value, the currently highlighted cell content becomes a missing value.
To replace all occurrences of the specified value:
Enter a value in the Replace with box and click Replace All. Or, if the Search window is closed, select Edit > Search > Replace All.
To replace the value and search for the next value:
Enter a value in the Replace with box and click Replace. Or, if the Search window is closed, select Edit > Search > Replace and Find Next. Or, press CTRL-L.
To use a selected value as the Find what value:
In the data table, select a value. Select Edit > Search > Use Selection for Find. Next, select Edit > Search > Find. The value that you selected in the data table is already entered in the Find what field.
To use a selected value as the Replace with value:
In the data table, select a value. Select Edit > Search > Use Selection for Replace to populate the Replace with field.
To find the next value when the Search window is closed:
Select Edit > Search > Find Next. Or, press CTRL-G, or F3 on Windows.
To find a missing value:
• To find missing character values, leave the Find what field empty and select Match entire cell value.
• To find missing numeric values, type a period into the Find what text box and select Match entire cell value.
Note: Typing a period into the text box without clicking the Match entire cell value box searches for a period.
Reorder Columns
You can rearrange or sort data table columns by their name, data type, or modeling type, or reverse the current order. To reorder columns, select Cols > Reorder Columns and select from one of the following options:
Move Selected Columns
moves the selected columns to a particular place in the data table. Specify where to place the selected columns in the Move Selected Columns window:
‒ To first: moves the selected columns so they are in the left-most position in the data table.
‒ To last: moves the selected columns so they are in the right-most position in the data table.
‒ After: moves the selected columns so they are after a column that you identify.
Original Order
returns the columns to the order they were in at the time the data table was last saved.
Reorder by Name
arranges the columns from left to right in alphabetical order by column name.
Reorder By Data Type
arranges the columns from left to right in alphabetic order by data type (row state, character, numeric).
Reorder By Modeling Type
arranges the columns from left to right in alphabetic order by modeling type (continuous, ordinal, nominal). Row state columns have no modeling type, and are shown last.
Reverse Order
reverses the order of the data table columns.
Group Columns
Group columns within a single heading to manage large numbers of columns and facilitate analysis role assignment. Grouped columns appear in an outline format within the Columns panel.
To group or ungroup columns:
1. Within the data grid, select the columns that you want to group.
2. From the main menu, select Cols > Group Columns or Cols > Ungroup Columns.
or
1. From the Columns panel, select the columns that you want to group.
2. Right-click on the selected columns and select Group Columns or Ungroup Columns.
Note: Grouped columns are automatically retained for data tables generated from the following commands: Subset, Sort, Summary, Join, Stack, and Split. For the Stack command, if all the columns in the stack group belong to the same columns group, then the group's name is used for the column name.
Move Values
To move values in a data table, select the values, click and pause, and then drag and drop the values into the new location.
Tip: Clicking and dragging on a selection without pausing extends the selection.
When dragging and dropping values, note the following:
• Cells retain all of their characteristics and column properties.
• After you move cells, missing values appear in the cells that you initially selected.
• The selected cells and the destination cells must have the same data type.
• If you drag a set of cells to an empty area of the table, new columns are automatically created.
• New columns have the original columns’ display format and modeling types.
To specify where to move rows:
1. Highlight the rows that you want to move.
2. Select Rows > Move Rows.
3. Specify where you would like to move the rows in the Move Rows window:
‒ To the beginning of the table (At start)
‒ To the end of the table (At end)
‒ After a specific row number (After row:)
Move Content into Another Window
In Windows, you can drag selected content over a minimized window. The minimized window moves to the front and you can paste your content into it. You can do the same thing in JMP. For example, you can drag selected content over the Home Window button 
(located in the bottom right corner of most windows). Then in the Window List, drag the content over the window that you want to move the content into. That window moves to the front and you can drop in the content.
(located in the bottom right corner of most windows). Then in the Window List, drag the content over the window that you want to move the content into. That window moves to the front and you can drop in the content.Tip: If you cannot see the JMP Home Window button, select View > Status Bars.
For example, you can drag a selected column, row, or cell from one data table into another; drag selected text from one script window into another; or drag selected content from a report into a journal.
Use the Row Editor
Use the Row Editor to browse or edit cells one row at a time. Open the Row Editor in one of the following ways:
• Select Rows > Row Editor.
• In a data table, double-click in the row number area. The row that you use is the row that first appears in the Row Editor.
• In a report window, right-click in a plot or graph and select Row Editor.
Figure 4.19 Row Editor
Note the following:
• If you have a report window open, and you want edited data to be automatically reflected there, make sure that Automatic Recalc is turned on. See “Automatic Recalc” in the “JMP Platforms” chapter.
• If your data table contains value labels, the Row Editor displays the label, and when the cell is highlighted for editing, it shows the actual value. See “Value Labels” in the “Set Column Properties” chapter.
Row Editor Buttons
Click the arrow buttons to browse through selected rows or the entire data set if no rows are selected. Row Editor buttons are described as follows:
Shows the previous row.
Shows the previously selected row.
Makes the row blink in graphs.
Shows the next selected row.
Shows the next row.
Searches for a row. See “Select Cells”.
Creates a new row at the end of the data table.Row Editor Options
The red triangle menu in the Row Editor contains the following options:
Next Selected
displays information for the selected row that is located after the current one.
Prev Selected
displays information for the selected row that is located before the current one.
Next
displays information for the row that is located after the current one, regardless of whether the row is selected.
Prev
displays information for the row that is located before the current one, regardless of whether the row is selected.
Save
saves the data table and any changes that you have made to it via the Row Editor.
New Row
creates a new row in the data table.
Find
displays the same window as if you had selected Rows > Row Selection > Select Where. Select one of the options on the Action on currently selected rows menu, and then highlight the column whose rows you want to select. Type in the value for which you want JMP to search. See “Select Cells”.
Blink
causes the current row’s highlight to flash at a rapid rate.
Note: Text in a locked column or a locked data table cannot be edited. For details, see “Lock Tables”, and “Lock Columns in Place”.
Context Menus for Rows and Columns
When you right-click in the row number area, or at the top of a column in the column name area, context menus appear. These menus provide quick access to selected commands in the Rows and Columns menus. For details about these options, see “Context Menu for Columns” in the “Get Started” chapter and “Context Menu for Rows” in the “Get Started” chapter.
Make Binning Formula
You can distribute your data into equal width bins using the Make Binning Formula option. Select the column or columns that you want to divide into bins, then select Cols > Make Binning Formula. New formula columns are added to the data table.
The Make Binning Formula window contains the following options:
Format
Select a format for displaying the range of values in the bin. You can see a preview by moving the cursor over the graph.
Bin Shape: Offset
Select an offset value for the lower edge of the bins.
Note: Bins are identified by their lower edge. The lower edge is in the bin. The upper edge is in the next bin because it is the next bin's lower edge.
Bin Shape: Width
Select the width of values for the bins.
Note: The colored bands reflect the offset and the width of the bins with respect to the data.
Labels
Select No Labels to use the lower edge value as the label. Or, you can use the Value Labels property as either labels or ranges. For more information, see “Value Labels” in the “Set Column Properties” chapter.
Tip: For use with the Categorical platform, value labels are recommended. Axes may be better labeled with range labels.
Make All Like X
(Appears only if multiple columns are selected) Applies the choices made for the first column (X) to the remaining columns.
Make Formula Columns
Creates the formula columns and closes the window.
Example of Making a Binning Formula
1. Open the Big Class.jmp sample data table.
2. Select the height column.
3. Select Cols > Make Binning Formula.
You want the range of values to appear as X-X, so keep the range set to Low - High.
4. Change the offset to -0.5.
For integer data, setting the offset to -0.5 helps to disambiguate values on the edge. In this example, one of the bins covers 59.5 to 64.5, so it is clear that 59 and 65 are not included in this bin.
5. Keep the width set to 5.
6. For the labels, keep it set to Make Value Labels, so that you can see the range of values for the bin.
Figure 4.20 Completed Binning Window
7. Click Make Formula Columns.
A column called height Binned is added to the Big Class.jmp data table.
8. To see how the formula is calculated, right-click on the height Binned column and select Formula.
Figure 4.21 Formula
Edit Data Tables
This section describes the following actions that you can perform on data tables:
• Change the data table name
• Lock data tables
• Add table variables
• Add scripts to the data table
• Compare data tables
Change Table Names
A data table’s name appears at the top of its window, in the table panel, and on all related analysis reports. You can change a data table’s name in any of the following ways:
• Select File > Save As and save as the new name.
• In the table panel, click twice on the table name, type the new name, and then press the Enter key.
• On Windows. select Window > Set Title.
Lock Tables
Locking a JMP data table prevents its values from being edited. You can still run analyses, assign characteristics, and so on. To lock a data table, click the red triangle menu next to the table name in the table panel and select Lock Data Table.
A lock icon 
appears next to the data table name. To unlock the file, select Lock Data Table again.
appears next to the data table name. To unlock the file, select Lock Data Table again.If you make a data table read-only outside of JMP (for example, by changing its properties on Windows), the data table contains a note informing you that it is locked. See Figure 4.22. This type of lock allows users to edit the data table, but not save the changes.
Figure 4.22 A Read-Only File
Compress Tables
Compressing a JMP (version 6 or higher) data table reduces the size of the stored file. You can still run analyses, assign characteristics, and so on. To compress a data table, click the red triangle menu next to the table name in the table panel and select Compress file when saved and save the data table.
Note: To save a data table using compression, you must enable saving tables in the extended file format by selecting Preferences > Tables > Save table in extended file format. This preference is selected by default.
After saving the data table, a compressed icon 
appears next to the data table name. To decompress the file, select Compress file when saved again.
appears next to the data table name. To decompress the file, select Compress file when saved again.In addition, you can configure JMP to always use GZ compression when saving by selecting Preferences > General > Save Data Table Columns GZ Compressed.
Note: The Compress file when saved option only decreases the file size. This command does not affect the memory required to analyze the data. To reduce both the file size and memory required for analyzing, use Cols > Compress Selected Columns. See “Compress Selected Columns” in the “Set Column Properties” chapter.
Use Table Variables
A table variable can contain textual information (for example, source information for the data), or a value that can be used by column formulas or JSL scripts. Table variable names appear in the table panel at the left of the data grid. See Figure 4.23.
Figure 4.23 Table Variables in the Table Panel
Uses for Table Variables
Use table variables in the following situations:
• To document tables
• In formulas
• In JSL scripts
Use Table Variables to Document Tables
Table variables are used primarily to document tables. Many sample data tables installed with JMP contain a table variable named Notes. This variable provides details about the data (for example, the source of the data). The example in Figure 4.23 shows a data table that contains Notes as one of its table variables. JMP also automatically creates table variables when you create a design table using the Design of Experiments commands in JMP. The design table has a table variable named Design with the name of the design type as its value.
Reference Table Variables in Formulas
Table variables can also be incorporated in formulas that you build using the Formula Editor. These formulas calculate values for a column by referring to a table variable. For details about constructing a formula that uses table variables, see “Reference Columns and Table Variables” in the “Formula Editor” chapter.
Use Table Variables in JSL Scripts
You can also incorporate table variables into JSL scripts. See the Scripting Guide for details.
Table Variable Actions
To add new table variables
1. In the Table panel, click the red triangle menu to the left of the data table name.
2. Select New Table Variable.
3. Give the variable a name and value in the boxes labeled Name and Value.
4. Click OK.
The table variable appears in the Table panel.
To view or edit table variables
1. Double-click on the content of an existing table variable.
2. Edit the content.
To edit a table variable name
1. Double-click the table variable name.
2. Edit the name.
To delete table variables
Right-click the table variable name or value and select Delete.
Concatenating Data Tables with Table Variables
Create and Save Scripts
Note: Starting in JMP 10, the Script window is non-modal, meaning that you can access other windows and perform other operations while you are in the Script window.
To automatically complete various analyses and tasks, you can create a JSL script and save it to the data table. See Figure 4.24. For detailed explanations of scripts, see the Scripting Guide.
Figure 4.24 Scripts Saved With the Data Table
Save a Report Script to a Data Table
Once you have run an analysis and you are in the report window, you can add a script to the data table. This script generates the JSL that reproduces your analysis.
To save a script to the data table:
• From the report window, click on the red triangle menu for the platform and select Script > Save Script to Data Table.
Example of Saving a Report Script to a Data Table
First, you create your analysis, then you save the script.
1. Open the Big Class.jmp sample data table.
2. Select Analyze > Fit Y by X.
3. Select weight and click Y, Response.
4. Select height and click X, Factor.
5. Click OK.
6. From the red triangle menu, select Fit Line.
7. From the red triangle menu for Bivariate Fit, select Script > Save Script to Data Table.
Figure 4.25 Click the Red Triangle
The script is added to the bottom of the Table panel.
Tip: If you want a particular script to run automatically every time the data table is opened, name the script OnOpen. Only one script saved in the data table can be set to run automatically. If you name the script Model (or model) in a Fit Model script, the launch window is automatically filled in based on the script when you select Analyze > Fit Model.
Write a JSL Script for the Data Table
To add a script to a data table using JSL:
1. Click the red triangle menu to the left of the data table name in the Table panel. See Figure 4.26.
Figure 4.26 Creating a Script
2. Select New Script.
3. Give the script a name by typing it into the box beside Name.
4. Add the script by entering JSL code into the box beside Script.
5. Perform one of the following actions:
‒ If you want to run the JSL Debugger on the script to check it for errors, click Debug Script.
‒ If you are finished editing the script, click OK. The script appears in the Table panel and the window closes.
‒ If you are not finished editing the script and want to save it, click Save. The script appears in the Table panel and the window remains open for further editing.
‒ If you want to run the script, click Run.
Run, Edit, Delete, or Copy Scripts
To run, edit, delete, or copy a script that is saved to the data table:
1. In the Table panel, click the red triangle menu beside the script’s name, or right-click on the script name.
2. Select one of the following commands:
‒ Run Script
‒ Edit
‒ Delete
‒ Copy
Once you copy a script, you can then paste it into a script window or into the Table panel of another data table.
Compare Data Tables
JMP can compare two open data tables and report the differences between data, scripts, table variables, column names, column properties, and column attributes. Character values that do not match exactly appear in the report. For numeric data, you can select a relative (or fuzzy) comparison. The numeric values are considered equal if they are within the relative error rate that you specify. The smaller the relative error, the more precise the comparison.
To compare two data tables:
1. Open the data tables.
2. In one of the tables, select Tables > Compare Data Tables.
3. If necessary, select the data table that you want to compare from the list.
4. (Optional) Select Fuzzy Compare and enter the relative error to see numeric differences within the specified rate.
5. Click on the red triangle menu and select the following options:
‒ which items you want to compare
‒ how to show the differences
6. Click Compare.
The Difference Summary and Difference Plot are shown by default. The red triangle options that you selected also appear.
Basic Table Information
The Tables Info report shows the data table names and locations along with the numbers of columns and rows in each table. In Figure 4.27, you see that Big Class1.jmp contains one more row than Big Class2.jmp.
Figure 4.27 Basic Information
Compare Data
The interactive Difference Summary report and Different Plot indicate how rows differ between reports. Each entry in the Difference Summary report shows which action occurred, how many rows are affected, and the first row in which the change occurs.
In Figure 4.28, Big Class1.jmp (left) and Big Class2.jmp (right) are compared.
• The first entry in Figure 4.28 indicates that one row (N) has changed (or been replaced) in the first row of Big Class2.jmp. When you select the entry in the Difference Summary report on the left, the entry is highlighted in yellow, and the row flashes in the data table.
For a graphical view of the comparison, place your cursor over a colored cell in the Difference Plot. Figure 4.28 shows that the name KATIE in Big Class1.jmp was changed to KIM in Big Class2.jmp. The entire first row is highlighted in the Difference Plot, which tells you that all values in that row are different.
Figure 4.28 Modified Data
• In Figure 4.29, the second entry indicates that two rows were deleted beginning at row four. The deleted rows are highlighted in Big Class1.jmp on the left. And the Difference Plot specifies the different values. The name in row four of Big Class1.jmp was JACLYN and TIM in Big Class2.jmp.
Figure 4.29 Deleted Rows
• In Figure 4.30, the third entry tells you that one row was added before what was originally row eight. The name in row eight of Big Class1.jmp was ROBERT. PETER is the name in row six of Big Class2.jmp.
Figure 4.30 Identify New Rows
Click the Previous difference and Next difference buttons above the Difference Summary to navigate from row to row.
Tip: Save the Difference Summary report to a data table by selecting Save Difference Summary from the red triangle menu.
Compare Table Properties
Select Compare Table Properties from the red triangle menu to see differences in table scripts and variables. For example, Figure 4.31 shows that the Distribution script in Big Class2.jmp refers to the height column rather than the weight column.
Figure 4.31 Modified Table Script
Compare Column Attributes and Properties
Select Compare Column Attributes and Properties from the red triangle menu to see differences in column notes, cell colors, and the like. For example, Figure 4.32 shows that column notes and value colors differ in Big Class2.jmp.
Figure 4.32 Modified Column Attributes and Properties
Assign Characteristics to Rows and Columns
This section describes how to exclude, hide, label, color, or mark rows and columns in order to customize the appearance of points in scatterplots and graphs. You can also lock columns so that they stay in place when you scroll through the data table.
The menu for row actions can be accessed from the following places:
• the Rows menu in the main menu
• right-click on a row
• the red triangle in the Rows panel
• the left red triangle in the upper left corner of the data grid
Similarly, the menu for columns actions can be accessed from the following places:
• the Cols menu in the main menu
• right-click on a column
• the red triangle in the Columns panel
• the right red triangle in the upper left corner of the data grid
Hide and Exclude Rows
Hiding and excluding rows means that they will be hidden in plots and not they will not be analyzed.
To hide and exclude one or more rows from analyses:
1. Highlight one or more rows that you want to hide and exclude.
2. Right-click on the selected rows and select Hide and Exclude.
or
From the Rows menu, select Hide and Exclude.
Exclude Rows and Columns
Marking rows and columns as excluded means that they will not be analyzed. Note the following:
• Excluded observations are excluded from calculations in text reports and graphs. For most platforms, excluded observations are not hidden in plots.
• Use Hide/Unhide to hide observations in plots and graphs for most platforms. See “Hide Rows and Columns”.
• A circle with a strikethrough (
) appears beside either the row number or the column name in the Columns panel. The circle indicates that the row or column is excluded and therefore not analyzed.
) appears beside either the row number or the column name in the Columns panel. The circle indicates that the row or column is excluded and therefore not analyzed.• For most platforms, data remain excluded until you select Exclude/Unexclude again.
To exclude one or more rows from analyses:
1. Highlight one or more rows that you want to exclude.
2. Right-click on the selected rows and select Exclude/Unexclude.
or
From the Rows menu, select Exclude/Unexclude.
To exclude one or more columns from analyses:
1. Highlight one or more columns that you want to exclude.
2. Select Cols > Exclude/Unexclude or right-click select Exclude/Unexclude.
To unexclude rows or columns:
1. Highlight the excluded rows or columns that you want to include in your analyses.
2. Select Exclude/Unexclude from the Rows menu or Cols menu. You can also right-click rows or columns and select Exclude/Unexclude.
Hide Rows and Columns
Marking rows and columns as hidden means that they do not appear in plots and graphs. Note the following:
• Hiding rows and columns does not exclude them from analyses. They simply do not appear in plots and graphs.
• To exclude hidden observations from analyses, use the Exclude/Unexclude option. See “Exclude Rows and Columns”.
• A mask icon (
) appears beside the hidden row number or the column name, indicating that the row or column is hidden.
) appears beside the hidden row number or the column name, indicating that the row or column is hidden.• Observations remain hidden until you select Hide/Unhide again.
To hide one or more rows:
1. Highlight one or more rows that you want to hide.
2. Right-click on the selected rows and select Hide/Unhide
or
From the Rows menu, select Hide/Unhide.
To hide one or more columns:
1. Highlight one or more columns that you want to hide.
2. Select Cols > Hide/Unhide or right-click and select Hide/Unhide.
To unhide rows or columns:
1. Highlight the hidden rows or columns that you want to show in your plots and graphs.
2. Select Hide/Unhide from the Rows menu or Cols menu. You can also right-click rows or columns and select Hide/Unhide.
Label Rows and Columns
When you position the arrow cursor over a point in a plot, the point’s label appears. By default, row numbers are used as labels. You can customize the labels as follows:
• You can change the label to display column values instead of the row number.
• You can enable the label to always appear, not only when you position the cursor over points.
• A label or yellow tag icon (
) appears beside the column name in the Columns panel, indicating that points on plots are identified by the column value. If there are multiple columns that are labeled, their values appear on plots separated by a comma.
) appears beside the column name in the Columns panel, indicating that points on plots are identified by the column value. If there are multiple columns that are labeled, their values appear on plots separated by a comma.• Data remain labeled until you select Label/Unlabel again.
To change the label to display column values:
1. Highlight one or more columns whose values you want to appear as the label in plots.
2. Select Cols > Label/Unlabel from the menu or right-click and select Label/Unlabel.
To enable the label to always appear (not just when you position the cursor over points):
1. Highlight one or more rows whose label you want to always appear in plots.
2. Select Rows > Label/Unlabel from the menu.
To turn off labeling for rows or columns:
1. Highlight the labeled rows or columns that you no longer want labeled.
2. Select Label/Unlabel from the Rows menu or Cols menu. You can also right-click columns or rows and select Label/Unlabel.
Assign Colors or Markers to Rows
• If you assign a color to a row, the points representing the values in that row are colored in the plot.
• If you assign a marker to a row, the point is replaced with the marker in the plot.
• You can also assign colors or markers based on column values.
Assign a Color to Rows
Assigning a color to selected rows means that the points in plots appear in the color that you select. In the data grid, the active color assigned to a row appears next to the row number.
To assign rows a color:
1. Highlight one or more rows that you want to assign a color to.
2. Right-click on the highlighted rows and select Rows > Colors.
3. Select one of the available colors.
Tip: To clear an assigned color from the selected rows, assign the color black.
Add Markers to Rows
To replace the standard points in plots with a marker, use the JMP markers palette. In the data table, these markers also appear next to row numbers.
1. Highlight one or more rows that you want to apply the marker to.
2. Right-click on the selected rows and select Markers, and then select the marker shape.
Select Other to create custom markers. You can type alphabetic characters, numerals, and other keyboard symbols.
Tip: To return to the default marker, select the initial dot marker.
Assign Colors or Markers to Rows Based on Column Values
You can assign colors or markers to your data table rows based on the values found in a particular column. For example, in a column called Sex, you could assign all rows whose value is F a red circle marker. All rows whose value is M could have a green plus marker. These colors and markers replace the default black dot in plots and appear next to its row number in the data table.
To assign colors or markers to rows based on column values:
1. Select Rows > Color or Mark by Column.
2. Highlight the column to assign the color or marker to. See Figure 4.33.
Figure 4.33 Color or Mark by Column
3. Select the Colors and Markers schemes to apply.
A preview of your selection appears under Row States.
4. (Optional) Select any additional options. See “Color or Mark by Column Options”.
5. Click OK.
6. (Optional) To shade all rows according to their row state, right-click in the row numbers area within the data grid and select Color Rows by Row State.
From then on, the rows are shaded with the color that you assign to the rows.
Color or Mark by Column Options
Colors
select a color theme to assign different colors to the rows in your data table. Color assignment is based on the values of the selected column.
Continuous Scale
assigns colors in a chromatic sequence based on the values in the highlighted column.
Reverse Scale
assigns colors in a reversed chromatic sequence based on the values in the highlighted column.
Markers
assigns a different marker to each row in your data table based on the values found in the column that you highlighted.
Make Window with Legend
Includes a legend with your new characteristics so that you can easily identify which colors and markers correspond with which row.
Save To Column Property
saves the color and marker information as a column property. The rows in the selected column of the data table are colored, based on the color theme.
Save To Table Property
saves the color and marker information as a table property.
Excluded Rows
assigns colors or markers to rows that are excluded.
Create Color Themes
JMP includes several color themes that can distinguish a range of values in a graph. You can also create your own color themes based on an existing color theme or create custom themes.
Note: When you select a default color theme, the colors are not applied to reports that are open. You need to rerun the existing reports to format them with the default color theme.
See “Delete Custom Color Themes” for details on deleting custom color themes.
To create a color theme:
1. Select File > Preferences > Graphs.
2. To either create a new Continuous Color Theme or Categorical Color Theme, click the appropriate color theme.
If you are creating a new continuous color theme, the Continuous Color Themes window appears.
Figure 4.34 Continuous Color Themes Window
If you selected to create a new categorical color theme, the Categorical Color Themes window appears.
Figure 4.35 Categorical Color Themes Window
3. (Optional) To base the theme on an existing theme, select a color themes from the available themes.
4. Click the Custom Color Theme disclosure button to show the Custom Color Theme panel.
Figure 4.36 shows the color theme panels for both continuous and categorical themes (respectively).
Figure 4.36 Custom Color Theme Panel
5. Click New to create a new theme.
A new color theme is created based on the selected color theme. A temporary name is assigned to the theme.
6. Type a new name in place of the temporary label. On Windows, do not press ENTER. The window closes if you do so.
7. To modify the color theme, do any of the following:
‒ To modify the gradient of continuous color, move the sliders left or right.
‒ To add more colors to the gradient, click the color bar to pick a color. A new slider is displayed under the color bar.
‒ To change the color of a slider, click on the slider to display the Color window and choose another color.
‒ To reverse the order of the colors on the gradient, click Reverse.
‒ To distribute the colors evenly on the gradient, click Space Evenly.
‒ To have the custom theme listed in the Sequential pane, select Sequential from the drop-list.
‒ To have the custom theme listed in the Diverging pane, select Diverging from the drop-list.
‒ To have the custom theme listed in the Chromatic pane, select Chromatic from the drop-list.
‒ To prevent a theme from appearing in lists of color themes, select Hidden.
‒ To remove a color from the color theme, click the color’s slider and drag the slider above or below the color bar.
‒ To discard your changes, click Cancel.
8. Click Save to save the custom color theme.
The new custom color theme is appended to the contents of the selected pane.
9. Click OK to close the color theme window.
Continuous and Categorical Color Themes
The following figure shows examples of the two types of color themes in JMP, continuous and categorical. When a color theme is selected for continuous data, the colors are graduated (as shown on the left). When the same color theme is selected for categorical data, the color consists of distinct blocks of color. (as shown on the right).
Figure 4.37 Examples of Continuous and Categorical Color Themes
Custom Color Themes
Custom color themes can be applied in the same way as built-in color themes:
• You can select custom color themes as defaults from the Continuous Color Theme and Categorical Color Theme drop-down menus in the Graphs preferences. Only continuous color themes are available for continuous data. All color themes are available for categorical data.
• You can apply the custom color themes to components such as markers and data table rows. See “Assign Colors or Markers to Rows Based on Column Values” for details.
• In certain reports, such as treemaps and surface plots, you can select specific custom color themes. See the Basic Analysis book for details.
Use Custom Color Themes on Multiple Computers
In Windows, the color themes that you create are defined in the JMP preferences file called JMP.PFS. If you use JMP on more than one computer (for example, at home and at work), you can copy the color theme definitions from one JMP preferences file to another. Custom colors are then available on both computers.
In the preferences file, the code for a custom color theme looks like this:
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
In this example, the name of the color theme is “Pink to Blue.” The Red/Green/Blue (RGB) values for each color slider are located in brackets. The first slider defines the RGB values 255, 168, and 255. The second and third groups of brackets define colors for the second and third sliders.
In a text editor (such as Microsoft Notepad) add this color theme to the preferences file on your other computer. The preferences file is located in your Users folder within the JMP or JMPPro folder.
C:Users<username>AppDataLocalSASJMP<version_number>
Note: To see the preceding folders, you must configure Windows Explorer to show hidden files and folders. For details, refer to the Windows help.
To Transfer Color Themes to Another Windows Computer:
1. On the computer that contains the customized JMP preferences, select File > New > Script.
The Script window appears.
2. Type the following JSL function:
Show Preferences()
3. Click the Run Script button 
.
.Your customized preferences are written to the log.
4. Select View > Log (or display the open log).
The custom color theme that you created appears, for example:
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
This definition might be in the middle of other customized preferences that appear in the log.
5. Save the log as Log.jsl and open the file on the computer whose preferences you are updating.
6. On the computer whose preferences you are updating, close JMP.
7. Make a backup of JMP.PFS, and then open the original JMP.PFS in a text editor.
8. Copy and paste the custom color definition from Log.jsl to JMP.PFS. The definition goes after Preferences( as shown in the following example:
Preferences(
Add Color Theme(
{"Pink to Blue", {{255, 168, 255}, {255, 0, 255}, {0, 128, 255}}}
),
);
Note: Be sure to include the closing parenthesis and comma. The code does not need to be indented. You can put the code in any valid location. Pasting it after Preferences( helps ensure that you do not delete any necessary parentheses or commas.
9. Save the file.
If you open JMP and the new color definition is not displayed in the preferences, delete the updated preferences file and add the definition to the original preferences file. Make sure that you copy and paste the definition in the correct location.
Delete Custom Color Themes
1. Select File > Preferences > Graphs.
2. To either delete a color theme, select the either the Continuous or Categorical Color Theme.
The relevant Color Themes window appears.
3. Click the Custom Color Theme disclosure button to show the Custom Color Theme panel.
4. From the appropriate pane, select the custom color to delete.
Note: You can delete only custom color themes.
5. Click Delete.
6. Click OK to save your changes and close the Color Themes window.
Delete Row Characteristics
To clear all row states in the data table, select Rows > Clear Row States. To clear row states only in selected rows, select Rows > Clear Selected Row States.
All rows become included, visible, unlabeled, and show in plots as black dots. The Clear Row States command does not affect row states saved in row state columns.
Lock Columns in Place
You can lock a column in place so that when you scroll horizontally, the column remains visible. Highlight the columns and select Cols > Scroll Lock/Unlock. Note the following:
• Hidden columns cannot be scroll locked.
• The name of a locked column appears in italics in the Columns panel.
• Scroll locked columns are moved to the left in the data grid. Once you unlock them, they are not moved back to their original locations in the data table, but remain on the left.
• Columns remain scroll locked until you highlight the columns and select Scroll Lock/Unlock again.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.