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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henry88th - 07 Nov 2007 10:11 GMT

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.

Reply to this Message

joeu2004@hotmail.com - 07 Nov 2007 11:05 GMT

> 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?

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

Reply to this Message

Pete_UK - 07 Nov 2007 11:33 GMT

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

On Nov 7, 10:11 am, Henry88th <Henry8...@discussions.microsoft.com>
wrote:

> Hello all,
>
[quoted text clipped - 4 lines]
>
> Your input is greatly appreciated.

Reply to this Message

Niek Otten - 07 Nov 2007 11:59 GMT

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

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello all,
|
[quoted text clipped - 4 lines]
|
| Your input is greatly appreciated.

Reply to this Message

Niek Otten - 07 Nov 2007 12:07 GMT

<Type A5000, press ENTER>

Of course that should have been A50000

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| In the destination sheet:
|
[quoted text clipped - 12 lines]
||
|| Your input is greatly appreciated.

Reply to this Message

Don Guillett - 07 Nov 2007 14:47 GMT

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

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hello all,
>
[quoted text clipped - 5 lines]
>
> Your input is greatly appreciated.

Reply to this Message