Copy and paste same text in multiple fields- excel 2007

  • Thread starter Thread starter G
  • Start date Start date
G

G

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.
 
You can select the range (F5 or ctrl-g may help you if you know the address),
then type the value and hit ctrl-enter (instead of enter) to fill the selection.
 
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.
 
Yes you can do it. There is no need to name a range. Select the cells in
which you want to enter the same text.

Type your name in the function bar and press ctrl+enter.
 
Thank you for the solution. That makes it a whole lot easier than holding the
mouse and dragging the data all the way down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't copy and paste equations 0
Copy-Paste Chart into Word from Excel 2007 3
Is Paste Special HTML broken in Excel/Office 2007? 1
Copy & Paste 2
Changing Text To Numbers ? 1
Change all text on Spread sheet 1
Excel Paste Formating 3
Copy and paste slow 1

Back
Top