This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Add Text to Any Closed Shape
Problem: How can I add fixed text to a shape?
Strategy: All closed shapes can hold text. To add text to a shape, you simply right-click the shape and choose Edit Text.
Figure 1293 Add text to any shape with the Edit Text command.
Excel will add a flashing insertion cursor inside the shape. You type your text, pressing Enter when you want to start a new line.
Additional Details: To format the text, you select the characters with the mouse and then move the mouse up and to the right to display the Mini toolbar. You can use the formatting icons on the Mini toolbar to change the font.
Figure 1294 Select text. Move up and to the right for the Mini toolbar.