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
Gardening Tips
Money Tips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 

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.

Related Tips:

Document and Annotate! One of the easily overlooked tools provided by Word is the ability to add footnotes and endnotes to your documents. WordTips: Footnotes and Endnotes is the definitive resource guide to using these tools to enhance your documents. Check out WordTips: Footnotes and Endnotes today!