Tip 230 – Quickly Align Shapes, Charts and Images in Excel

To quickly align shapes, charts, images or any combination thereof, first select all the objects. To do this, from the Home tab click Find & Select > Select Objects. Drag over the objects to select them and then, from the Drawing Tools > Format tab, click Align and click the desired alignment option such as Align Top to align their top edges.