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. ๐Ÿ™‚

Watch it in action in my YouTube Channel:

 

 

Excel Dashboard Course

Advertisement

About MF

An Excel nerd who just transition into a role related to data analytics at current company......๐Ÿ˜Š Recently in love with Power Query and Power BI.๐Ÿ˜ Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
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 )

Facebook photo

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

Connecting to %s

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