ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

The Insert Tab of Microsoft Excel 2007

Updated on September 14, 2019
Patkay profile image

Patrick, a computer technician, is a dedicated writer who wishes to make the world better by informing individuals who seek more knowledge.

The Insert Tab of Microsoft Excel 2007

Using the Insert Menu

The insert menu of Microsoft Office Excel 2007 is useful in inserting various objects into 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 herein details. If you are unsure what the function of a feature is, hover the cursor over the button (in Excel) to see a pop-up box explaining the feature. If you want to collapse the ribbon so that none of the buttons are displayed, double-click the name of the tab.

The Insert Tab of Excel 2007

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

Tables Group

Working With the Table Group Option

We use this option to insert the dynamic table, Pivot table and recommended table.

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. This option is also having a recommended table that means on the basis of data, we can just insert the table as per the Excel’s recommendation.

Illustrations Group

What You Can Insert Using 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 much more.

The Charts Group

Working With Charts in Excel

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.

Column - Insert a column chart. Column charts are used to compare values across categories. If chart data is selected, or the cursor is in or adjacent to the data, pressing F11 automatically creates a column chart.

Line - Insert a line chart. Line charts are used to display trends over time.

Pie - Insert a pie chart. Pie charts display the contribution of each value to a total. Use a pie chart when values can be added together or when you have only one data series and all values are positive.

Bar - Insert a bar chart. Bar charts are the best chart type for comparing multiple values.

Area - Insert an area chart. Area charts emphasize differences between several sets of data over a period of time.

Scatter chart - Insert a Scatter chart, also known as an X-Y chart. This type of chart compares pairs of values. Use a Scatter chart when the values being charted are not in X-axis order or when they represent separate measurements.

Or choose from other charts options - where you will be able to insert a stock, surface, doughnut, bubble, or radar chart.

Links Group

Hyperlink – use this tool to create a link to a web page, 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

Header and Footer Option in Excel

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.

The Ribbon (Home, Insert, Page Layout & Formula Tabs) Review

Excel Charts

Do you know how to insert charts in Excel?

See results

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2013 Patrick Kamau


    0 of 8192 characters used
    Post Comment
    • profile image


      22 months ago

      9122763539 par whatsapp karen excel note

    • Patkay profile imageAUTHOR

      Patrick Kamau 

      7 years ago from Nairobi, Kenya

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

    • profile image


      7 years ago

      good work patkay keepup


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)