Auto-filling data in spreadsheets


You can automatically fill in data into its adjacent cells by designating the specific area.

Fill Data Down

Perform the following to fill the selected range with the same data that is in the first cell of the selected range.
  1. Select a range of cells that you want to fill with the same data.

  2. Click Edit and Fill-Down.

Fill Data with Mouse

Perform the following to fill the cells with the data by dragging the mouse.
  1. Place the mouse on the cell handle ( mouse_00.png ) to change the mouse pointer to the cross ( mouse_01.png ).
  2. Hold down the left mouse button and drag the cross (mouse_01.png) until you reach the last cell where you want to finish the data fill.
  3. Release the mouse button.
Was this article helpful?
1 out of 3 found this helpful



Article is closed for comments.

Articles in this section