cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Lcheng
Level II

How does one copy the same data down across several rows?

You know how one can drag or double click to copy a cell down to the end in Excel. Is there an easy way to do that in JMP? 

Or is the best way just to type up my data in Excel which is much easier/faster for me? 

2 ACCEPTED SOLUTIONS

Accepted Solutions
txnelson
Super User

Re: How does one copy the same data down across several rows?

Just right click on the cell you want copied, and then select Fill, you will be given 2 options....

txnelson_0-1623463649103.png

 

Jim

View solution in original post

Re: How does one copy the same data down across several rows?

To add to what Jim posted: the choices JMP presents to you when you right-click depend on the data you've selected. For example:

 

If you've selected the first few terms in an arithmetic or geometric sequence, JMP will offer to continue (or, alternatively, repeat) the sequence.

 

If you've selected a range of cells where there are "gaps" of missing values, JMP will present an option to replace the missing values with previously encountered values.

 

Cheers,

Brady

 

View solution in original post

2 REPLIES 2
txnelson
Super User

Re: How does one copy the same data down across several rows?

Just right click on the cell you want copied, and then select Fill, you will be given 2 options....

txnelson_0-1623463649103.png

 

Jim

Re: How does one copy the same data down across several rows?

To add to what Jim posted: the choices JMP presents to you when you right-click depend on the data you've selected. For example:

 

If you've selected the first few terms in an arithmetic or geometric sequence, JMP will offer to continue (or, alternatively, repeat) the sequence.

 

If you've selected a range of cells where there are "gaps" of missing values, JMP will present an option to replace the missing values with previously encountered values.

 

Cheers,

Brady