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.
- Select a cell, then hover the mouse over an outside edge of the blue box. The cursor will turn into a hand icon.
- Click and drag the cell to its desired location.
- Release the mouse to drop the 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.
- 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.
- Hover the mouse over the fill handle. The cursor will change to a black cross.
- 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.
- Release the mouse to fill the selected 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.
- Open Google Sheets and create a new blank spreadsheet.
- Change the spreadsheet title from Untitled Spreadsheet to Practice Spreadsheet.
- In cell A1, type the date using the format M/D/YY (for example, 5/30/17).
- Use the fill handle to place dates in cells A1:A10.
- Use drag and drop to move the dates to cells B1:B10.
- Delete the content in cell B5.
- When you're finished, your spreadsheet should look something like this: