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

Car Tips
Cooking Tips
Health 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

 

Distributing Graphics Horizontally

Summary: If you have a number of graphics that you want to distribute evenly across the worksheet, Excel has a command to accomplish the task. Just use the Align tool, as described in this tip.

Sometimes you may need to position graphics evenly within a worksheet. 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 within Excel, 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. Excel should display the Format tab of the Ribbon automatically.
  3. Click the Align tool in the Arrange group. Excel displays a list of different ways you can arrange the graphics.
  4. Choose Distributing Horizontally. Excel positions the two inside graphics so that all four graphics are an equal distance from each other.