Text Boxes

Text boxes are a way to add text to a spreadsheet that is not bound by the cells.

  • Click on the insert tab
  • Then in the text box click text box
  • Your cursore will not point into a vertical arrow pointed down.
  • Click at the upper corner of B36 and drag to E40
Textbox Insert

  • By left clicking on the left corner of the newly formed text box you will see a blinking curser
  • You can now type just like you were in a word processing program.
  • Type in this box "This data is used to show how to sort data."
Textbox Entered
  • You can now click on the lower right hand corner of the textbox and shrink it to the lower corner of C39
  • You can now pick up the textbox and drag it so the upper left had corner is located at the top left hand corner of G29
You can now insert an arrow from the textbox to point at the data.
  • Click the Insert Tab
  • Click Shapes
  • Chose the arrow under lines shape
Arrow

  • Click at the left sizeing box of the textbox
Arrow Start
  • Drag the arrow so the head is at the top left hand corner of F30
  • Click on the arrow
  •  In the Format Tab click and expand the Shape Style box
  • Under Line Styles increase the width to 3
   Arrow Size

  • SAVE YOUR WORK