top of page
Writer's pictureGetSpreadsheet Expert

FIVE STEPS TO INSTALL ADD-INS IN EXCEL

Add-ins in Excel are optional features and commands that perform a particular set of activities. To use add-ins, you need to set them up as they are not installed by default in Excel. While Excel has its free add-ins, many platforms sell it for money. You can either install add-ins from Excel or purchase them online. 



Learn five steps to install add-ins in excel
FIVE STEPS TO INSTALL ADD-INS IN EXCEL

Add-ins in Excel can be categorized as,

 

  • Excel add-ins: These add-ins can be activated and used once you have Excel. These are free add-ins, and to use them, you only need to install Excel and activate the add-ins.

 

  • Some of the Excel add-ins include solver, analysis toolpak, etc.

 

  • Downloadable add-ins: Apart from the add-ins installed from Excel, add-ins are available at office.com. You can download these add-ins and use them to ease your work in Excel. 

 

  • Custom add-ins: Custom add-ins are designed by developers and solution providers. These include VBA add-ins, COM add-ins, automation add-ins, etc. These, too, need to be installed to be able to use. 


 

To work on any add-in, you must install it first. Here is the installation process of add-ins, which is in five simple steps. 

 

1.     Save the Add-in file in your system 

  • First, you must save the add-in after downloading it on your computer to install the add-ins. 

  • Creating a separate folder is suggested for all the add-ins, and keep saving the downloads there. 

 

2.     Open an Excel file > File tab > Options > Select Add-Ins from the left menu.

 

3.     In the options window, select Excel add-ins in the manage dropdown and press GO. 

 

Here, you can easily install the Excel available add-ins, including the Excel toolpak, currency tools, solver, and VBA toolpak. To install a downloaded add-in, follow the next step.

 

4.     Click the Browse button from the add-ins menu, locate the file you saved in the first step and select it. 

     The add-in will now appear along with the other Excel add-ins.

 

5.     Select the add-in by checking the box beside it and press OK. 

 

You have completed the installation process and can use the add-in. 


Similarly, you can install COM add-ins and activate them while the first two steps remain the same; in the third step, you need to choose COM add-ins in the manage dropdown and then select the appropriate add-in that you wish to add or remove by checking the box beside each add-in. 


Using add-ins in Excel makes work more accessible and more fun. Try using different add-ins in Excel, and let us know in the comment section which one you like the most.

Comments


bottom of page