Modifying Columns, Rows, and Cells

In Google Sheets modification of rows, cells, and columns can help personalize your file. Learn how here.

Wrapping text and merging cells

Whenever you have too much cell content to be displayed in a single cell, you may decide to wrap the text or merge the cell rather than resize a column. Wrapping the text will automatically modify a cell's row height, allowing the cell contents to be displayed on multiple lines. Merging allows you to combine a cell with adjacent empty cells to create one large cell.

To wrap text:

  1. Select the cells you want to wrap. In this example, we're selecting cell range C3:C10.
    Selecting cells to wrap
  2. Open the Text wrapping drop-down menu, then click the Wrap button.
    Clicking the Wrap text button
  3. The cells will be automatically resized to fit their content.
    The wrapped text inside the resized cells

To merge cells:

  1. Select the cells you want to merge. In this example, we're selecting cell range A1:C1.
    Choosing cells to merge
  2. Select the Merge cells button.
    Clicking the Merge cells button
  3. The cells will now be merged into a single cell.
    The merged cells

To unmerge a cell, click the drop-down arrow next to the Merge cells button, then select Unmerge from the drop-down menu.

Unmerging cells