Resize a shape or text box to fit its text

  1. Click the border of the AutoShape (AutoShapes: A group of ready-made shapes that includes basic shapes, such as rectangles and circles, plus a variety of lines and connectors, block arrows, flowchart symbols, stars and banners, and callouts.) or text box you want to resize.
  2. If you selected an AutoShape or a text box, click AutoShape or Text Box on the Format menu, and then click the Alignment tab.
  3. Select the Automatic size check box.

 Note   If you later change the size of the AutoShape or text box, you must fit the AutoShape or text box to the text again by selecting the Automatic size check box.

Applies to:
Excel 2003