Paste single item into multiple rows?

  • Thread starter Thread starter GeekBoy
  • Start date Start date
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!
 
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)
 
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.
 
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...
 
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.

 
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.
 
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!
 
Back
Top