Format menu

Align

Aligns selected objects with each other by using the control with the white grab handles as the reference.

Command Description Toolbar button
Lefts Aligns the horizontal position of the selected objects, putting the left-most edges in line with the control with the white grab handles. Lefts Toolbar button
Centers Aligns the horizontal position of the selected objects, putting the centers in line with the control with the white grab handles. Centers Toolbar button
Rights Aligns the horizontal position of the selected objects, putting the right-most edges in line with the control with the white grab handles. Rights Toolbar button
Tops Aligns the vertical position of the selected objects, putting the tops in line with the control with the white grab handles. Tops Toolbar button
Middles Aligns the vertical position of selected objects, putting the middles in line with the control with the white grab handles. Middles Toolbar button
Bottoms Aligns the vertical position of the selected objects, putting the bottoms in line with the control with the white grab handles. Bottoms Toolbar button
To Grid Aligns the top left of the selected objects to the closest grid. The object is not resized. To Grid Toolbar button

Arrange Buttons

Arranges selected command buttons along the bottom or edge of a form.

Command Description Toolbar button
Bottom Arranges to the bottom left side of the form with equal spacing between each of them. Bottom Toolbar button
Right Arranges to the top right side of the form with equal spacing between each of them. Right Toolbar button

Center in Form

Centers selected objects on the central axes of the form.

Command Description Toolbar button
Horizontally Aligns the middles of the selected objects to a horizontal line in the middle of the form. Horizontally Toolbar button
Vertically Aligns the centers of the selected objects to a vertical line in the center of the form. Vertically Toolbar button

Group and Ungroup

Groups and ungroups selected objects.

Command Description Toolbar button
Group Creates a group.

NOTE You can still select a single object from within a group and change its properties. You cannot create groups within a group (nested grouping).
Group Toolbar button
Ungroup Ungroups the objects that were previously grouped. Ungroup Toolbar button

Horizontal Spacing

Changes the horizontal space between selected objects.

Command Description Toolbar button
Make Equal Moves the selected objects so that there is equal space between them by using the outermost objects as endpoints. The outermost objects don't move. Make Equal Toolbar button horizontally
Increase Increases horizontal spacing by one grid unit based on the object with focus. When an object has focus, white handles appear on its borders. You can change the size of your grid units on the General tab of the Options dialog box. Increase Toolbar button horizontally
Decrease Decreases horizontal spacing by one grid unit based on the object with focus. When an object has focus, white handles appear on its borders. You can change the size of your grid units on the General tab of the Options dialog box. Decrease Toolbar button
Remove Removes the horizontal space so that the objects are aligned with their edges touching based on the object with focus. When an object has focus, white handles appear on its borders. Remove Toolbar button horizontally

Note

The object with focus does not move but the other objects move around it.

If using the Horizontal Spacing command does not produce the results you want, try to manually rearrange some of the objects and repeat the command. Also, try the using the Vertical Spacing command.

Make Same Size

Based on the object with the white grab handles, makes the selected objects the same size in the dimension that you select.

Command Description Toolbar button
Width Adjusts width. Width Toolbar button
Height Adjusts height. Height Toolbar button
Both Adjusts both the width and the height. Both Toolbar button

Order

Changes the order of the selected objects on a form.

Command Description Toolbar button Keyboard shortcut
Bring To Front Moves the selected objects to the front of all other objects on a form. Bring To Front Toolbar button CTRL+J
Send To Back Moves the selected objects behind all other objects on a form. Send To Back Toolbar button CTRL+K
Bring Forward Moves the selected object one step higher in the z-order. Bring Forward Toolbar button
Send Backward Moves the selected object one step lower in the z-order. Send Backward Toolbar button

Size to Fit, Size to Grid

Command Description Toolbar button
Size to Fit Changes the height and width of an object to fit its contents. Size to Fit Toolbar button
Size to Grid Adjusts the height and width of the selected object to fit the nearest gridlines in the form. You can change the size of your grid on the General tab of the Options dialog box. Size to Grid Toolbar button

Vertical Spacing

Changes the vertical space between the selected objects, based on the object with focus. When an object has focus, white handles appear on its borders.

Command Description Toolbar button
Make Equal Moves the selected objects so that there is equal space between them by using the top and bottom objects as the endpoints. Make Equal Toolbar button vertically
Increase Increases the vertical spacing by one grid based on the object with focus. You can change the size of your grid units on the General tab of the Options dialog box. Increase Toolbar button vertically
Decrease Decreases the vertical spacing by one grid based on the object with focus. You can change the size of your grid units on the General tab of the Options dialog box. Decrease Toolbar button vertically
Remove Removes the vertical spacing so that the object's borders are touching, based on the object with focus. Remove Toolbar button vertically

Note

The object with focus does not move but the other objects move around it.

If using the Vertical Spacing command does not produce the results you want, try to manually rearrange some of the objects and repeat the command. Also, try the using the Horizontal Spacing command.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.