To format a shape individually inside a group, just select the shape you want to format and do your formatting (resize, reshape, etc.). You can also drag, resize the shapes as a group or individually. You will see that all the shapes have been grouped. Now, right click on any of the shapes and select Group. Holding the CTRL key you can select all the shapes. and You can also create attractive labels. You can move or resize multiple shapes as you wish. You can group your shapes, word arts, or text boxes. You can change shapes, fix the width and height, change colors, give different effects, etc. Note: From the Shape Format ribbon you can customize both text and the shapes, Word Arts, and Text Boxes. You can also select a text box from Illustrations.ĭouble click on the shape to write any text in the shape. #3 Inserting Text in a Shapeįrom the Insert ribbon go to the Illustrations and select any shape you like. You can also drag the dots in the outline to get your preferred size. #2 Inserting Text in a Word Artįrom the Insert ribbon go to the Text tools and select Word Art. Then drag your left click to create a Textbox as per your preferred size. #1 Inserting Text in a Textboxįrom the Insert ribbon go to the Text tools and select Textbox. You can use a shape, textbox, or word art to insert texts and all of them acts similarly. Textboxes in excel also have a few interesting functionalities, so let’s look at them.įirst, let’s start with how to insert a text box in excel. To eliminate this problem and keep notes or display certain information you can use a textbox. So, sometimes they can get cluttered and someone who isn’t the editor of the sheet can delete or alter some formulas and the data set. These applications include various formulas and functions.

Excel’s fundamental usage lies in data analysis and mathematical applications.

How to add shapes in excel 2013