As an example, if you had data in cells A1 through A100, drag the lower right corner of B1 down to B100 to copy the formula to all 100 cells. Cells B1 through B100 remain selected.

You'll need to create a data map, define the XML tags and then map them to the columns in the worksheet before you can export the XML file. Launch Microsoft Excel 2003.