Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Positioning Graphics Evenly.
Written by Allen Wyatt (last updated May 15, 2021)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365
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:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (9048) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Positioning Graphics Evenly.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Worksheets can contain more than just text and numbers. Here's the low-down on the different types of pictures you can ...
Discover MoreWant to "see through" an image you place on a worksheet? You can do so by using the steps in this tip.
Discover MoreWant to draw a few simple shapes or lines on your worksheet? It really is simple; here's how to do it.
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-05-18 12:45:13
Mike D.
This works very well, I use it all the time. One thing I have noticed, compared to Visio, when aligning (top, bottom, left, right) Excel chooses the extreme most object where Visio aligns to the first selected no matter if it is at the extreme position.
This is not a failing but an attribute to keep in mind when trying to align objects for your beautiful presentations.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Comments