programming4us
 
Office
 

Microsoft Excel 2010 : Working with Graphics - Inserting Clip Art, Inserting a Picture from File

4/16/2014 2:35:01 AM

Inserting Clip Art

Clip art adds visual interest to your Excel worksheets. With Microsoft clip art, you can choose from numerous professionally prepared images, sounds, and movie clips. After you add graphics, you can move them around in the worksheet and even assign text wrapping.



1. Click the Clip Art button on the Insert tab to open the Clip Art task pane.

2. Type a description for the clip art you are looking for in the Search for Text box, and press Enter (or click the Go button).

3. If Microsoft has clip art that matches the description you type, it displays in the Clip Art task pane. Click an image in the results list to insert it into your worksheet.

4. The clip art is inserted into your worksheet.


Tip: The Picture Tools Format Tab

If you click on any picture or clip art, you will see a new Picture Tools Format tab. There, you will find tools to crop, format, adjust contrast, apply effects, and most anything else you would typically do to a picture.


Inserting a Picture from File

Often times, you will want to embed your own company-approved pictures into your worksheet. A good example of this is a company logo. Excel is quite flexible and allows you to insert varying types of picture files: Bitmap files, JPEG files, PNG Files, TIF files, PCX files, and many more.



1. On the Insert tab, click the Picture button to open the Insert Picture dialog box.

2. Locate the file you want to use, and click it to see a preview. (You might need to select Preview from the dialog box Views button).

3. Click the Insert button.

4. The image is inserted into your worksheet.


Tip: Manage Overlapping Picture Objects

If you have multiple pictures on your worksheet, you can manage how the pictures overlap each other. Right-click on each picture and select either Send to Back or Bring to Front. This way, you can better control the layout of your pictures, and even layer your pictures to create robust visualizations.


 
Others
 
- Microsoft Excel 2010 : Working with Graphics - Using Drawing Tools
- Microsoft Excel 2010 : Automating Repetitive Tasks by Using Macros - Running Macros When a Workbook Is Opened
- Microsoft Excel 2010 : Automating Repetitive Tasks by Using Macros - Running Macros When a Button Is Clicked
- Microsoft Excel 2010 : Automating Repetitive Tasks by Using Macros - Creating and Modifying Macros
- Microsoft Excel 2010 : Enabling and Examining Macros (part 2) - Examining Macros
- Microsoft Excel 2010 : Enabling and Examining Macros (part 1) - Macro Security in Excel 2010
- Microsoft Project 2010 : Maintaining Baselines (part 3) - Resetting a Baseline , Multiple Baselines
- Microsoft Project 2010 : Maintaining Baselines (part 2) - Rolling-Wave Planning with Baselines
- Microsoft Project 2010 : Maintaining Baselines (part 1) - Clearing a Baseline
- Microsoft Project 2010 : Viewing Baselines (part 2) - Formatting the Gantt Chart to Display the Baseline
 
 
REVIEW
 
- First look: Apple Watch

- 10 Amazing Tools You Should Be Using with Dropbox

- Sigma 24mm f/1.4 DG HSM Art

- Canon EF11-24mm f/4L USM

- Creative Sound Blaster Roar 2

- Alienware 17 - Dell's Alienware laptops

- Smartwatch : Wellograph

- Xiaomi Redmi 2
 
VIDEO TUTORIAL
 
- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 1)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 2)

- How to create your first Swimlane Diagram or Cross-Functional Flowchart Diagram by using Microsoft Visio 2010 (Part 3)
 
Popular tags
 
Video Tutorail Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
 
Top 10
 
- Setup Free Media Server To Stream Videos To DLNA Compatible TV, Xbox 360 & PS3 (Play Station 3)
- How To Install Android Market & Google Apps On Kindle Fire
- How To Make Ubuntu Look Like Windows 7
- How To Add A New Account in MS Outlook 2013
- Get Android & Mac OS X Style Gadgets For Windows 7 & Windows 8 With XWidget
- How To Activate Microsoft Office 2013
- How To Install Actual Facebook App On Kindle Fire
- How To Create, View And Edit Microsoft Office Files On Kindle Fire
- Download Attractive Business PowerPoint Templates For Free At SlideHunter
- How To Use And Enable Hibernate & Sleep Mode In Windows 8