Align Commands (Format Menu)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Lefts

Aligns the horizontal position of the selected objects, putting the left-most edges in line with the control with the white grab handles.

Toolbar shortcut: tbr_all_ZA01201672.

Centers

Aligns the horizontal position of the selected objects, putting the centers in line with the control with the white grab handles.

Toolbar shortcut: tbr_alc_ZA01201671.

Rights

Aligns the horizontal position of the selected objects, putting the right-most edges in line with the control with the white grab handles.

Toolbar shortcut: tbr_alr_ZA01201674.

Tops

Aligns the vertical position of the selected objects, putting the tops in line with the control with the white grab handles.

Toolbar shortcut: tbr_alt_ZA01201675.

Middles

Aligns the vertical position of selected objects, putting the middles in line with the control with the white grab handles.

Toolbar shortcut: tbr_alm_ZA01201673.

Bottoms

Aligns the vertical position of the selected objects, putting the bottoms in line with the control with the white grab handles.

Toolbar shortcut: tbr_alb_ZA01201670.

To Grid

Aligns the top left of the selected objects to the closest grid. The object is not resized.

Toolbar shortcut: tbr_altg_ZA01201676.

Show: