Excel Tip: Text Boxes

 

 

The lowly text box is one of many unsung features in all versions of Excel. While it lurks on the Drawing toolbar of Excel 2003 and earlier, the Text Box icon resides prominently on the Insert tab of Excel 2007 and 2010.

 

Use text boxes anytime you need to put a paragraph or more of text into a spreadsheet. This saves you from having to manually merge cells and wrap text within your worksheet.

 

In addition, Excel 2007 and 2010 users can create bulleted lists within a text box by selecting text within a text box and making a choice from the right-click menu. To create a text box, simply click the icon, draw a box on your worksheet with your mouse, and then add your text.

 

Read more of David's helpful Excel tips [1].