Microsoft Office Tutorials and References
In Depth Information
Tools to help you position objects on the worksheet
It’s great to be able to create cool graphics with Excel, but the free-floating nature of
graphic objects sometimes makes it hard to maintain a semblance of order on your
worksheet. The Align button, in the Arrange group on the Drawing Tools Format tab, contains
commands you can use to straighten up your worksheet, as shown in Figure 10-50.
Figure 10-50 Use the Align commands to straighten up objects.
You can also find the Align button menu in the Arrange group on the Page Layout tab.
Suppose you have a number of objects that you want to be evenly spaced, like the
randomly spaced boxes shown on the left in Figure 10-50. You can start by selecting the top
row of objects, using the Align Top command to line them up, and then selecting Distribute
Horizontally to space them evenly. Then you can use the other alignment and distribution
commands to position the rest of the objects to your liking. Here are some key points to
remember about using these object-positioning commands:
Snap To Grid Uses the columns and rows of the worksheet to align objects.
Preexisting objects don’t line up with the grid when you choose this command, but as
soon as you create or drag an object, it snaps to the nearest column and row borders.
The Snap To Grid command is a toggle—that is, you click once to turn it on and click
again to turn it off.