Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
When you create headings and other text in Excel you can either put them in the header or footer or in a worksheet cell. Both of those techniques limit where you can place your text, but you can create WordArt text that you can move anywhere in your worksheet. To do that, you click the Insert menu header and then click WordArt. When you do, Excel displays a WordArt textbox, and it also gives you a bunch of shape styles and other formatting tools that you can use. We'll get to those in a second. First I will type in some text, and I'll just type in 'Two Trees.' You can see that the text - and I'll click away from it to see you can see it - the text is one substantially larger than the standard text, and also it has some very distinct formatting. And WordArt has a number of formatting options already built-in.
So, for example, if I select the WordArt object - and I do that by moving the mouse pointer over the edge of the object until it's a four-way pointing arrow and then I click so that it's selected - now I won't be editing the text; I'm editing the object as a whole. If I want, I can apply an existing style, and those are here in the Styles gallery. When I hover over it and I click the Expand button, I can select any one of these WordArt styles, and I'll select this one with the Olive Green.
Once I have applied a style, I can start making changes to it. So, for example, if I want to change the fill color to say something a little bit darker, maybe a darker olive green, I can do that. Also, if I want to change the line, right now we have a white line around the edges of the letters. If I click the Line button and click black, then Excel applies a black line around it. And I can also change text effects. So, for example, if I click Effects button and I apply a shadow to the letters, I'll go for a lower shadow, click there, Excel adds it to my WordArt.
You can also change the formatting of the shaped surrounding the WordArt. So when I click away, you see that there are no formatting elements there. It's all just blank, or see-through, so I will click the WordArt and select it, again, with my mouse pointer is a four-way arrow, and then I'll go up and select the shape style. If I hover over the gallery, I can click the Expand button, and I will select white with green. When I click away, there is my shape. Creating WordArt text lets you add decorative text to your worksheets.
In addition to using the built-in designs, you can control the text color and effects so you get exactly the look you want.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98360 Viewers
80 Video lessons · 141468 Viewers
59 Video lessons · 59818 Viewers
52 Video lessons · 73020 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.