Modifying Columns, Rows, and Cells

In Excel column width can be modified, as can row height and width in Excel. Learn to modify Excel cells in this free Excel 2010 lesson.

Wrapping text and merging cells

If a cell contains more text than can be displayed, you can choose to wrap the text within the cell or merge the cell with empty adjoining cells. Wrap text to make it display on multiple lines of the cell. Merge cells to combine adjoining cells into one larger cell.

To wrap text:

  1. Select the cells with text that you want to wrap.
    Selecting cells to wrap Selecting cells
  2. Select the Wrap Text command on the Home tab.
    Selecting the Wrap Text command Selecting the Wrap Text command
  3. The text in the selected cells will be wrapped in your worksheet.
    Cells with wrapped text Cells with wrapped text

If you change your mind, reclick the Wrap Text command to unwrap the text.

To merge cells using the Merge & Center command:

  1. Select the cells you want to merge.
    Selecting A1:D1 (A1, B1, C1, D1) Selecting A1:D1 (A1, B1, C1, D1)
  2. Select the Merge & Center command on the Home tab.
    Selecting the Merge & Center command Selecting the Merge & Center command
  3. The selected cells will be merged, and the text will be centered.
    A1 after merging with A1:I1 A1 after merging with B1:D1

If you change your mind, reclick the Merge & Center command to unmerge the cells.

To access more merge options:

Click the drop-down arrow next to the Merge & Center command on the Home tab. The merge drop-down menu appears.

Accessing more Merge options Accessing more Merge options