Insert a Text Box into Worksheet in MS Excel 2010


You can easily insert a Text Box anywhere on an Excel Worksheet. The Text Box can be increased in size or decreased in size to meet your data requirements. This comes in very handy when you want your data to be put into a separate box so that it looks well organized and it when you want to find your data quickly and easily. Follow these simple steps to insert a Text Box into an Excel worksheet.


1) Open the Excel worksheet where you want to insert a Text Box; then click on the “Insert Tab” under the Ribbon and then under the Ribbon go to the ‘Text’ category and click on ‘Text Box’ icon. See Figure 1 for details.



Figure 1


2) Now a small text box appears on your worksheet as soon as you click on it. The Text Box size can be increased or decreased as per the requirements. See Figure 2 and 3 for details.



Figure 2




Figure 3



3) Now you can enter the data into the Text box and apply formatting to the Text and the Text Box as per your requirements using the ‘Format tools’ in the Ribbon. See figure 4 for details.



Figure 4


So, this is how you can insert a text Box into an Excel Worksheet.


Read Other Applications