Paste single item into multiple rows?

G

GeekBoy

I am trying to select a single column and paste one item into all the rows
in that column.

How can I do this?

It is such a simple task in Google Document, but a nightmare in Excel 2007.

I see you can use "fill" option, but that fills that column till the maximun
capacity of Excel.
Paste, and Paste Special are also worthless.

Thanks!
 
D

Dave Peterson

I selected the cell to copy.
I hit ctrl-c to copy it.
I selected a new column (the entire column!)
I hit ctrl-v to paste
All 64k rows were filled.

(xl2003)
 
G

GeekBoy

Dave Peterson said:
I selected the cell to copy.
I hit ctrl-c to copy it.
I selected a new column (the entire column!)
I hit ctrl-v to paste
All 64k rows were filled.
Click to expand...


Yes and that is exactly not what I do not want.
I only want till end of the last of filled cells.
 
B

Bob I

Then you will need to select the cell/rows to be filled instead of "all
the rows in the column" as you previously stated.
I selected the cell to copy.
I hit ctrl-c to copy it.
I selected a new column (the entire column!)
I hit ctrl-v to paste
All 64k rows were filled.
Click to expand...



Yes and that is exactly not what I do not want.
I only want till end of the last of filled cells.
Click to expand...
 
G

GeekBoy

Bob I said:
Then you will need to select the cell/rows to be filled instead of "all
the rows in the column" as you previously stated.
Click to expand...


Sorry, but there must be an easier way than selecting 20 Thousand rows.

 
G

GeekBoy

with a mouse that is.


Bob I said:
Then you will need to select the cell/rows to be filled instead of "all
the rows in the column" as you previously stated.
Click to expand...
 
B

Bob I

If you know the first one is say c2 and the last one is c20123 then
after you copy the source cell, click the cell address box in the upper
left corner of the sheet and type in C2:C20123 an press enter.
 
G

GeekBoy

Bob I said:
If you know the first one is say c2 and the last one is c20123 then after
you copy the source cell, click the cell address box in the upper left
corner of the sheet and type in C2:C20123 an press enter.
Click to expand...



Oh, okay..that is not too bad. Thanks a lot!
 

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

How can I merge data from multiple columns into a single column in Microsoft Excel? 0
Excel Unable to insert cut rows into Excel online anymore? 0
Excel copy into Word problem 5
Blank Charts and Paste Special 5
Convert Word To Excel 2
How can I paste into merged cells? 2
Column Of Numbers To A Text Format Problem 1
Copy chart and paste it as a PICTURE back into Excel 3

Top