The Insert Tab of Microsoft Excel 2007

The Insert Tab of Microsoft Excel 2007

The insert menu of Excel 2007 is useful in inserting various objects to your Excel document. It has commands for inserting tables, pictures, shapes, smart art, and clip art among others to your worksheet. It has got five groups that have been discussed here in details.

The Insert Tab of Excel 2007

The Insert Tab of Excel 2007
The Insert Tab of Excel 2007 | Source

Tables Group

Pivot Table – use this command to insert a pivot table. A pivot table makes it easy to arrange and summarize complicated data making it easy to work with. You can also insert a pivot chart using the drop down button.

Table – this command creates a table which then can be used to manage and analyze related data. Tables make it easy to sort, filter, and format data within a sheet.

Illustrations Group

Picture – use this command to insert a picture from a file to your worksheet.

Clip Art – this tool is for inserting clip arts, drawings, movies, sounds and stock photography to illustrate a specific concept.

Shapes – use this to insert ready made shapes for instance arrows, lines, equation shapes, rectangles and circles, flow chart symbols and callouts.

SmartArt – this command inserts a smart art graphic to visually communicate information. You can make use of graphical lists, process diagrams, complex graphics, and many more.

The Charts Group

The charts group is very useful for inserting different types of charts. These are the chart types you can insert; column, line, pie, bar, area, scatter chart, or choose from other charts options.

Links Group

Hyperlink – use this tool to create a link to webpage, a picture, a file, an email address, or another program.

Charts Option in Excel

Different types of charts that you can choose from
Different types of charts that you can choose from | Source

The Text Group

Text Box – use this command to insert a text box that can be placed anywhere on the worksheet. Then you can type anything you want inside the text box.

Header and footer – use this option to edit the header or footer of the document. The header appears at the top of the document whereas the footer appears at the bottom of the document.

WordArt – this tool helps you to insert decorative text to your document.

Signature Line – this command inserts a signature line that specifies the individual who must sign the document.

Object – this inserts an embedded object for instance video clip, wave sound, package, among others.

Symbol – this is the tool you need to insert the characters that are not on your keyboard such as copyright symbol, trademark symbol, paragraph marks, and Unicode characters.

Excel Charts

Do you know how to insert charts in Excel?

See results without voting

© 2013 Patrick Kamau

More by this Author


Comments 2 comments

Patkay profile image

Patkay 3 years ago from Nairobi, Kenya Author

Thanks lucy, keep reading. I am glad you liked this tutorial.


lucy 3 years ago

good work patkay keepup

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working