Alignment Area in Excel

How can we align data in a cell in our spreadsheet in Excel? How can we rotate it, wrap it or merge and center it in an area of cells. How can all these things be done? Of course with the Alignment area!!!

In Excel we have the Alignment area on the Home tab, where we can format our data in any way that we want.

Alignment Area

Let’s see these areas individually, and what they can do.

Alignment

  • The top left icon aligns content to the top.
  • The top middle icon aligns content that is centered between the top and bottom of the cell.
  • The top right icon aligns content the bottom.
  • The bottom left icon aligns content to the left.
  • The bottom middle icon aligns content to the middle.
  • The bottom right icon aligns content to the right.

If we select the arrow at the right of the Orientation button as shown below the drop down menu will appear with the following commands:

  • Angle Counterclockwise: Rotates the contents from the bottom upwards with a 45ο angle.
  • Angle Clockwise: Rotates the contents from the top towards the bottom with a 45ο angle.
  • Vertical Text: The contents layout is from the top to the bottom.
  • Rotate Text Up: The contents layout is from the top towards the bottom, but the content is sideways.
  • Rotate Text Down: The content has layout from the bottom towards the top, but the content is sideway.
  • Format Cell Alignment: The Format Cell window appears with all the available commands.

Orientation

In the image below is the Indent area, where the first icon on the left is the Decrease Indent which we can move our content closer to the cell border. The second icon on the right is the Increase Indent which we move our content farther away from the cell border.

Indent

With the Wrap Text icon shown in the image below we can wrap long text in to multiple lines so we can see all of it.

Wrap Text

If we select the arrow at the right of the Merge & Center icon we have the following commands available from the drop down menu:

  • Merge & Center
  • Merge Across
  • Merge Cells
  • Unmerge Cells

With these commands we can combine and center the contents of the selected cells in a new larger cell. It is a good way to create labels that spans multiple columns. As mentioned we have to select the cells and then use these commands.

Merge And Center

If we select the arrow at the bottom right corner of the Alignment area, which is named Alignment Settings the Format Cells window appears where we can do most of the commands as in the Alignment area.

Format Cells

Whatever adjustments we do we must press the OK button at the end for them to take place.

Below you can check out the video demonstrating the use of the Alignment area in Excel.

Alignment Area in Excel

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on July 9, 2013, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , . Bookmark the permalink. Comments Off on Alignment Area in Excel.

Comments are closed.