Displaying Chemical Formulas in Microsoft Excel
E. Joseph Billo · Journal of Chemical Education · 1996
An Excel macro which automates the entry of subscripts in Excel spreadsheets is described. The macro is assigned to a custom button on Excel's standard toolbar, so that, after typing a text label containing a chemical formula, clicking the button automatically formats the text as a chemical formula. The macro operates on text in a cell, a range of cells, or text used as a chart label. Versions are available for either Windows or Macintosh computers, for either Excel 5.0 or Excel 4.0.