This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Input a single value to multiple selected cells in data table at once (excel CTRL+enter equivalent)
2 weeks ago(292 views)
Hi all, I was wondering if there is a good way to enter a single value (such as "1") into all cells which I have selected in a data table. In Excel you would do this by pressing CTRL+enter after setting the value for the cells. The workaround I'm using is to write the value in notepad, select the value, copy it to clipboard and in JMP data table on top of selected cells click "paste". This just does not feel right.
My use case is labelling data groups: I have a visualization open in graph explorer. I select a population from the graph, and want to insert a population ID number onto a new column in the data table, then select another population and set its population ID and so on...
Jarmo's response is a good way to handle this. I will many times use a different approach. I place into the paste buffer the value I want repeated, then is I simply use CNTL/V the paste buffer value will be copied to all selected cells.