Some add-ins are built in to Excel, such as Solver and 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, and DLL add-ins. These add-ins must also be installed to use them.
Most add-ins can be categorized into three different types:
Bạn đang xem: How to add add ins in excel
-
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 and the Analysis ToolPak, may be available after you install Excel or Microsoft Office. Typically, you only need to activate these add-ins to use them.
-
Xem thêm: Tổng hợp code đại kiếm vương
Downloadable add-ins Additional add-ins for Excel can be downloaded and installed from Downloads at Office.com.
-
Custom add-ins Developers and solution providers usually design custom Component Object Model (COM) add-ins, automation add-ins, VBA add-ins, and XLL add-ins. These must be installed for you to 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:
-
Xem thêm: Chụp ảnh chân dung đẹp
Data tab. After you install and activate the Analysis ToolPak and Solver add-ins, the Data Analysis and Solver commands are available in the Analysis group.
-
Formulas tab. After you install and activate the Euro Currency Tools, the Euro Conversion and Euro Formatting commands are displayed in the Solutions group.
-
Add-Ins tab. Other add-ins may be added to the Add-Ins tab. This tab is added to the ribbon when you install and 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 and 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.
Xem thêm: Cách sửa lỗi bảo mật
