Skip to content

Keep Your Shapes in Line

In our previous Design post, we introduced how you can create and use shapes in Microsoft Excel.

In this article, we will show you how to adjust the alignment of all your shapes relative to one another.

The Alignment of a Shape

What do we mean when we say “adjust the alignment?”

The alignment of a shape refers to where it is positioned relative to the spreadsheet grid or to other shapes.

Take the following set of shapes, for example.

These four shapes are not located anywhere specific relative to one another. Now, what if you wanted to make it so that they all lined up in a row?

You could adjust the alignment of the shapes, and now they are all lined up in a row.

How to Adjust the Alignment of a Shape

Follow the steps below to adjust the alignment of shapes in Excel.

Start by selecting all of the shapes you want to align.

Under the Shape Format tab in the Excel Ribbon, click on the Align button and select how you want to align the shapes.

And that’s pretty much all there is to it. If you want to learn more about the different types of alignment, continue reading! If you are satisfied with your alignment lesson for the day, you can stop here!

Align the Shapes Left, Center, and Right

Whenever you click on the Align button, the first three options available are:

  • Align Left
  • Align Center
  • Align Right

Here is how each alignment will affect your shapes.

Align Left

This will align your shapes vertically so that their left sides all share the same line.

Align Center

This will align your shapes vertically so that their centers all share the same line.

Align Right

This will align your shapes vertically so that their right sides all share the same line.

Align the Shapes Top, Middle, and Bottom

Whenever you click on the Align button, the next three options available are:

  • Align Top
  • Align Middle
  • Align Bottom

Here is how each alignment will affect your shapes.

Align Top

This will align your shapes horizontally so that their top sides all share the same line.

Align Middle

This will align your shapes horizontally so that their centers all share the same line.

Align Bottom

This will align your shapes horizontally so that their bottom sides all share the same line.

Distribute the Shapes Horizontally or Vertically

When you distribute your shapes horizontally, you make it so that there is an equal amount of horizontal space between each shape.

When you distribute your shapes vertically, you make it so that there is an equal amount of vertical space between each shape.

These distributions help out a lot when you want your shapes evenly spaced one way or another.

And that about sums up everything you can do regarding the alignment of all your shapes!

This Post Has One Comment

  1. This is so good to know! I didn’t know that Excel had so many options for alignment. I can’t wait to start using these!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top