Adding multiple points in spreadsheet (A1, A2, ... etc)

Grobe shared this question 7 years ago

Answered

Hi.

Is there a way to add multiple points directly, but the names of those becomes A1, A2, etc - instead of A, B, etc?

Alternatively: I want to place a bunch of points manually. Can I somehow select all of those and renaming them into A1, A2, etc?

Thanks

The same question

Comments (4)

slik ● 7 years ago

Hi,

One way. If you have a document that contains something like...

A1=(4,7)

B1=(3,3)

B7=(4,6) etc

Create a button, then copy and paste the text into the button script. Run the button and the points are created in the spreadsheet. You can now delete the button.

Simon

Reply URL

jumera ● 7 years ago

Alternatively: I want to place a bunch of points manually. Can I somehow select all of those and renaming them into A1, A2, etc?

Thanks

First, select points A,B,...

f1e7f89df3891ef707c96877ebdd03f0

Then drag points in spreadsheet (in A1)

9ecc464f3bedc01f8d6f0f8e7dee4937

Finally, (un)show points A,B,... (or delete them !)

1c84f53a8e3a7f57482e68641bad7075

Files: 1.png 2.png 3.png

Reply URL

Grobe ● 7 years ago

Thanks jumera. I was trying your method, and I realized that I'm also able to delete the original points right afterward because they're still selected.

Reply URL

Michael Borcherds ● 7 years ago

This will create some random points in cells A1:A10

Reply URL