You can also drag the bottom right corner of the cell to drag the cell contents into other cells, like you do in any of your spreadsheet applications.
You can drag and fill single column, or you can select multiple columns and then drag and fill in one go.