Cannot see "insert" control in Excel developer tab?

Question

Hi, I have Excel for Mac version 15.39.

I want to add a check button to a worksheet but from searching help it seems I need to do it by inserting a control if I want to be able to resize it.

I can't see the "insert" button in the control area of my developer tab or find how to add it.

Any ideas?

Answer 1

What you read pertains to Excel for Windows. ActiveX never has been supported on Macs & Content Controls have not yet been implemented in Mac Office.

Unless there is a VBA method the size of Check Box Form Field elements cannot be changed or formatted.

Answer 2

Yes, the Ribbon in your screen shot is that of a Windows version. The tool appears as a singular Insert button because the window shown is not sized sufficiently wide to allow the group of tools to expand... It's one of those that expands/condenses based on available space. If the window were wider the singular tool would grow to display as a Group containing the 3 categories of controls tools: Content Controls, ActiveX Controls, Legacy Form Fields.

Since Mac Office provides only Legacy Form Fields there is only the one small group to be displayed. The window typically is wide enough to display the entire group, but will condense if the width of the window is narrowed significantly.

Answer 3

Hi Yoga

Thanks for your help but see screenshot below. I can insert a checkbox but it will only let me enlarge the placeholder, not the checkbox itself, so when it prints it is tiny and you can only just see the tick. I read somewhere that you can insert either form control or activex control and this makes a difference as to whether you can resize or not. I also saw a video where the checkbox was inserted into a cell using the insert button on developer tab but I do not have the insert button nor can I find it to add it to the developer tab.

Answer 4

This is the insert control I have seen whilst Googling although I suspect now it may be a windows only thing.

Answer 5

Brilliant! Good old Mac.

Thanks Bob for confirming what I feared!

Case closed!