Modifying Columns, Rows, and Cells

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

To modify row height:

You can make cells taller by modifying the row height. Changing the row height will create additional space in a cell, which often makes it easier to view cell content.

  1. Hover the mouse over the line between two rows. The cursor will turn into a double arrow.
    Selecting the row border
  2. Click and drag the row border down to increase the height. Dragging the border up will decrease the row height.
    Moving the row border
  3. Release the mouse when you are satisfied with the new row height.
    The resized row

To modify all rows or columns:

Rather than resizing rows and columns individually, you can modify the height and width of every row and column in a spreadsheet at the same time using the Select All button. This method allows you to set a uniform size for the spreadsheet's rows and columns. In our example, we'll set a uniform row height.

  1. Click the Select All button just below the formula bar to select every cell in the spreadsheet.
    Clicking the Select All button
  2. Hover the mouse over the line between two rows. The cursor will turn into a double arrow.
  3. Click and drag the row border to modify the height.
    Changing the height of all rows
  4. Release the mouse when you are satisfied with the new row height for the spreadsheet.
    The uniform row height