Cell Alignment

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Cell Alignment

Cells Merging

When reviewing cells, we found out that a cell doesn't have dimensions of its own. Its width is imposed by its parent column and its height is set on its parent row. All of the cells we have used so far were considered individually. Microsoft Excel allows you to combine various cells in a group. This is referred to as merging cells.

To merge cells, select them and:

  • On the Ribbon, click Home. In Alignment section, click the Merge & Center button Merge & Center
  • On the Ribbon, click Home. In Alignment section, click the button on the right side of Merge & Center and select from the list
     
    Merge
  • Right-click the selected cells and click Format Cells. In the Alignment property page, click the Merge Cells check box and click OK

Practical LearningPractical Learning: Merging Cells

  1. Open the DAWN Report2.xlsx workbook and click Sheet2 to make it active
  2. Select cells A3:D3
  3. On the Ribbon, click the Merge & Center button Merge & Center
  4. Select cells F3:I3
  5. On the Ribbon, click the Merge & Center button Merge & Center
  6. Press Ctrl + Home
  7. To save the workbook, press Ctrl + S

Cells Content Alignment

We have already seen how Microsoft Excel differentiates data you enter into cells. Sometimes its default configurations will not suit your particular scenario, you should be able to control how text is aligned in cells.

Since a cell is really a rectangular box, you can completely control how text is displayed inside of it: left, center, right, top, middle, or bottom. As we move on, we will see various situations of aligning cells content.

Practical LearningPractical Learning: Control Cells Alignment

  1. Open the Cherry Pumpkin Day Care1 workbook
  2. To control the alignment of one cell, click cell F4 to make it active
  3. On the Ribbon, click the Home tab if necessary.
    In the Alignment section, click the Align Text Right button Align Right
  4. To control the alignment of a group of cells, select cells C4:C15
  5. On the Ribbon, in the Alignment section, click the Center button Center
  6. Press Ctrl + Home and press Ctrl + S to save the workbook
  7. Access the DAWN Report2 workbook from the taskbar
  8. In Sheet1, randomly select cells C6, D5, D6, H6, I5, and I6 (press and hold Ctrl while you are clicking each cell)
  9. To control the alignment of a group of randomly selected cell, on the Ribbon, click the Center button Center
  10. Select cells A7:A16
  11. In the Alignment section of the Ribbon, click the Align Text Right button Align Right
  12. Select cell F7:F16 and, in the Alignment section of the Ribbon, click the Align Text Right button Align Right
  13. Save the workbook

DAWN Report

Cells Content Indentation

In the previous section, we used the Center button to center the content of a cell with regards to the width of the cell. In some circumstances, you may not want to center text but you would not like to keep it left or right aligned. Indentation consists of "pushing" text to the left or the right without centering it.

To indent the contents of a cell or of a group of cells, after making the selecting, on the Ribbon, click Home. In the Alignment section:

  • Click the Increase Indent button to "push" the contents of a cell or a group of cells to the right
  • Click the Decrease Indent button to "push" the contents of a cell or a group of cells to the left

 Practical Learning: Indenting Cells Content

  1. Open the Grier Summer Camp2.xlsx workbook and, if necessary, click Sheet1
  2. Click cell C5 to make it active
  3. On the Ribbon, click the Home tab if necessary. In the Alignment section, click the Increase Indent button Increase Indent
  4. Click cell D6 and repeat the previous action

The Alignment Property Page

Besides using the alignment buttons on the Ribbon, to be more precise or to perform various actions in one step, you can use the Alignment property page of the Format Cells property sheet. To access the Alignment property page:

  • On the Ribbon, click Home. In the Alignment section, click the more options button More Options

Alignment

  • Right a cell or the selected cells and click Format Cells. In the Format Cells dialog box, click Alignment

To provide the same options as the Ribbon, the Alignment property page is equipped with the Horizontal combo box. Besides the left, center, and right alignments, this combo box goes further and allows text to be justified. This can be useful especially if the text is significantly long. If you select to indent text, you can use the Indent spin button to specify the number of units to indent by.

The Vertical combo box provides options not available on the Ribbon. It allows you to align the contents of a cell towards the top, the middle or the bottom area of a cell.

The Text Control section provides three options: Wrap Text, Shrink To Fit, and Marge Cells.

The Orientation section allows you to "bend" text by a fix angle. There are two main ways you can set an angle. If you drag the small red diamond, you can use it to specify the desired angle. You can also click one of the arrows of the Degrees spin button.

 Practical Learning: Using the Alignment Property Page

  1. Sheet1 of the Grier Summer Camp2.xlsx workbook should still be selected
    Select cells B9:C10
  2. Right-click the selection and click Format Cells...
  3. In the Format Cells dialog box, click the Alignment property page if necessary.
    In the Text Control section, click the Merge Cells check box, and click OK
  4. Select cells E9:H9 and press F4 to repeat the previous action
  5. Select cells D8:H8
  6. Right-click the selection and click Format Cells...
  7. In the Alignment tab of the Format Cells dialog box, in the Horizontal combo box, select Center
  8. In the Vertical combo box, select Center
  9. In the Text Control section, click the Merge Cells check box
     
    Format Cells - Alignment
  10. Click OK
  11. Select cells A11:A26
  12. Press Ctrl + 1 to call the Format Cells dialog box
  13. In the Horizontal combo box, select Right
  14. In the Text Control section, click the Merge Cells check box
  15. In the Orientation section, click and hold the mouse on the small red diamond. Then drag it up until the spin button in the same section displays 90
     
    Format Cells
  16. Click OK
  17. Type Time Period
  18. Save the workbook