spreadsheet question

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

Guest

I have a line in a spreadsheet that I want to copy, and then paste it about 700-1000 times.. Is there an easy way to do this without manually copying and pasting? Ill be here all year if I have to do that

Thanks soooo much for any input!
 
Hi.

Depending on how your data is arranged and where you
want to paste to, you can
1) select the cells with data to copy and then put
your cursor on the bottom right corner (the cursor
changes to a +) and then drag down.
or
2) copy the data in your cells, then go select all
the cells you want to copy to and hit ctrl+V. All the
cells should be filled.

If you have places to paste your data that are not
contiguous, you'll have some work to do.

HTH.
jeff
-----Original Message-----
I have a line in a spreadsheet that I want to copy, and
Click to expand...
then paste it about 700-1000 times.. Is there an easy way
to do this without manually copying and pasting? Ill be
here all year if I have to do that!
 
You must log in or register to reply here.

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

Alt codes 4
Cut & Paste in Excel without erasing cell borders? 1
Automatically skipping cells when pasting data 1
problem with fractions to decimal 1
Some charts won't copy properly from Excel 2007 6
Spreadsheet Formatting Problem 2
How to make a long sentence wordwrap 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0

Back
Top