To insert a simple textbox in a worksheet,a TextBox button is provided in the Text group of Insert tab.

The text box is saved as a drawing in the sheet.There is a referance in the sheet,as

<drawing r:id="rId1" />

which is linked through 'slideX.xml.rels'.

The description of the text box is hence defined in a xml file called 'drawing1.xml'.

Say the text box,is from column C3 to E6,then the contents of the 'drawing1.xml',will be

<xdr:wsDr xmlns:xdr="http/../spreadsheetDrawing" .....>

<xdr:twoCellAnchor>

               <xdr:from>

                           <xdr:col>2</xdr:col>

                           <xdr:colOff>66675</xdr:colOff>

                           <xdr:row>2</xdr:row>

                           <xdr:rowOff>95250</xdr:rowOff>

               </xdr:from>

               <xdr:to>

                           <xdr:col>4</xdr:col>

                           <xdr:colOff>285750</xdr:colOff>

                           <xdr:row>5</xdr:row>

                          <xdr:rowOff>95250</xdr:rowOff>

            </xdr:to>

            <xdr:sp >

                     <xdr:nvSpPr>

                              <xdr:cNvPr id="2" name="TextBox 1"/>

                              <xdr:cNvSpPr txBox="1"/>

                  </xdr:nvSpPr>

                  <xdr:spPr>

                              <a:xfrm>

                                          <a:off x="1285875" y="476250"/>

                                          <a:ext cx="1438275" cy="571500"/>

                           </a:xfrm>

                          <a:prstGeom prst="rect">

                                      <a:avLst/>

                          </a:prstGeom>

                         <a:solidFill>

                               <a:schemeClr val="lt1"/>

                         </a:solidFill>

                         <a:ln w="9525" cmpd="sng">

                                 <a:solidFill>

                                             <a:schemeClr val="lt1">

                                                      <a:shade val="50000"/>

                                             </a:schemeClr>

                              </a:solidFill>

                      </a:ln>

                 </xdr:spPr>

                 <xdr:txBody>

                           <a:bodyPr wrap="square" anchor="t"/>

                           <a:lstStyle/>

                           <a:p>

                                 <a:r>

                                          <a:rPr lang="en-US" sz="1100"/>

                                                            <a:t>Some Text</a:t>

                                 </a:r>

                        </a:p>

               </xdr:txBody>

         </xdr:sp>

   <xdr:clientData/>

  </xdr:twoCellAnchor>

</xdr:wsDr>

Here,'xdr:from' specifies top and left anchor point of the drawing,and similarly,'xdr:to' specifies the bottom and right anchor point of the drawing,with anchor as the column number and row number.

'colOff' and 'rowOff',are the offset values within the cells(in EMUs)

Then is the shape,which is a rectangle,specified by the node,'prstGeom prst'.

and the size specified by the 'xfrm'

The border line of the shape and the colour to be filled in specified by the nodes,'solidFill' and 'ln ' respectively.

Element 'ln',which is for 'Line Properties' also describes the line colour.

the attribute 'cmpd' specifies a compound line type,which are of type,

1.sng(Single)

2. dbl(double)

3.thickThin

4.thinThick

5.tri

'txBody',holds the textbox contents,with properties such as

'anchor',of type

1. 't',top

2 b',bottom

3.'ctr',middle

4.'dist',Anchor the text so that it is distributed vertically.

5.'just',justified

'wrap',gives text wrapping options,either'square' or 'none'