Specifically, one must use the column heading “Structure” for both of those functions to work.
Materials used in this article are linked in the zip file at the end of the article, so you can try out the demonstrations yourself.Ĭreating chemically-active spreadsheets.This article demonstrates usage of both functions. The screenshots use Microsoft Excel 2003, but we discuss how the same functions work in Microsoft Excel 2007 as well. The sample CDX files were created in ChemBioDraw Ultra version 12, but will work in earlier versions and non-Ultra versions of ChemDraw as well.
More detailed descriptions of other ChemDraw/Excel functionality are referenced in this article and are linked at the end.ĬhemDraw is available as an Excel Add-In, but several steps must be taken before it can be used.
