Combo box in Excel 2011 for Mac

albert_sun

New Member
Joined
Aug 5, 2013
Messages
1
Hi,

I had a macro-enabled spreadsheet works well in windows PC, and now I want to make it work on Mac. When I open the spreadsheet in excel 2011 on mac, I noticed the following problems for combo boxes.

1). In windows version, when you click on a drop down list, the content will show, and then you can click to select from the drop down list, but in Mac version, when you click on the drop down list, you have to hold to select from the list. Is this something related with the keyboard settings? I am using the mac track pad, not trying the mouse yet.

2). When there are more than one drop down list contained in one page, choosing from one drop down list will make other drop down lists invisible, but other drop down list still there. When you click the field of one of other drop down list, it will bring back all the lists. How to avoid this problem?

Thanks.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Forum statistics

Threads
1,216,091
Messages
6,128,779
Members
449,468
Latest member
AGreen17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top