Expand Minimize

Vertical Spacing Commands (Format Menu)

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

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.

Make Equal

Moves the selected objects so that there is equal space between them using the top and bottom objects as the endpoints.

Toolbar shortcut: tbr_veql_ZA01201765.

Increase

Increases the vertical spacing by one grid based on the object with focus. You can change the size of your grid units in the General tab of the Options dialog box.

Toolbar shortcut: tbr_vinc_ZA01201766.

Decrease

Decreases the vertical spacing by one grid based on the object with focus. You can change the size of your grid units in the General tab of the Options dialog box.

Toolbar shortcut: tbr_vdec_ZA01201764.

Remove

Removes the vertical spacing so that the object’s borders are touching, based on the object with focus

Toolbar shortcut: tbr_vrem_ZA01201767.

NoteNote

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

NoteNote

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.

Show:
© 2014 Microsoft