Resize a shape or text box to fit its text

Microsoft Office Excel 2003

Show All Show All

Resize a shape or text box to fit its text

  1. Click the border of the AutoShape 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.