Getting Started with Google Sheets

Learn how to create a new Google Sheet to get started with this free cloud-based spreadsheet program.

To drag and drop cells:

Rather than cutting and pasting, you can drag and drop cells to move their contents.

  1. Select a cell, then hover the mouse over an outside edge of the blue box. The cursor will turn into a hand icon.
    Selecting a cell to drag and drop
  2. Click and drag the cell to its desired location.
    Clicking and dragging a cell
  3. Release the mouse to drop the cell.
    The dropped cell

To use the fill handle:

There may be times when you want to copy the content of one cell to several other cells in your spreadsheet. You could copy and paste the content into each cell, but this method would be time consuming. Instead, you can use the fill handle to quickly copy and paste content from one cell to any other cells in the same row or column.

  1. Select the cell you want to use. A small square—known as the fill handle—will appear in the bottom-right corner of the cell.
  2. Hover the mouse over the fill handle. The cursor will change to a black cross.
    Selecting the fill handle
  3. Click and drag the fill handle over the cells you want to fill. A dotted black line will appear around the cells that will be filled.
    Filling cells with the fill handle
  4. Release the mouse to fill the selected cells.
    The filled cells

Using the fill handle to continue a series

The fill handle can also be used to continue a series. Whenever the content of a row or column follows a sequential order—like numbers (1, 2, 3) or days (Monday, Tuesday, Wednesday)—the fill handle will guess what should come next in the series. In our example below, the fill handle is used to extend a series of dates in a column.

Using the fill handle to extend a series


The extended series

Challenge!

  1. Open Google Sheets and create a new blank spreadsheet.
  2. Change the spreadsheet title from Untitled Spreadsheet to Practice Spreadsheet.
  3. In cell A1, type the date using the format M/D/YY (for example, 5/30/17).
  4. Use the fill handle to place dates in cells A1:A10.
  5. Use drag and drop to move the dates to cells B1:B10.
  6. Delete the content in cell B5.
  7. When you're finished, your spreadsheet should look something like this:
    Getting Started Challenge Example