Microsoft excel cell formatting

Question

Can someone tell how I format a cell so when I multi-copy the cell down a page to another worksheet the same cell is repeated rather than copying each cell down the page?

Many thanks

Ken