"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.

• 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.

• 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!

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: Blink Del.icio.us Digg
Furl Google Simpy Spurl Technorati Y! MyWeb