88. Excel Tips - Align Shapes

Nick's picture


This Excel Tip is about how to align shapes:

  • Suppose you have added 3 buttons and they're out of line.
  • How can you align them ?

Here's a screen shot of what we have, and what we want to have:

align-shapes

Here's how to do it

  1. Add "Align Left" and "Distribute Vertically" to your toolbar
  2. Hold down the CTRL key
  3. Click on each button one by one
  4. Click on "Align Left" then on "Distribute Vertically"

Download sheet to practise how to Align Shapes in Excel

Training Video on how to Align Shapes in Excel:

AttachmentSize
align-shapes.xls30 KB

Hi Nick Could this be adapted

Hi Nick

Could this be adapted to align comment boxes when they are sisplayed on the sheet ?