This page will guide you through installing an Excel add-in file for Excel 2011 for Mac. Installation instructions for the Windows versions of Excel can be found here.
What Is An Excel Add-in?
An add-in file is an Excel file that contains macros (code) and has the extension “.xla” or “.xlam”. When opened, the worksheets in the file are hidden and the macros are typically accessed through buttons that are added to the toolbar or command menu. Once installed, an add-in will automatically open every time Excel is opened.
Try the Recommended Charts command on the Insert tab to quickly create a chart that’s just right for your data. Select the data you want to chart. Click the Insert tab, and then do one of the following: Click Recommended Charts and select the chart type you want. Microsoft Excel, the spreadsheet app, lets you create, view, edit, and share your files quickly and easily. Manage spreadsheets, tables and workbooks attached to email messages from your phone with this powerful productivity app from Microsoft.
Apr 09, 2017 Question: Q: how do i get word and excel on my mac. Till now have been using a acer laptop. Can any one help with the following. I want to transfer all my data( mostly word, excel and photos) to my Mac. What software do i use to in Mac to be able to use the word and excel. Iam not computer savy so going nuts now.
Installation Guide
Installing the add-in is pretty easy, and should only take a few minutes. 1. Save the add-in file to your computer.
- Pick any folder on your hard drive that is easy for you to find.
- My suggestion is to create a folder named “Excel Campus” and place it in your Documents folder.
2. Open the Add-ins Menu in Excel.
- Select the Tools menu in menu bar.
- Select the Add-Ins… option.
3. Press the Select… button in the Add-Ins window.
4. Find the add-in file that you saved on your computer in Step 1.
- Then press the Open button.
5. The add-in file should now appear in the list of available add-ins in the Add-Ins window. Seagate software for mac.
- The checkbox should automatically be checked.
- Press the OK button.
6. Installation Complete – The add-in is now installed and should automatically open every time to you open excel.
How to Uninstall an Add-in
To uninstall the add-in:
- Open the Add-ins menu again.
- Uncheck the box next to the add-in you want to uninstall.
- Press OK.
The add-in file will be closed, and it will not re-open next time you open Excel.
If you want to permanently remove the add-in name from the list:
- Delete the add-in file from your computer or move it to a new folder.
- Open the Add-in Menu.
- You will be prompted to delete the Add-in file that cannot be found.
- Press Yes.
- The add-in will be removed from the Add-ins list.
- Press OK.
What's Next?
Checkout the Tab Hound and Tab Control add-ins for Mac. These two tools will save you a ton of time with your everyday worksheet tasks.
Excel For Mac 2019
Don't forget to signup for my free email newsletter below to stay updated with new articles. You will also receive a free gift to help you learn Excel.
Please leave a comment below with any questions.
-->Symptoms
One or more toolbars are missing and cannot be added in Microsoft Excel for Mac.
Cause
There are two possible causes of this behavior:
- The oval button in the upper-right corner of the document was clicked. This button 'toggles' the display of toolbars on and off.
- There is an issue with Excel preferences.
Resolution
To resolve this issue, use the following methods in order.
Method 1: Make sure that toolbar display is not turned off
- In the upper-right corner of the Excel window, click the oval button.NoteWhen this button is clicked, the toolbars are hidden (in any Microsoft Office for Mac application). A second click causes the toolbars to be displayed.
- If the toolbars reappear, quit Excel, and then restart Excel to make sure that the appropriate toolbars are displayed.
![Macbook Macbook](/uploads/1/3/4/1/134143551/407338598.png)
If Method 1 did not resolve the problem, try Method 2.
Method 2: Remove the Excel preferences
Step 1: Quit all applications
To quit active applications, follow these steps:
- On the Apple menu, click Force Quit.
- Select an application in the 'Force Quit Applications' window.
- Click Force Quit.
- Repeate the previous steps until you quit all active applications.
Warning
Excell For Macbook
When an application is force quit, any unsaved changes to open documents are not saved.
Step 2: Remove the Excel Preferences
Excel For Mac Cost
To remove the Excel preferences, follow these steps.
- Quit all Microsoft Office for Mac applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder. Click View, click Arrange by, and then select Name.
- Look for a file that is named com.microsoft.Excel.plist.
- If you locate the file, drag the file to the desktop. If you cannot locate the file, the application is using the default preferences.
- If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.plist file to the trash.
- Quit all Office for Mac applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library Airy downloader for mac. folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder.
- Open the Microsoft Folder.
- Look for a file that is named com.microsoft.Excel.prefs.plist.
- If you locate the file, move it to the desktop. If cannot locate the file, the application is using the default preferences.
- If you locate the file and move it to the desktop, start Excel, and then check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. Then, go to the next step. If the problem seems to be resolved, you can move the com.microsoft.Excel.prefs.plist file to the trash.
- Sewart for mac. Close all Office applications.
- On the Go menu, click Home.
- Open Library.NoteThe Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.
- Open the Preferences folder.
- Open the Microsoft Folder.
- Open the Office 2008 or Office 2011 folder.
- Look for a file that is named Excel Toolbars (12) or Microsoft Excel Toolbars.
- If you locate the file, move it to the desktop. If you cannot locate the file, the application is using the default preferences.
If you locate the file and move it to the desktop, start Excel, and check whether the problem still occurs. If the problem still occurs, quit Excel, and restore the file to its original location. If the problem seems to be resolved, you can move the Excel Toolbars (12) file or the Microsoft Excel Toolbars to the trash.
Note
If the problem still occurs after you follow these steps, the problem is not related to these files. If the problem no longer occurs, one of these files was causing the problem. If this is the case, restore the files to their original location one at a time. Test the application after you restore each file. Continue to do this until the problem occurs again. When the problem recurs, you can then assume that it is caused by the last file that you restored. Drag that file to the trash.