How to Format Multiple Excel Buttons to the Same Size and Position
Question details
The user wants to select multiple buttons in an Excel spreadsheet and apply uniform sizing and positioning to all of them simultaneously.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Organizing and standardizing the layout of interactive form controls or buttons within an Excel worksheet.
- Observed behavior
- The user needs a method to bulk-edit the size and position of multiple buttons so they fit consistently within their respective cells.
Ensure that your worksheet is unprotected so you can freely select and modify form controls.
Use Format Control to Resize Multiple Buttons Simultaneously
This is the most efficient method to apply exact height and width measurements to several buttons at once without editing them individually.
By utilizing the Ctrl key and the Format Control menu, you can lock in uniform dimensions and determine how the buttons behave when surrounding cells are resized or moved.
Hold down the 'Ctrl' key on your keyboard and click on each button you want to format in order to select them all at once.
Right-click on one of the currently selected buttons and choose 'Format Control' from the context menu.
Navigate to the 'Size' tab to enter specific height and width values. Go to the 'Properties' tab to adjust object positioning (e.g., choose 'Move and size with cells'). Click 'OK' to apply changes to all selected buttons.

Effortlessly Manage Form Controls in WPS Spreadsheet
WPS Spreadsheet provides intuitive tools to bulk-select, format, and align interactive form controls like buttons. You can easily standardize the size and position of your worksheet elements in a familiar interface.
- 1. Open your Workbook in WPS Office: Launch WPS Spreadsheet and open the file containing your interactive buttons.
- 2. Select Multiple Controls: Hold the Ctrl key on your keyboard and click each button you wish to resize or reposition.
- 3. Apply Formatting: Right-click the selection, select 'Format Object', and adjust the exact size parameters to apply them universally.

Frequently Asked Questions
Why can't I select multiple buttons using the Ctrl key?
If you are unable to select buttons, ensure your worksheet isn't protected. Additionally, if you are using ActiveX controls instead of standard Form controls, you may need to enable 'Design Mode' in the Developer tab before you can click and select them.
How do I align multiple buttons perfectly in a row?
After selecting multiple buttons using the Ctrl key, go to the Page Layout or Format tab, click 'Align', and choose 'Align Top' or 'Align Bottom'. You can also use 'Distribute Horizontally' to space them evenly.
Can I snap buttons to the cell grid automatically?
Yes. Hold the 'Alt' key while dragging or resizing a button. This temporarily activates the 'Snap to Grid' feature, forcing the button's edges to align perfectly with the worksheet cell borders.
Will resizing the cells affect my formatted buttons?
It depends on the button's properties. If you selected 'Move and size with cells' in the Format Control menu, the button will stretch or shrink when the underlying cell is resized. Choose 'Don't move or size with cells' to keep the button statically sized regardless of cell changes.




