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

H

Henry88th

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.
 
J

joeu2004

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).
 
P

Pete_UK

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
 
N

Niek Otten

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.
 
N

Niek Otten

<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.
|
|
 
D

Don Guillett

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
 
Top