Insert Drawing Objects into your Excel Spreadsheets

<div dir="ltr" style="text-align: left;" trbidi="on"> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> A drawing can liven up a dull spreadsheet. Some good line art, or even simple shapes, can help illustrate your data. In this lesson, you'll see how to add simple shapes, and textboxes to your spreadsheet.</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <br /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> First, look at the spreadsheet below. Unless you know about Cosines, Adjacent angles, and Hypotenuse, the data below will be a bit bewildering:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="An Excel 2007 Spreadsheet" height="160" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes.gif" width="410" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> However, add a few shapes, along with some colour, and it becomes clearer what the data is for (the Cosine in the image below has been formatted to 2 decimal places):</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="An Excel 2007 spreadsheet with Shapes" height="441" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes3.gif" width="603" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> We'll now show you how to produce a spreadsheet like the one above. Don't worry if you haven't a clue about Cosines - it's not important for this lesson. (We'll show you the formula, though.)</div> <h3 align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> How to Draw a Shape on an Excel Spreadsheet</h3> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> To insert a shape on your spreadsheet, do the following.</div> <ul style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <li>From the Excel Ribbon, click on <b>Insert</b></li> <li>Locate the <b>Shapes</b> panel:</li> </ul> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Shapes in Excel 2007" height="85" src="http://www.homeandlearn.co.uk/excel2007/images/2ShapesPanel.gif" width="144" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> For Excel 2013 users, locate the <b>Illustrations</b> panel instead. The Shapes item is on there:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Shapes in Excel 2013" src="http://www.homeandlearn.co.uk/excel2007/images/2013/section3/shapes.gif" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> On the <b>Shapes</b> panel, click the drop down arrow to see all the available shapes:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Available Shapes" height="575" src="http://www.homeandlearn.co.uk/excel2007/images/2ShapesPanel2.gif" width="261" /></div> <ul style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <li>Under <b>Basic Shapes</b>, select the <b>Right Triangle</b></li> <li>Hold down your left mouse button on your spreadsheet, and drag to create your shape. Let go when you have a decent sized triangle. You'll see something like this:</li> </ul> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="A triangle on the spreadsheet" border="1" height="239" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes4.gif" width="253" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> The green circle (white in Excel 2013) allows you to rotate the shape. The other circles (and squares) are sizing handles. Hold your mouse down over one of these and drag to resize your shape, if it's not the size you want it.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> But we'd like the triangle pointing the other way. So hold your mouse down on the green circle, and drag to rotate your triangle:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="238" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes5.gif" width="254" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> You should see an outline, like the one above. Let go of your left mouse button when it is in position:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Rotate the Shape" border="1" height="219" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes6.gif" width="255" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> As you can see, the green circle is now on the left hand side.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> If you look on the Excel Ribbon at the top, you'll notice that it has changed - a<b>Format</b> tab has appeared. You'll see all the various options for shapes. Locate<b>Shape Fill</b> on the <b>Shape Styles</b> panel, and click to see the <b>Fill</b> options:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Shapes Fill" height="311" src="http://www.homeandlearn.co.uk/excel2007/images/2ShapesShapFill.gif" width="174" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Select a colour for your triangle. You'll also want to select a <b>Shape Outline</b>, underneath Shape Fill. Select the same colour as your Fill, and your triangle will look something like this one:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="212" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes7.gif" width="255" /></div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <br /></div> <h3 align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Add a Text Box to an Excel Spreadsheet</h3> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> To get the letter B in the triangle, we'll add a text box. So, on the <b>Insert Shapes</b>panel again, you'll notice a Text Box option. Click on this to select it:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Insert Shapes panel > Text Box" height="85" src="http://www.homeandlearn.co.uk/excel2007/images/2ShapestextBox.gif" width="239" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Excel 2013 users have a separate Text panel, on the left hand side. Click the Text Box item:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="Text Box in Excel 2013" height="92" src="http://www.homeandlearn.co.uk/excel2007/images/2013/section3/text_panel.gif" width="249" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Now move back to your spreadsheet, hold down your left mouse button, and drag out a Text Box. Let go of the left mouse button and you'll have something like this:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="73" src="http://www.homeandlearn.co.uk/excel2007/images/2ShapesTextBox2.gif" width="73" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> With the cursor inside of the Text Box, simply type the letter B. Because it's text, you can highlight your letter and format it. In the image below, we've increased the font size:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="69" src="http://www.homeandlearn.co.uk/excel2007/images/2ShapestextBox3.gif" width="76" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> We now need to drag our Text Box onto the shape. Move your mouse over the Text Box until the cursor changes shape to four arrowheads (this can be tricky):</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="90" src="http://www.homeandlearn.co.uk/excel2007/images/2ShapestextBox4.gif" width="125" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> Once your cursor changes shape, hold down the left mouse button and drag your Text Box on to the triangle:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="219" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes8.gif" width="254" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> With the Text Box selected, use the arrow keys on your keyboard to nudge it in to position. Fill the Text Box in the same way as you did for the triangle. To get rid of the text box border, click <b>Shape Outline</b> just below <b>Shape Fill</b>. Set it to <b>No Outline</b>. It will then look like this:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="219" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes9.gif" width="255" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> If you need to move your triangle and Text Box, you can select them both at the same time, and drag them as one. Click on your Triangle to select it. Now hold down the CTRL key on your keyboard. With the CTRL key held down, click on your Text Box. Both will now be selected:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="219" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes10.gif" width="255" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> With both the triangle and the Text Box selected, hold your mouse over the selected shapes. When your cursor changes to the four arrowheads, hold down the left button and drag your shapes to a new position:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="218" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes11.gif" width="252" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> You can finish off the formatting in the normal way. In the image below, we selected all the cells surrounding the shape, and added a background colour from the <b>Home</b>menu, <b>Font</b> panel.</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img border="1" height="237" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes12.gif" width="379" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> If you look again at the finished version, you'll see the rest of the colours we chose. These are just filled cells from the <b>Home > Font </b>panel:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <img alt="The finished spreadsheet" height="441" src="http://www.homeandlearn.co.uk/excel2007/images/2Shapes3.gif" width="603" /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> The text in the cells is just entered in the normal way. The formula for the Cosine in cell G22 of our spreadsheet has this syntax:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <b>=DEGREES(COS(Adjacent_Cell_Reference / Hypotenuse_ Cell_Reference))</b></div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> An example of how to use is it this:</div> <div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <b>=DEGREES(</b>COS(F18 / F10)<b>)</b></div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> When the user types in a value for the Hypotenuse or the Adjacent, the Cosine number will change.</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> But you can add any shapes you want to liven up your spreadsheet. It doesn't have to look plain, white and dull!</div> <div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> <br /></div> <div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;"> And that completes this beginners course on Excel. It may have a little taxing along the way, but if you've finished all of it, you should have quite a few new skills to show off!</div> </div>

Insert Drawing Objects into your Excel Spreadsheets

A drawing can liven up a dull spreadsheet. Some good line art, or even simple shapes, can help illustrate your data. In this lesson, you...

Read more »