Click the Office button, and then click Excel Options.
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
Click the Developer tab. Then click the Source button.
Click the Map name list arrow, and then click the XML schema.
Drag the named elements from the XML Source task pane to the corresponding cells.
Click the Header Options button, and then click the header option.