Remove Drop Down Box In Excel For Mac

by
-->

Symptoms

One or more toolbars are missing and cannot be added in Microsoft Excel for Mac.

Cause

Otherwise, Excel validates your data entry but does not show the drop-down button to select items from the list. Notes: You can hide the range of. It’s easy to add a drop-down list to a cell in Excel, but the process is not intuitive. Drop-down lists are created using the Data Validation feature. We’re going to create a drop-down list with a selection of age ranges to show you how it’s done. To begin, enter the list of age ranges into sequential cells down a column or across a row.

If you can't download or save the Windows support software:. After installation completes, click Finish, then click Yes when you're asked to restart your Mac. Lg e2240 driver for mac pro

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

  1. In the upper-right corner of the Excel window, click the oval button.

    Note

    When this button is clicked, the toolbars are hidden (in any Microsoft Office for Mac application). A second click causes the toolbars to be displayed.

    Step 4 Perform DVD Authoring Mac. Insert a blank DVD into your optical drive. Click the button, and the output window will be opened choose an output type from DVD Disc, DVD Folder, ISO Files make a name for the disc adjust the DVD settings to enhance the output quality. Free dvd audio authoring software Top 12 DVD Creators for Mac 1. Wondershare DVD Creator for Mac. Wondershare Video Converter Ultimate for Mac. ISkysoft DVD Creator for Mac. Simply Burns. Express Burn. Roxio Toast Titanium. Tipard DVD Creator.

  2. If the toolbars reappear, quit Excel, and then restart Excel to make sure that the appropriate toolbars are displayed.

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:

  1. On the Apple menu, click Force Quit.
  2. Select an application in the 'Force Quit Applications' window.
  3. Click Force Quit.
  4. Repeate the previous steps until you quit all active applications.

Warning

When an application is force quit, any unsaved changes to open documents are not saved.

Step 2: Remove the Excel Preferences

To remove the Excel preferences, follow these steps.

  1. Quit all Microsoft Office for Mac applications.

  2. On the Go menu, click Home.

  3. Open Library.

    Note

    The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.

  4. Open the Preferences folder. Click View, click Arrange by, and then select Name.

  5. Look for a file that is named com.microsoft.Excel.plist.

  6. If you locate the file, drag the file to the desktop. If you cannot locate the file, the application is using the default preferences.

  7. 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.

  8. Quit all Office for Mac applications.

  9. On the Go menu, click Home.

  10. Open Library.

    Note

    The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.

  11. Open the Preferences folder.

  12. Open the Microsoft Folder.

  13. Look for a file that is named com.microsoft.Excel.prefs.plist.

  14. If you locate the file, move it to the desktop. If cannot locate the file, the application is using the default preferences.

  15. 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.

  16. Close all Office applications.

  17. On the Go menu, click Home.

  18. Open Library.

    Note

    The Library folder is hidden in MAC OS X Lion. To display this folder, hold down the OPTION key while you click the Go menu.

  19. Open the Preferences folder.

  20. Open the Microsoft Folder.

  21. Open the Office 2008 or Office 2011 folder.

  22. Look for a file that is named Excel Toolbars (12) or Microsoft Excel Toolbars.

  23. 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.

In this article, we will learn how to create a Dropdown list with color in Microsoft Excel.
Drop down list limits the user to choose a value from the list provided instead of adding values in sheet.

We will be using Conditional Formatting and Data Validation options.
First, let鈥檚 understand how to make a dropdown list in Excel with an example here

Here is a list of three colours Red, Green and Blue. We need that the user has to select from this list.

Click Data > Data Validation option in Excel 2016

Data Validation dialog box appears as shown above.

Select the option List in Allow and select the source list in Source option and click OK.

A dropdown list will be created on the cell.

Now click Home > Conditional formatting. Select New rule from the list and a dialog box will appear.

Select Specific Text option and select the cell for colour as in this case Red.

Select Format > Fill option. Select the Red colour and click OK.

Repeat the process for all the options like Green and Blue and your list will be shown like in below snapshot.

Drop down list and Conditional formatting tools are very useful in Excel 2016, to view your data in a particular format manner. You can create a dropdown list in google sheets using the same method.

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Check out more related articles:

How to edit a drop down list in Excel?
How to delete drop down list?
How to create dependent drop down list?
How to create multiple dropdown List without repetition using named ranges?
How to create drop down list?

Popular Articles: