bottom
Excel 2007 Tips!
     
Your e-mail address is safe!
Close Note
excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Beauty Tips
Cleaning Tips
College Tips
Pet Tips

Newest Tips

Negative Elapsed Times

Specifying the Number of MRU Files

Changing Data Series Ordering

Seeing How Excel Evaluates Formulas

Highlighting a Cell if It Contains Specific Text

Filling Shapes with Pictures

Creating a List of Worksheet Formulas

 

Position Graphics Evenly

Summary: Place several graphics in a worksheet, and you may want Excel to arrange them so that they are evenly spaced. This tip shows how easy it is to have Excel make the adjustment.

Sometimes you may need to position graphics evenly within a document. For instance, you may have four small graphics that will appear next to each other. You may want to make sure that the graphics are an equal distance from each other. To do this easily, follow these steps:

  1. Using the mouse, roughly position the graphics where you want them to appear. You should make sure that the left-most graphic is where you want it, as is the right-most graphic.
  2. Select all four graphics. With the graphics select, you should see the Format tab displayed on the Ribbon.
  3. In the Arrange group, click the down-arrow to the right of the Align tool. You'll see a list of choices available.
  4. Choose Distribute Horizontally from the list of choices. Excel positions the two inside graphics so that all four graphics are an equal distance from each other.