Thank you, this helped and I got it to work on a couple of columns.

Sometimes when I try to do this, however, it states that the data in the
cell I am copying into the other cells is not the same size (it's one cell
going into multiple cells).

??

"Ron de Bruin" wrote:

Hi BusyHighLighter

If you select for example A1:A10 and enter some text you can use Ctrl Enter to fill all
cells with your text.
Another way is to copy the cell and paste it in the other cells

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"The BusyHighLighter" <The wrote in message
...
Hello,

I'm new to this forum and have a question about repeating things in cells.
How can I paste the contents of one cell into more than one cell?

I'm trying to make an address book and take the state abbreviation into
several cells.

Thank you!