Alternatively, in Word, Excel and PowerPoint you can view your add-ins by selecting Home > Add-ins. You can directly install popular add-ins on the page or go to More Add-ins to explore. Select the add-in and select Add .

SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint.

If you set up your list source as an Excel table, then all you need to do is add or remove items from the list, and Excel will automatically update any associated drop-downs for you. To add an item, go to the end of the list and type the new item. To remove an item, press Delete.

Click File > Get Add-ins. Alternatively, you can click Home > Add-ins. You can directly install add-ins from this page or select More Add-ins to explore. In the Office Add-ins box, click Store tab. Browse for the add-in you want.

Add-ins provide optional commands and features for Microsoft Excel. By default, 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. Some add-ins are built in to Excel, such as Solver and the Analysis ToolPak.

You can now get Office Add-ins from the Store or use add-ins you already have from right within recent versions of Word for Mac and Excel for Mac. There are two kinds of add-ins: Office Add-ins from the Office Store (which use web technologies like HTML, CSS and JavaScript) and add-ins made by using Visual Basic for Applications (VBA).

COM Add-ins are typically used to automate Excel in response to a click of a CommandBar button, a form or dialog box, or some other event specific to Excel such as opening or closing workbooks or entering data on worksheets. COM Add-in functions cannot be directly called from cell formulas in worksheets.

If you toggle into the new Outlook for Windows from classic Outlook for Windows, you'll be prompted to import settings from that app. Otherwise, you'll be given the option to import certain Windows settings.

Use an add-in while composing a message. Create a new message or reply to an existing one. From the ribbon, select the Message tab, then choose the add-in you want to use. If the add-in doesn’t appear in the ribbon, select Apps to view your installed add-ins.

If an Office add-in isn’t showing up in the Office Add-ins list, refresh the list to see all of your add-ins. In Word 2016, Excel 2016, or PowerPoint 2016, click Insert > My Add-ins. In Project 2016, click Project > My Add-ins. Then click Refresh to update the list in the Office Add-ins dialog.