Are we aligned?

A simple trick to align objects neatly. 🙂

excel-tip-align-objects

Did you move the objects one by one and then realized that it took you forever to have them perfectly aligned?

excel-tip-align-objects-1

Why not using the “Align” under Drawing Tools?

First to select the objects you wish to align

excel-tip-align-objects2

Note: You won’t see the “Drawing Tools” unless at least one object is selected.

Once you have them aligned to the Top, repeat the step and align the objects with “Distribute Horizontally”.

excel-tip-align-objects3

Tip: “Align Top” based on the object on the top ; “Distribute Horizontally” based on the objects on the leftmost and rightmost.  So you should have set the position of the top ; and the leftmost and rightmost objects beforehand.

As simple as this. 🙂

Excel Dashboard Course

This entry was posted in Excel Tips. Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s