Horizontal Spacing 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.

Changes the horizontal space between selected objects.

Make Equal

Moves the selected objects so that there is equal space between them using the outermost objects as endpoints. The outermost objects do not move.

Toolbar shortcut: tbr_heql_ZA01201706.

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 in the General tab of the Options dialog box.

Toolbar shortcut: tbr_hinc_ZA01201707.

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 in the General tab of the Options dialog box.

Toolbar shortcut: tbr_hdec_ZA01201705.

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.

Toolbar shortcut: tbr_hrem_ZA01201708.

Note Note

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

Note Note

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.

Show: