Chat with us, powered by LiveChat

Select Cells and Ranges

How to Select Cells and Ranges in Google Sheets

Select Cells and Ranges

Selecting cells is an important skill in Sheets. Almost all of the information in Sheets is saved in a cell or cell range. So, before you can enter, edit, or format text, you first need to know how to select a cell or cell range.

Select a Cell

  1. Click a cell.
    Select Cells and Ranges

To see which cell is selected, look at the shaded column number and row letter.

The cell is selected, indicated by the selection border around it.

Select a Row

Now let's try selecting an entire row.

  1. Click a row header.
    Select Cells and Ranges

You can also select multiple rows by selecting a row header, pressing and holding the Shift key, and pressing the Up or Down arrow keys to select additional rows.

All of the cells in that row are selected.

The row's header is also shaded darker to indicate that the entire row is selected.

Select a Column

You can select columns in the same way that you select rows.

  1. Click and drag column headers to select multiple columns.
     Select Cells and Ranges

You can also select multiple columns by selecting a column header, pressing and holding the Shift key, and pressing the Left or Right arrow keys to select additional columns.

Select a Range of Cells

  1. Click and drag cells to select multiple cells.
    Select Cells and Ranges

You can also select a cell range by selecting the first cell of the cell range, pressing and holding the Shift key and selecting the last cell of the cell range.

The cell range is selected.

Select All Cells

  1. Click the Select All box.

    Press Ctrl + A.

    Select Cells and Ranges

The entire sheet is selected.

FREE Quick Reference

Click to Download