MS Excel 2007 - Lesson 9: Insert images and graphics into a spreadsheet
TipsMake.com - You can insert images, Clip Art, Shape, and SmartArt into spreadsheets to make the data table more vivid and intuitive. Adding images or other graphic objects in Excel 2007 is quite simple, as long as you know where the extra commands are located on the menu. See the instructions for inserting graphics into Excel 2007 spreadsheets below.
Add images to spreadsheets in Excel 2007
To add an image:
• Click the Insert tab
• Click the Picture button
• Browse photos
• Click on the name of the image you want to insert
• Click Insert
• To move the image, click and drag it to where you want
Insert Clip Art into Excel 2007
To add Clip Art:
• Click the Insert tab
• Click the Clip Art button
• Find patterns by using the Clip Art search dialog
• Click Clip Art
• To move the pattern, click and drag it to where you want
Edit photos after inserting
When you add an image to the spreadsheet, a new tab appears on the Ribbon. The Format tab allows you to format images and graphics. This tab has 4 groups:
- Adjust : Adjust brightness, contrast and color for photos
- Picture Style : Allows you to place a frame or border around the image and add effects to the image.
- Arrange : Adjust image alignment and rotation
- Size : Cut and resize images
Insert Shape (image) in Excel 2007
To add a picture:
• Click the Insert tab
• Click the Shapes button
• Click on the image you choose
• Click on the spreadsheet
• Click and drag the dots at the edge of the border to enlarge the shape
To format images:
• Click on the picture
• Click the Format tab
Insert SmartArt into Excel 2007
SmartArt is a feature in Office 2007, allowing you to choose from a number of different graphics including charts, lists, circles and processes. To add SmartArt:
• Click the Insert tab
• Click the SmartArt button
• Click SmartArt you choose
• Select SmartArt
• Drag it to the desired position in the spreadsheet
To format SmartArt:
• Select SmartArt
• Click the Design or Format tab
• Click SmartArt to add content and images.
Next article: MS Excel 2007 - Lesson 11: Spreadsheet format
Last lesson: MS Excel 2007 - Lesson 8: Sort and Filter
You should read it
- MS Excel 2007 - Lesson 7: Create Macros in Excel 2007
- MS Excel 2007 - Lesson 6: Calculation in Excel
- MS Excel 2007 - Lesson 8: Sort and Filter
- MS Excel 2007 - Lesson 3: Working with Workbook
- MS Excel 2007 - Lesson 1: Start Microsoft Excel 2007
- Instructions for inserting an image into an Excel spreadsheet
- MS Excel 2007 - Lesson 10: Modify columns, rows and cells
- How to create SmartArt graphics in Excel
May be interested
- Excel 2016 - Lesson 7: Formatting Excel spreadsheets - Complete guide to Excel 2016if you have read the article about microsoft word, you must have grasped some basic knowledge about text alignment. let's refer to the article on formatting spreadsheet data in excel 2016 in this article!
- MS Word - Lesson 9: Insert pictures, mathematical characters, especially on documentsword 2007 allows you to insert special characters, symbols, images, illustrations and watermarks.
- MS Excel - Lesson 9: Protect spreadsheets and Excel filesexcel spreadsheet and file protection features allow document protection and only authorized people can open it.
- How to insert a fixed image into a cell in excelthe following video article tipsmake will guide you how to insert fixed images into a cell in excel extremely detailed
- MS Excel 2003 - Lesson 1: Get familiar with Microsoft Excelexcel 2003 spreadsheet has a maximum of 256 columns and 65,536 lines; the maximum number of worksheets you can add is 255 sheets. with this huge number, managing tables will become much simpler.
- MS Excel - Lesson 4: Working with lines, columns, sheetsin addition to the content of tables in excel, operations with lines, columns and sheets in this program are also important. in this article, tipsmake.com will guide you to simple operation to add or remove lines, columns or sheets in excel tables.
- MS Excel 2007 - Lesson 7: Create Macros in Excel 2007macros are advanced features, which can speed up editing or formatting that you can do regularly in an excel spreadsheet. in this excel lesson, tipsmake.com will show you how to use macros in excel 2007.
- How to change worksheet size in Excelexcel has settings for you to resize the spreadsheet, adjusting it to display all columns and rows on the same page. or if needed, users can also adjust the number of printed pages displayed for preview before printing.
- MS Excel 2003 - Lesson 2: Format spreadsheet datatipsmake.com will guide you how to format data in excel 2003, detailing font options, data types, how to align data in cells, spreadsheets.
- How to print an Excel spreadsheet in a pageexcel is a great useful spreadsheet program, but nothing is worse than creating a perfect spreadsheet and printing it on multiple sheets of paper that have pages with only one column or row. read this article and follow the tips below to get a nice print!