• Excel Video Tutorials

Add Text Box in Excel 2010


Advertisements

Text Boxes

Text boxes are special graphic objects that combine the text with a rectangular graphic object. Text boxes and cell comments are similar in displaying the text in rectangular box. But text boxes are always visible, while cell comments become visible after selecting the cell.

Adding Text Boxes

To add a text box, perform the below actions.

  • Choose Insert » Text Box » choose text box or draw it.

Initially, the comment consists of Computer's user name. You have to modify it with text for the cell comment.

Comments

Formatting Text Box

After you have added the text box, you can format it by changing the font, font size, font style, and alignment, etc. Let us see some of the important options of formatting a text box.

  • Fill − Specifies the filling of text box like No fill, solid fill. Also specifying the transparency of text box fill.

  • Line Colour − Specifies the line colour and transparency of the line.

  • Line Style − Specifies the line style and width.

  • Size − Specifies the size of the text box.

  • Properties − Specifies some properties of the text box.

  • Text Box − Specifies text box layout, Auto-fit option and internal margins.

Comments

Useful Video Courses


Video

MS Excel Online Training

Most Popular

102 Lectures 10 hours

Pavan Lalwani

Video

Excel VBA Online Training

101 Lectures 6 hours

Pavan Lalwani

Video

Advanced Excel (Power Query) Online Training

Best Seller

56 Lectures 5.5 hours

Pavan Lalwani

Video

Excel Dashboard Crash Course

63 Lectures 3.5 hours

Yoda Learning

Video

Advanced Excel Crash Course

134 Lectures 8.5 hours

Yoda Learning

Video

Microsoft Excel Masterclass for Business Managers

33 Lectures 3 hours

Abhishek And Pukhraj

Advertisements