I'd be surprised if you can't do it the same as in Excel 2003. Having put it
in one cell, copy, then select your 400 cells & paste.
--
David Biddulph

"G" wrote in message
...
I have excel 2007 and want to be able to insert the same text into hundreds
of cells. Right now I'm highlighting the text and using the drag and drop
method. Is there an easier way.

Example- the word test. How would I copy that word into 400 plus cells at
the same time.

Thanks.