Export (0) Print
Expand All
Expand Minimize

Horizontal Spacing Commands (Format Menu)

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

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.

NoteNote

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

NoteNote

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:
© 2014 Microsoft