How do I copy formula into cells of a very big worksheet

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

Guest

Hello all,

I would like to be able to copy a formaula into cells, or better say, a
column of a worksheet which has over 50,000 rows. I can do it by dragging the
cell over the others, but is there a way to do this without having to go
through this dragging thing?

Your input is greatly appreciated.
 
Henry88th said:
I would like to be able to copy a formaula into cells, or better say, a
column of a worksheet which has over 50,000 rows. I can do it by
dragging the cell over the others, but is there a way to do this without
having to go through this dragging thing?
Click to expand...

First, select one cell and copy the formula (ctrl-C or right-click Copy).

Then, enter the range ("50,000 rows") into Name Box, which is usually in the
upper left of the Formula Bar. That will select that range.

Finally, paste the formula (ctrl-V or right-click Paste or Paste Special).
 
If you have contiguous data in the column next to the one you want to
copy the formula down (either on the left or the right), then you can
select the cell with the formula in and double-click the fill handle -
this is the small black square in the bottom right corner of the
cursor (the mouse pointer will change to a thin cross when you hover
over it).

Hope this helps.

Pete
 
In the destination sheet:

Press F5
Type A5000, press ENTER
Cell A50000 is now selected.
Press CTRL+SHIFT+Arrow-up
A1:A50000 is now selected, so you can paste into it

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello all,
|
| I would like to be able to copy a formaula into cells, or better say, a
| column of a worksheet which has over 50,000 rows. I can do it by dragging the
| cell over the others, but is there a way to do this without having to go
| through this dragging thing?
|
| Your input is greatly appreciated.
 
<Type A5000, press ENTER>

Of course that should have been A50000

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| In the destination sheet:
|
| Press F5
| Type A5000, press ENTER
| Cell A50000 is now selected.
| Press CTRL+SHIFT+Arrow-up
| A1:A50000 is now selected, so you can paste into it
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|| Hello all,
||
|| I would like to be able to copy a formaula into cells, or better say, a
|| column of a worksheet which has over 50,000 rows. I can do it by dragging the
|| cell over the others, but is there a way to do this without having to go
|| through this dragging thing?
||
|| Your input is greatly appreciated.
|
|
 
Another

Sub copytocells()
mycol = Range(InputBox("Col Letter") & 1).Column
myrows = InputBox("Number of rows")
Range("c1").Copy _
Range(Cells(1, mycol), Cells(myrows, mycol))
End Sub
 
Back
Top