"Excel 2007 Add-in - How Add-ins Can Enhance the Functionality of Your Excel Program"


Excel 2007 add-in is program that adds additional functionality or features to Excel. Installing add-ins gives you additional Excel features not available in the Ribbon by default.

Excel add-ins are use to store one or more custom worksheet functions. When the add-in is loaded, you can use the functions like any built-in worksheet function.

There are three different types of add-ins:

  • Built-in add-ins available when you install Excel 2007
  • Add-ins that you can download from Microsoft web site (http://www.office.microsoft.com)
  • Add-ins developed by third-party vendors (must be purchased)

When you first install Excel 2007, the built-in add-in programs included with Excel are not loaded and therefore are not yet ready to use. The following are the steps to load the built-in add-in programs.


To install an Excel 2007 add-in

  • From the Office button, click the Excel Options button.
  • From the Excel Options dialog box displayed, click Add-Ins in the left hand pane.
  • Excel 2007 options

  • Select an add-in (such as Analysis ToolPak) under the Inactive Application Add-ins on the right-hand pane and click Go button (near the bottom of the screen).
  • From the Add-Ins dialog box displayed, you can access to several options.
  • Excel 2007 add-ins

  • Click to select one or more add-in (such as Analysis ToolPak).
  • Click OK.
  • From the pop-up dialog box, click Yes to install the add-in. It will takes some time to configures.

Note: Excel places the Data Analysis add-in on the Data tab, Analysis group. Some other add-ins will be places on the Add-Ins tab.


To remove an add-in in Excel 2007

  • From the Office button, click the Excel Options button.
  • From the Excel Options dialog box displayed, click Add-Ins in the left hand pane.
  • Select an add-in (such as Analysis ToolPak) under the Active Application Add-ins on the right-hand pane and click Go button.
  • From the Add-Ins dialog box displayed, click to deselect the add-in you want to remove.
  • Click OK. Excel removes the add-in.


Related Topics:

Customizing and Adding Commands to the Quick Access Toolbar in Excel 2007

Guide to Highlight and Remove Duplicates Values in Excel 2007

How to View Multiple Worksheets at the Same Time in Excel 2007?

How To Protect Excel Worksheet or Workbook with the Password?

Using the Watch Window Feature in Microsoft Excel 2007!

How to Create Excel 2007 Drop Down List? - The Simple Way

How to Create the Excel 2007 Data Validation Rules?



Can't find what you're looking for? Try Google Search!

Custom Search


Back to Top

You're viewing the Excel 2007 add-in info page, click here to go back to the Home Page

Add To Your Social Bookmarks: add to BlinkBlink add to Del.icio.usDel.icio.us add to DiggDigg
add to FurlFurl add to GoogleGoogle add to SimpySimpy add to SpurlSpurl Bookmark at TechnoratiTechnorati add to YahooY! MyWeb


Google Search:

Custom Search

Recommended Books:

Click on the image to view the details of the book.
Excel 2007 ebook
The Ultimate Guide to
Excel 2007!


PowerPoint 2007 ebook
The Ultimate Guide to
PowerPoint 2007




XML RSS
What is this?
Add to My Yahoo!
Add to My MSN
Add to Google


Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?

Copyright © www.msoffice-tutorial-training.com. All Rights Reserved.