GCFLearnFree.org

Great information, simple language, and all for free.”

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

To modify the 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 Vertical Arrow.
    Screenshot of Google SpreadsheetsSelecting the row border
  2. Click, hold, and drag the row border down to increase the height. Dragging the border up will decrease the row height.
    Screenshot of Google SpreadsheetsMoving the row border
  3. Release the mouse when you are satisfied with the new row height.
    Screenshot of Google SpreadsheetsThe 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 will set a uniform row height.

  1. Locate and click the Select All button just below the formula bar  Select All Button to select every cell in the spreadsheet.
    Screenshot of Google SpreadsheetsClicking the Select All button
  2. Hover the mouse over the line between two rows. The cursor will turn into a double arrow Vertical Arrow.
  3. Click, hold, and drag the row border to modify the height.
    Screenshot of Google SpreadsheetsChanging the height of all rows
  4. Release the mouse when you are satisfied with the new row height for the spreadsheet.
    Screenshot of Google SpreadsheetsThe uniform row height
previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

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