Modifying Columns, Rows, and Cells

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

Freezing rows and columns

When working with large spreadsheets, there will be times when you'll want to see certain rows or columns all the time, especially when using header cells as in our example below. By freezing rows or columns in place, you'll be able to scroll through your spreadsheet while continuing to see the header cells.

To freeze a row:

  1. Locate the row or rows you want to freeze. In this example, we'll freeze the top two rows. Note: You do not need to select the rows you want to freeze.
    Deciding which rows to freeze
  2. Click View in the toolbar. Hover the mouse over Freeze, then select the desired number of rows to freeze from the drop-down menu.
    Freezing rows
  3. The top two rows are frozen in place. You can scroll down your worksheet while continuing to view the frozen rows at the top.
    The frozen rows

To freeze a column:

  1. Locate the column or columns you want to freeze. In this example, we'll freeze the leftmost column. Note: You do not need to select the columns you want to freeze.
    Choosing which column to freeze
  2. Click View in the toolbar. Hover the mouse over Freeze, then select the desired number of columns to freeze from the drop-down menu.
    Freezing a column
  3. The leftmost column is now frozen in place. You can scroll across your worksheet while continuing to view the frozen column on the left.
    The frozen column

To unfreeze rows, click View, hover the mouse over Freeze, then select No rows. To unfreeze columns, click View, hover the mouse over Freeze, then select No columns.

Unfreezing a row

Challenge!

  1. Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
  2. Change the row height of all of the rows to be smaller.
  3. Merge cells A1:I1.
  4. Insert a row below row 11 and type your name in the first cell.
  5. Delete row 7. This row contains the name Ben Mathis.
  6. Insert a column between columns G and H and type Total Quantity as the column header.
  7. Select cells A2:J2, change them to wrap text, and center align them.
  8. Freeze the top two rows.
  9. When you're finished, your spreadsheet should look something like this:
    modifying cells challenge example