dearomatize entire column of structures

I have successfully used JCStandardizeStructure to display one dearomatized structure,

=JCStandardizeStructure(A2, "dearomatize")

but I would like to apply it to an entire column of structures.   How can I do this?

I'm using JChem for Excel 1.1.3 and Excel 2007.

Hi,

sure. You have to simply fill the formula to the other cells. Excel 2007 offers several ways to do that:

http://office.microsoft.com/en-us/excel/HP101023421033.aspx

It does not mention that in excel 2007 you can also double click on the bottom right corner of the cell (on the small black square), and it will automatically fill it for all rows.

Best regards,

Tamas.