Excel for hacam.vn 365 Excel for hacam.vn 365 for Mac Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel năm nhâm thìn for Mac More...Less

Add-ins provide optional commands & features for hacam.vn Excel. By mặc định, add-ins are not immediately available in Excel, so you must first install and (in some cases) activate these add-ins so that you can use them.

Bạn đang xem: Cách tạo và sử dụng add

Are you looking for information about Office Add-ins based on HTML, CSS, and JS? If you are, see Get an Office Add-in for Excel.


Some add-ins are built in khổng lồ Excel, such as Solver và the Analysis ToolPak. Other add-ins are available from the Download Center and must first be downloaded and installed. Finally, there are add-ins that are created by third parties, such as a programmer in your organization or a software solution provider. These can be Component Object Model (COM) add-ins, Visual Basic for Applications (VBA) add-ins, và DLL add-ins. These add-ins must also be installed to lớn use them.

Most add-ins can be categorized inlớn three different types:

Excel add-ins These typically include Excel add-in (.xlam), Excel 97-2003 add-in (.xla), or DLL add-in (.xll) files or they are automation add-ins. Some Excel add-ins, such as Solver và the Analysis ToolPak, may be available after you install Excel or hacam.vn Office. Typically, you only need lớn activate these add-ins to use them.

Custom add-ins Developers & solution providers usually design custom Component Object Model (COM) add-ins, automation add-ins, VBA add-ins, và XLL add-ins. These must be installed for you to use them.

After you have sầu installed or activated an add-in, the add-in và its commands may be available in one of the following locations:

Data tab. After you install và activate the Analysis ToolPak and Solver add-ins, the Data Analysis & Solver commands are available in the Analysis group.

*

Formulas tab. After you install and activate the triệu Euro Currency Tools, the Euro Conversion & Euro Formatting commands are displayed in the Solutions group.

*

Add-Ins tab. Other add-ins may be added lớn the Add-Ins tab. This tab is added khổng lồ the ribbon when you install và activate the first add-in that is shown in the Add-Ins tab. If you don"t see the Add-Ins tab, you should exit & then restart Excel.

Other add-ins, such as the Get Started tab, are available in other places in Excel, such as a tab on the ribbon, or through macros or customized menus.


To activate an Excel add-in

Cliông chồng the File tab, cliông chồng Options, and then click the Add-Ins category.

In the Manage box, click Excel Add-ins, & then click Go.

The Add-Ins dialog box appears.

In the Add-Ins available box, select the check box next to lớn the add-in that you want to lớn activate, and then clichồng OK.

If you cannot find the add-in that you want to lớn activate in the Add-Ins available box, you may need lớn install it.

To install an Excel add-in

To install an add-in that is typically installed with Excel, such as Solver or the Analysis ToolPak, run the cài đặt program for Excel or hacam.vn Office và choose the Change option to install the add-in. After you restart Excel, the add-in should appear in the Add-Ins available box.

Some Excel add-ins are located on your computer & can be installed or activated by clicking Browse (in the Add-Ins dialog box) to locate the add-in, & then clicking OK.

Some Excel add-ins require running an installation package. You may need to download or copy the installation package to lớn your computer (an installation package is typically a file with an .myêu thích tệp tin name extension), và then run it.

To inactivate an Excel add-in

Cliông chồng the File tab, cliông chồng Options, and then cliông chồng the Add-Ins category.

In the Manage box, click Excel Add-ins, and then cliông chồng Go.

In the Add-Ins available box, clear the kiểm tra box next lớn the add-in that you want khổng lồ inactivate, và then cliông xã OK.

In many cases, when you inactivate an add-in, it is removed from its group on the ribbon. In other cases, khổng lồ remove the add-in from the ribbon, you may need khổng lồ restart Excel.

Note Inactivating an add-in does not remove the add-in from your computer. To remove sầu the add-in from your computer, you must uninstall it.

To remove sầu an Excel add-in


Important: If you originally installed the Excel add-in from a network file VPS or from a shared folder, you might need lớn remove the add-in from that location. If you installed the Excel add-in from a CD và you mapped your CD drive khổng lồ a new drive sầu letter after installing the add-in, you need khổng lồ reinstall the add-in from the CD. If you are running any Excel add-ins from the CD, you must uninstall the Excel add-ins, and then reinstall them from the CD.


Cliông chồng the File tab, and then click Exit.

In Control Panel, clichồng Programs & Features (Windows 7 và Windows Vista) or Add/Remove sầu Programs (Windows XP).

Do one of the following:

If you installed Excel as part of hacam.vn Office, cliông xã hacam.vn Office in the menu of installed programs, and then cliông chồng the Change button.

If you installed Excel individually, cliông chồng the name of your program in the list of installed programs, and then clichồng the Change button.

If you installed the add-in from the Download Center, cliông chồng the name of your program in the danh mục of installed programs, và then clichồng the Uninstall button.

Follow the instructions in the installation program.

Xem thêm: Hướng Dẫn In Hai Mặt Trong Word 2013 Tiết Kiệm Giấy Hiệu Quả


Add a COM add-in

Cliông xã the File tab, cliông chồng Options, & then clichồng the Add-Ins category.

In the Manage box, cliông xã COM Add-ins, and then cliông chồng Go.

The COM Add-Ins dialog box appears.

In the Add-Ins available box, select the kiểm tra box next lớn the add-in that you want lớn install, and then cliông xã OK.

Tip If the add-in that you want lớn use is not listed in the Add-Ins available box, clichồng Add, và then locate the add-in.

Remove a COM add-in

Cliông xã the File tab, click Options, & then clichồng the Add-Ins category.

In the Manage box, clichồng COM Add-ins, and then click Go.

The COM Add-Ins dialog box appears.

In the Add-Ins available box, clear the check box next lớn the add-in that you want lớn remove, and then cliông xã OK.

Note This removes the add-in from memory but keeps its name in the các mục of available add-ins. It does not delete the add-in from your computer.

To remove a COM add-in from the danh sách of available add-ins và lớn delete the add-in from your computer, cliông xã its name in the Add-ins available box, và then clichồng Remove.


Cliông chồng the File tab, cliông chồng Options, and then click the Add-Ins category.

In the Manage box, click Excel Add-ins, and then cliông chồng Go.

The Add-Ins dialog box appears.

To install an automation add-in, in the Automation servers available box, cliông chồng Automation, và then cliông xã the add-in that you want.

Tip If the add-in that you want isn"t in the list, cliông xã Browse, locate the add-in, và then cliông xã OK.

To remove an automation add-in, you must remove it from the registry. See your system administrator for details.


Some add-ins are built in to Excel, such as Solver và the Analysis ToolPak. Other add-ins are available from the Download Center và must first be downloaded & installed. Finally, there are add-ins that are created by third parties, such as a programmer in your organization or a software solution provider. These can be Component Object Model (COM) add-ins, Visual Basic for Applications (VBA) add-ins, and DLL add-ins. These add-ins must also be installed to use them.

Most add-ins can be categorized into three different types:

Excel add-ins These typically include Excel add-in (.xlam), Excel 97-2003 add-in (.xla), or DLL add-in (.xll) files or they are automation add-ins. Some Excel add-ins, such as Solver & the Analysis ToolPak, may be available after you install Excel or hacam.vn Office. Typically, you only need to activate these add-ins lớn use them.

Custom add-ins Developers và solution providers usually design custom Component Object Model (COM) add-ins, automation add-ins, VBA add-ins, và XLL add-ins. These must be installed for you to lớn use them.

After you have installed or activated an add-in, the add-in and its commands may be available in one of the following locations:

Data tab. After you install & activate the Analysis ToolPak và Solver add-ins, the Data Analysis and Solver commands are available in the Data tab on the ribbon.

Home tab. Other add-ins may be added lớn the Home tab.

Other add-ins, such as the Get Started tab, are available in other places in Excel, such as a tab on the ribbon, or through macros or customized menus.


To activate a pre-installed Excel add-in

On the Tools menu, select Add-ins.

In the Add-Ins available box, select the kiểm tra box for the Add-in you want to lớn activate, & then cliông xã OK.

To install an Excel add-in

Some Excel add-ins are located on your computer and can be installed or activated by clicking Browse (in the Add-Ins dialog box above) khổng lồ locate the add-in, và then clicking OK.

Some Excel add-ins require running an installation package. You may need lớn tải về or copy the installation package khổng lồ your computer (an installation package is typically a tệp tin with an .mđê mê tệp tin name extension), và then run it.

Other add-ins that are not available on your computer can be downloaded và installed through a Web browser from Downloads or from other sites on the Internet, a hệ thống in your organization, , or using the built-in Store option in Excel. Follow the thiết lập instructions for the download as needed.