How to Keep Excel Checkboxes Anchored When Hiding Rows or Columns in WPS Office
Question details
Prevent form checkboxes in a worksheet from moving to other columns or losing their original cell position after rows or columns are hidden and then unhidden.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with form checkboxes in a worksheet and needs them to stay anchored to their intended cells through hide and unhide actions.
- Observed behavior
- Checkboxes move to other columns or shift away from their original cells after hidden rows or columns are unhidden.
Open the workbook in WPS Office Spreadsheets and enable the Developer tab if you need to insert or modify form controls. If the checkboxes are ActiveX controls, switch to Design Mode before selecting them.
Set each checkbox to Move and size with cells in Format Control Properties
Use this when checkboxes need to follow the cell position when rows or columns are hidden and later unhidden.
In WPS Spreadsheets, form controls have object positioning properties that determine whether a control moves or resizes with the cells beneath it. Choosing the correct property stops the checkbox from drifting across columns after unhiding.
In WPS Spreadsheets, right-click the form checkbox and choose Format Object or Format Control from the context menu.
In the Format Control dialog, click the Properties tab.
Choose Move and size with cells if the checkbox should remain inside the cell, or Move but don't size with cells if only its position should track the cell. Click OK.
Drag the checkbox so its top-left corner sits inside the cell you want it to stay with. Avoid stretching it across hidden ranges.
Recreate the checkbox after applying the correct positioning property
Use this if a checkbox still moves after reopening or was copied from a hidden range.
Keep Form Checkboxes Anchored in WPS Office Spreadsheets
Use WPS Office Spreadsheets to set form control properties so checkboxes remain anchored to their cells when you hide or unhide rows and columns. It is fully compatible with Excel workbooks and gives you the same control positioning options without changing your file format.
- 1. Open your workbook in WPS Spreadsheets: Launch WPS Office, click Menu > Open, and select the Excel workbook that contains the checkboxes.
- 2. Right-click the checkbox: Right-click the form checkbox and choose Format Object or Format Control from the shortcut menu.
- 3. Open the Properties tab: In the dialog, go to Properties and select Move and size with cells or Move but don't size with cells.
- 4. Position and test: Place the checkbox over the intended cell, click OK, then hide and unhide the row or column to verify it stays anchored.
Frequently Asked Questions
Why does my Excel checkbox move when I unhide rows in WPS Office?
The control is likely set to Don't move or size with cells, or it was placed across a hidden range. Right-click the checkbox, open Format Object or Format Control, go to Properties, and choose Move and size with cells or Move but don't size with cells.
Where is Format Control in WPS Spreadsheets?
Right-click the checkbox and select Format Object or Format Control. If you need to insert or manage form controls, first enable the Developer tab from WPS Office options.
Can I stop checkboxes from resizing when row height changes?
Yes. In the Properties tab of Format Control, choose Move but don't size with cells. This keeps the checkbox position tied to the cell without changing its size.
Does this work for ActiveX checkboxes in WPS Office?
ActiveX controls may require Design Mode to be enabled before you can access their properties. For simpler anchoring, use form-control checkboxes and set the positioning property under Properties.
Will WPS Office preserve my checkbox settings when I save as an Excel file?
Yes. Standard form control positioning settings are saved in the workbook and remain available when the file is opened in WPS Office or Microsoft Excel.
