How To Create a Text Box in Excel

Use text boxes in your Excel document to enhance your workbook presentation. It’s easy to insert a text box anywhere in your Microsoft Excel worksheet. The text box can be resized and reshape according to your preference. Besides text, you can use text boxes as placeholders for pictures or other objects. Below are steps and guides on how to create a text box in Microsoft Excel.

  • Open a Microsoft Excel document. You can create a new workbook or open a new excel document. It doesn’t matter if you’re using Microsoft Excel 2010 or the previous versions.
  • Create your text box. Click Insert then find and click the Text Box icon form the toolbar. Drag your mouse to create your text box. Move the text box in your desired location. Click the text box and drag its edges to resize it.
  • Format your text box. To format the shape of your text box, click the text box that you need to reshape then right click and select Format Shape from the drop down menu. Among the formatting choices are fill, line color, line style, shadow, 3-D format, 3-D location, picture, and text box. To format the size and properties of your text box, click the text box that you desire to format then right click and select Size and Properties. The editing choices include size, properties, and alt text (alternative text). Use alt text if you’re going to upload your workbook online. Web browsers are displaying alternative text while waiting for your document to download. Web search engines use alt text to find Web pages easily. Alt text also helps computer users with disabilities. If you need a singular size text box for a workbook project, click the current text box, right click your mouse, and select Set as Default Text Box from the drop down menu.
  • Format the content of your text box. Choose a font type and font size. Write the content of your text box. After typing the text, highlight the words that you want to format then right click and select Format Text Effects from the drop down menu. Among the choices are text fill, text outline, outline style, shadow, 3-D format, 3-D rotation, and text box. If you want to format the shape of your text, do the same procedure for formatting the words in your text box. Among the selections in Format Shape are fill, line color, line style, shadow, 3-D format, 3-D rotation, picture and text box.
  • Other text box options. If you want to rotate your text box manually, put your cursor on the green button above the text box and rotate the text box according to your desired angle. You can also create a text box within a text box for aesthetic and practical reasons. If you need to create workbooks with similar tasks or design, then use Assign Macro to record repetitive actions and use those actions in your future workbooks to save you time. Click on the text box or any other item in your Excel file that you want to have a master copy, then right click and choose Assign Macro in the drop down menu.


Excel is a wonderful tool in accounting and other applications where you need calculation. As you use Microsoft Excel, you’ll master its interface and the other benefits that Excel is offering.

 

Share this article!

Follow us!

Find more helpful articles: