GCFLearnFree.org

This has really aided my job search and created ample opportunities.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Google Sheets
  • Modifying Columns, Rows, and Cells

Google Sheets

Single page view print copy

Modifying Columns, Rows, and Cells

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 resizing 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 wish to wrap. In this example, we are selecting cell range A3:A10.
    Screenshot of Google SpreadsheetsSelecting cells to wrap
  2. Locate and select the Wrap text button Wrap Text button.
    Screenshot of Google SpreadsheetsClicking the Wrap text button
  3. The cells will be automatically resized to fit their content.
    Screenshot of Google SpreadsheetsThe wrapped text inside the resized cells

To merge cells:

  1. Select the cells you wish to merge. In this example, we are selecting cell range A1:D1.
    Screenshot of Google SpreadsheetsChoosing cells to merge
  2. Locate and select the Merge cells button Merge Cells button.
    Screenshot of Google SpreadsheetsClicking the Merge cells button
  3. The cells will now be merged into a single cell.
    Screenshot of Google SpreadsheetsThe merged cells

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

Screenshot of Google SpreadsheetsUnmerging cells
previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.

Cancel