Office Settings & Configuration

How to Format Multiple Excel Buttons to the Same Size and Position

Elise WilliamsElise Williams Nov 3, 2026 870 views

Question details

The user wants to select multiple buttons in an Excel spreadsheet and apply uniform sizing and positioning to all of them simultaneously.

How to Format Multiple Excel Buttons to the Same Size and Position
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.
Before you start

Ensure that your worksheet is unprotected so you can freely select and modify form controls.

Solution 1Recommended

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.

1
Select Multiple Buttons

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.

2
Open the Format Control Menu

Right-click on one of the currently selected buttons and choose 'Format Control' from the context menu.

3
Adjust Size and Properties

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.

Use Format Control to Resize Multiple Buttons Simultaneously
Bulk Editing Applied: All selected buttons will instantly snap to the uniform dimensions and properties you defined.
Efficient Worksheet Management

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. 1. Open your Workbook in WPS Office: Launch WPS Spreadsheet and open the file containing your interactive buttons.
  2. 2. Select Multiple Controls: Hold the Ctrl key on your keyboard and click each button you wish to resize or reposition.
  3. 3. Apply Formatting: Right-click the selection, select 'Format Object', and adjust the exact size parameters to apply them universally.
Easily bulk-select and format multiple objects and controls.Highly compatible with Microsoft Excel (.xlsx, .xls) files and form controls.Lightweight application with a user-friendly, tabbed interface.Free access to essential spreadsheet editing and layout tools.
microsoft office alternative - wps office

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.