Interested in becoming an Affiliate Trainer? We are now accepting applications for local and international positions. No need for cold calling! Receive referrals of people looking for specialized training in your area and get access to all of the training curriculum I have created and continue to create to use at your appointments.

Excel 2010 Insert Tab

tables - illustrations - charts - sparklines - filter - links - text - symbols

EXCEL 2010 INSERT RIBBON

Illustrations

EXCEL 2010 ILLUSTRATIONS GROUP

The Illustrations section allows you to add pictures, Clip Art, Shapes, SmartArt and Screenshots to your worksheet. This is a great way to improve the aesthetics and to drive home your point.

To insert a picture to your worksheet, first select the cell where you would like the top of your picture to start in. Note: Your picture will take up numerous cells, but you can resize it as needed. Now select Picture from the Illustrations section of the Insert tab. A dialog box will appear, allowing you to browse through your pictures. Select your desired picture and select Insert. Once the picture has been inserted, click on the handles to adjust its size.

Go to the Insert tab again and select Clip Art from the Illustrations section. On the right hand side of your document, you will see the Clip Art bar. Type in the Search for box and select Go. Double click on any Clip Art to insert it. Drag it and place it wherever you want.

EXCEL 2010 INSERT CLIP ART

In order to add Shapes, go to the Illustrations section of the Insert tab again. Be sure the cells in which you want to add the shape are empty. Click on the Shapes button. Select the shape you want to insert and then press the Alt key. Drag the mouse pointer across the cells in which you would like to contain the shape. As shown in the figure below, we selected a rectangle and dragged the shape from cells A1 through H4.

When the shape is selected, a Drawing Tools Format tab will appear in the ribbon. You can further format your shape in this tab.

EXCEL 2010 INSERT SHAPES

Here is our shape after adding color, text and a border from the Drawing Tools Format tab:

EXCEL 2010 DRAWING TOOLS FORMAT

Next, we will show you how to add SmartArt in Excel 2010. Select the SmartArt button from the Illustrations section of the Insert tab. A SmartArt dialog box will appear where you can select from various types of SmartArt styles. In our example, we will select the List tab and the Vertical Box List as shown in the image below. Select OK after making your selections.

EXCEL 2010 INSERT SMARTART

The Vertical Box List will be inserted into your worksheet. Click on the double headed arrow to bring up the text box (shown in the image below). You can type any text into the text box and hit the Enter key. This will add another bullet to the list. You can close the text box when you are done by clicking on the “x” in the top-right corner. You can now resize the SmartArt once it has been placed on the sheet. 

EXCEL 2010 INSERT SMARTART

Notice the SmartArt Tools Design and Format tab appear in your ribbon when working in your SmartArt. These will allow you to further enhance your SmartArt and drive home your point.

EXCEL 2010 INSERT SCREENSHOT

The last button in the Insert section of the Illustrations tab is Screenshot. This will allow you to grab a screenshot from another window and add it to your Excel document.

To get started, ensure you have the document open where you would like to capture a screenshot.

 

Select the Screenshot button and a drop-down window will open that shows the available windows (as shown in the image above). Click on one of these windows and the entire screen shot will be inserted into your Excel worksheet. Click Screen Clipping from the drop-down menu to select only a portion of the screenshot to insert. See the inserted Screen Clipping below.

EXCEL 2010 INSERT SCREEN CLIPPING




Move and resize the Screen Clipping as needed.

Next Tutorial


This concludes the Illustrations tutorial.
Click next to continue to the Excel 2010 Charts tutorial.