Filling data

If you want to copy an item of data across a row or down a column, you can use the Fill buttons to make this easier. You might want to do this if, for example, you were working on your accounts and needed to enter a fixed payment into every month.

To copy data by filling:

  1. Enter the data into the first cell in the row or column.
  2. Select that cell and the rest of the cells in the row or column where you want the data to appear.
  3. If you are filling across a row, click on the Fill right button. If you are filling down a column, click on the Fill down button.
  4. Your data will be copied into the selected cells.

For information on the way pasting and filling affect cell references in formulae, see Cell references.