About single-mapped cells

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

A single-mapped cell is cell that has been mapped to an non-repeating XML element.

Create a single-mapped cell

A single-mapped cell is created by dragging a non-repeating XML element from the XML Source task pane onto your worksheet.

When you drag a non-repeating XML element onto the worksheet, you can choose to include the element name as a heading above or just to the left of the single-mapped cell. Or, you can use an existing cell value as a heading.

Use a Formula in an single-mapped cell

You can use a formula in an single-mapped cell if the cell is mapped to an XML element with an XML Schema Definition (XSD) data type that Excel interprets as a number, date, or time. See XML Schema Definition (XSD) data type support for more information about how Microsoft Excel supports XSD data types.

Hide the border of a single-mapped cell

By default, a single-mapped cell is displayed with a border. To turn off the border, click List on the Data menu, and then click Hide Border of Inactive Lists.

Note  This setting affects all Excel lists, XML lists, and single-mapped cells in the workbook. You cannot hide the border of a particular single-mapped cell.