Stop Combo Boxes from Changing Size in Excel 2013
Question details
The user needs to stop Excel 2013 combo boxes from changing size when selected.

- Product
- Microsoft Excel 2013
- Device & OS
- not provided
- Scenario
- The user selects ActiveX or form combo boxes in a worksheet, potentially in a macro-enabled workbook.
- Observed behavior
- Some combo boxes grow or shrink when clicked, and protecting the sheet does not necessarily stop the changes.
Identify whether the affected controls are ActiveX or form controls, and note whether resizing happens when you click them or change row and column dimensions. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon.
Check Combo Box Placement and Worksheet Protection
Use this approach to prevent controls from resizing with worksheet cells and to test whether protection affects the behavior.
On the Developer tab, turn on Design Mode for an ActiveX combo box. For a form control, right-click the combo box directly.
Right-click the combo box and choose Format Control. On the Properties tab, select Don't move or size with cells, then click OK.
On the Review tab, choose Protect Sheet and set the permissions needed for your worksheet. Turn off Design Mode if applicable, then click the combo box several times to test it.
If protection prevents interaction, choose Review > Unprotect Sheet and check the control's Locked setting in Format Control before testing protection again.

Check Display Scaling, VBA Code, and Add-ins
Use these checks if combo boxes still change size after adjusting their placement.
Work with Excel Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easier to move everyday spreadsheet work between suites. It does not repair Excel 2013 controls, and macro and ActiveX behavior may differ.

Frequently Asked Questions
Why does my combo box resize when I change column widths?
Its placement may be set to move or size with cells. Right-click the control, choose Format Control > Properties, and select Don't move or size with cells.
Will protecting the worksheet always stop combo boxes from resizing?
No. Protection can restrict changes to objects but may not stop a display or control-related resizing issue. If the problem continues, check display scaling, VBA event code, and add-ins.
Where can I check whether a macro changes a combo box's size?
Press Alt+F11 to open the VBA editor, then inspect the worksheet and control event procedures for assignments to the control's Width or Height.
Can WPS Office fix an Excel 2013 ActiveX combo box?
No. WPS Office is an alternative for working with spreadsheets, not a repair tool for Excel. Test any workbook that depends on ActiveX controls or macros before relying on it in another application.




