Stop Excel Form Controls from Moving or Overlapping Cells
Question details
Keep worksheet buttons and other Form Controls from moving or overlapping data when switching sheets and entering information.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user switches between worksheets and enters data in a VBA-enabled workbook containing Form Controls.
- Observed behavior
- Buttons and other controls move, overlap data, or disappear.
Open the affected workbook in Excel and identify each control that moves or disappears. Check whether the issue occurs after entering data, switching worksheets, or changing row and column sizes.
Set each Form Control to stay in place
Use the control's Properties settings to prevent it from moving or resizing with worksheet cells.
On the affected worksheet, right-click a Form Control button and select Format Control.
Open the Properties tab, select Don't move or size with cells, and click OK.
Repeat Format Control > Properties for each affected button or other Form Control.
Switch between the affected worksheets and enter data again to check whether the controls remain in place.

Check VBA code that changes controls or worksheet layout
Use this check if controls still move after their positioning properties are changed.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface and support for common Excel formats. Open existing workbooks to make migration easier, but use Excel to troubleshoot its Form Control properties and test VBA-dependent features.

Frequently Asked Questions
How do I stop an Excel button from moving when I resize cells?
Right-click the Form Control button, select Format Control, and open Properties. Choose Don't move or size with cells, then click OK.
Do I need to change the setting for every button?
Yes. Open Format Control > Properties for each affected Form Control and apply the setting individually.
Why does a control still overlap data after I lock its position?
Don't move or size with cells keeps the control in a fixed position, but changed row heights or column widths can still place data underneath it. Adjust the worksheet layout or move the control to a clear area.
Can a macro move a button despite its Properties setting?
Yes. In Developer > Visual Basic, check worksheet and workbook event procedures for code that changes control positions or worksheet layout.




