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:
For information on the way pasting and filling affect cell references in formulae, see Cell references.