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: .
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: .
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: .
Remove
Removes the vertical spacing so that the object’s borders are touching, based on the object with focus
Toolbar shortcut: .
Note
The object with focus does not move but the other objects move around it.
Note
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.