You can also add shapes, text boxes, and other graphics to convey information and make your worksheets more visually appealing.
- [Instructor] Most people think Excel is only good for analyzing data using formulas, charts, Pivot Tables, and such. That's certainly what Excel is best at, but you can also add shapes, text boxes, and other graphics to convey information and make your worksheets more visually appealing. In this movie, I will show you how to create and format shapes. My sample file is the Shapes workbook, and you can find it in the chapter eight folder of the exercise files collection. This is a blank workbook, and what I'd like to do is demonstrate how to add shapes.
To do that, I will go to the Insert tab of the ribbon, and then click the Shapes button, and here I see a variety of shapes that I can use. In my case, I will use a rounded rectangle, so I'll click that from the top of the recently used shapes section, and my mouse pointer, when I move it over the body of the worksheet, turns into a thin black crosshair. I can now drag to draw the shape, and you see that it appears when I release the left mouse button.
This shape, like most other shapes and images that you put into Excel, can be resized and moved. If you want to move it, just move the mouse pointer over it, you'll see it changes to a four-way pointing arrow, and just drag it left and right. If you want to resize it, you can use the handles. So here's a side handle, I can make it narrower or wider, and if I chose the top or bottom handle, then I could drag up or down to make it taller or shorter.
I can also drag from a corner to move it in both dimensions at once like that, and you can see the width and height at the bottom. If you want to rotate it, you can use the rotate controls at the top of the shape. I'll drag down a little bit so it's easier to see. And you can rotate it, and you can see the degree of rotation there, it snaps to 90 degrees, and as with all adjustments, if you press command Z, it will undo whatever it was that you just did.
If you want to change a shape's format, you can do that in a couple of ways. The first is to apply a built-in style. While the shape is selected, on the Shape Format contextual tab of the ribbon, you can go to the Shape Style gallery and, I'll hover my mouse pointer over it and click the down arrow, and you see that you get a gallery of available styles. I'll switch it to this white to black with white text. There you go, see I get kind of a gradient, or gradual effect there.
If, on the other hand, I want to change the fill color only, I can got to the Shape Fill button, click it, and then select a fill color, I'll go with, let's say that I'll go with a dark blue. I can also change the color of the outline. I'll click the line, currently it is set to, looks like a medium blue, so I will change it to a darker orange just for contrast. And then finally, you can apply effects to it.
So we have a current number of presets, and I'll just find one here. I'll do one that is laying down, three-dimensional and bezeled, and as you can see, that's actually a very attractive effect. If I click away, you can see that the image is actually quite nice. If you want to add text to an image, you can double click it and then the image will appear, and I'll type in Solar Panels, and click away.
You can see that it's been added, and if I click the shape, then I can format the text within it. You currently see that it is left-aligned. If I click the center button on the home tab of the ribbon, then the text is centered, I can also make it larger. There we have solar panels, I'll go back down so it doesn't spill over. And I could also change the text color if I wanted to. When you create a worksheet that requires data entry, you can use shapes that contain text to provide instructions for anyone who used the worksheet.
Shapes are great for providing information, but make sure that they don't detract from the data that is behind the presentation.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.