GCFLearnFree.org

Your videos are excellent: short, sweet, and to the point.”

Online Learner

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

Google Sheets

Multiple page view print copy

Modifying Columns, Rows, and Cells

Page 1

Introduction

Screenshot of Google Spreadsheets

By default, the cells of every new spreadsheet are always the same size. Once you begin entering information into your spreadsheet, it's easy to customize rows and columns to better fit your data.

In this lesson, you'll learn how to change the height and width of rows and columns, as well as how to insert, move, delete, and freeze them. You'll also learn how to wrap and merge cells.

Page 2

Working with columns, rows, and cells

Launch "Modifying Columns, Rows, and Cells" video!Watch the video (4:16).

Every row and column of a new spreadsheet is always set to same height and width. As you begin to work with spreadsheets, you will find that these default sizes are not always well-suited to different types of cell content.

Watch the video to learn about modifying columns, rows, and cells, including wrapping text and merging cells.

To modify the column width:

In our example below, some of the content in column A is too long to be displayed. We can make all of this content visible by changing the width of column A.

  1. Hover the mouse over the line between two columns. The cursor will turn into a double arrow Horiztonal Arrow.
    Screenshot of Google SpreadsheetsSelecting the column border
  2. Click, hold, and drag the column border to the right to increase column width. Dragging the border to the left will decrease column width.
    Screenshot of Google SpreadsheetsIncreasing the column width
  3. Release the mouse when you are satisfied with the new column width. All of the cell content is now visible.
    Screenshot of Google SpreadsheetsThe resized column

To autosize a column's width:

The autosizing feature will allow you to set a column's width to fit its content automatically.

  1. Hover the mouse over the line between two columns. The cursor will turn into a double arrow Horiztonal Arrow.
  2. Double-click the mouse.
    Screenshot of Google SpreadsheetsDoubling clicking to auto-size a column
  3. The column's width will be changed to fit the content.
    Screenshot of Google SpreadsheetsThe auto-sized column
Page 3

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
Page 4

Inserting, deleting, and moving rows and columns

After you've been working with a spreadsheet for a while, you may find that you want to add new columns or rows, delete certain rows or columns, or even move them to a different location in the spreadsheet.

To insert a column:

  1. Right-click a column heading. A drop-down menu will appear:
    • Select Insert 1 left to add a column to the left of the current column.
    • Select Insert 1 right to add a column to the right of the current column. In our example, we'll choose this option.
    Screenshot of Google SpreadsheetsInserting a column
  2. The new column will be inserted into the spreadsheet.
    Screenshot of Google SpreadsheetsThe newly inserted column

To insert a row:

  1. Right-click a row heading. A drop-down menu will appear:
    • Select Insert 1 above to add a row above the current row. In our example, we'll choose this option.
    • Select Insert 1 below  to add a column below the current row.
    Screenshot of Google SpreadsheetsInserting a row
  2. The new row will be inserted into the spreadsheet.
    Screenshot of Google SpreadsheetsThe newly inserted row

If you need to add more than one row at a time, you can scroll to the bottom of the spreadsheet and click the Add button. By default, this will add 20 new rows to your spreadsheet, but you can also set the number of rows to add in the text box.

Screenshot of Google SpreadsheetsAdding multiple rows

To delete a row or column:

It's easy to delete any row or column you no longer need in your spreadsheet. In our example, we will delete a row, but you can delete a column in the same way.

  1. Select the row you wish to delete.
    Screenshot of Google SpreadsheetsSelecting a row to delete
  2. Right-click the row heading, then select Delete row from the drop-down menu.
    Screenshot of Google SpreadsheetsSelecting Delete row
  3. The rows below the deleted row will shift up to take its place. In our example, row 5 is now row 4.
    Screenshot of Google Spreadsheets

There's a difference between deleting a row or column and simply clearing its contents. If you want to remove the content of a row or column without causing the others to shift, right-click a heading, then select Clear row or Clear column.

Screenshot of Google SpreadsheetsClearing the contents of a row

To move a row or column:

Sometimes you may want to move a column or row to make it more accessible in your spreadsheet. In our example, we will move a column, but you can move a row in the same way.

  1. Select the column you wish to move, then hover the mouse over the column heading. The cursor will become a hand icon Drag Cell Hand.
    Screenshot of Google SpreadsheetsSelecting a column to move
  2. Click, hold, and drag the column to its desired position. An outline of the column will appear.
    Screenshot of Google SpreadsheetsMoving a column
  3. Release the mouse when you are satisfied with the new location.
    Screenshot of Google SpreadsheetsThe moved column
Page 5

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
Page 6

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:

You can freeze up to 10 rows at the top of a spreadsheet.

  1. Locate the row or rows you wish to freeze. In this example, we will freeze the top two rows.
    Screenshot of Google SpreadsheetsDeciding which rows to freeze
  2. Locate and click View in the toolbar menu. Hover the mouse over Freeze rows, then select the desired number of rows to freeze from the drop-down menu.
    Screenshot of Google SpreadsheetsFreezing 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.
    Screenshot of Google SpreadsheetsThe frozen rows

To freeze a column:

You can freeze up to five columns on the left-hand side of a spreadsheet.

  1. Locate the column or columns you wish to freeze. In this example, we will freeze the leftmost column.
    Screenshot of Google SpreadsheetsChoosing which column to freeze
  2. Locate and click View in the toolbar menu. Hover the mouse over Freeze columns, then select the desired number of columns to freeze from the drop-down menu.
    Screenshot of Google SpreadsheetsFreezing 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.
    Screenshot of Google SpreadsheetsThe frozen column

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

Screenshot of Google SpreadsheetsUnfreezing a row
Page 7

Challenge!

To work through the challenge, open GCFLearnFree L9: Houses to Visit and copy the file to your Google Drive. View the instructions below the challenge if you are not sure how to make a copy of the file.

  1. Change the width of column A using the horizontal arrow.
  2. Double-click a column border to autosize column D.
  3. Insert a column between columns A and B.
  4. Move row 5 above row 3.
  5. Select the cell range A3:A10 and use the wrap text feature.
  6. Select the cell range A1:D1 and merge these cells into a single cell.
  7. Try freezing a row or column in place.

To copy the example file to your Google Drive:

In these tutorials, we will provide example files you can use to practice what you've learned in each lesson. Because these files are Google Docs we have chosen to share, you will need to copy the file to your Google Drive before you can edit the file.

  1. Click the link at the top of this page to open the example file.
  2. The example file will appear in a new browser tab or window. If you are not currently signed in to your Google account, locate and click Sign in on the top-right corner of the page.
    Screenshot of Google SpreadsheetsSigning in to your Google Account
  3. After you have signed in to your Google account, locate and select File in the toolbar menu and select Make a copy... from the drop-down menu.
    Screenshot of Google SpreadsheetsMaking a copy of the example file
  4. The Copy Document dialog box will appear. Enter a new title for the file, then click OK.
    Screenshot of Google SpreadsheetsNaming the file and clicking OK
  5. The copy of the file will appear in a new browser tab. Now you're ready to start using the example file.
    Screenshot of Google SpreadsheetsViewing the copied example file in a new tab
Terms Of Use

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