Welcome toExcel2007.Tips.Net
Helpful Links
Cooking Tips
Money Tips
Pet Tips
Word2007 Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
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:
- 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.
- Select all four graphics. Excel should display the Format tab of the Ribbon automatically.
- Click the Align tool in the Arrange group. Excel displays a list of different ways you can arrange the graphics.
- Choose Distributing Horizontally. Excel positions the two inside graphics so that all four graphics are an equal distance from each other.
Related Tips:
Create and Merge! Using Word's mail merge tool you can quickly and easily combine data from a variety of data sources to create great individualized documents that incorporate your data in ways that you control. WordTips: Mail Merge Magic is an invaluable source for learning how to harness the full power of Word's mail merging capabilities. Check out WordTips: Mail Merge Magic today!