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