How to apply a formula accross all the rows when the total rows are too much in no. ?

S

sorabh

Hi,
guyz i know you can drag the formula accross the rows in that column t
have that formula in effect in every cell. but i have some data lik
5000 rows then how to get that formula accross each cell, its painfu
holding the mouse and dragging the formula accross the rows.
please advise
thanks in advance

sorab
 
F

Frank Kabel

Hi
after inserting this formula in the first row double click on the lower
right corner of your cell selection
 
D

David Biddulph

sorabh > said:
Hi,
guyz i know you can drag the formula accross the rows in that column to
have that formula in effect in every cell. but i have some data like
5000 rows then how to get that formula accross each cell, its painful
holding the mouse and dragging the formula accross the rows.
please advise
thanks in advance
Click to expand...

Select the cell from which you want to copy, then Edit/Copy (or Ctrl+C),
then select the first cell in the range to which you want to copy, then
Shift+select the last cell in the range, then Edit/Paste (or Ctrl+V).
 
H

hcj

Hi sorabh,
Try this. Copy (Ctrl+C) the formula in the top cell.
Move to the bottom cell and hit Shift+click, thus
selecting all cells in the column range. Then paste
(Ctrl+V).

Hope this speeds things up a bit.
 
R

Ron Rosenfeld

Hi,
guyz i know you can drag the formula accross the rows in that column to
have that formula in effect in every cell. but i have some data like
5000 rows then how to get that formula accross each cell, its painful
holding the mouse and dragging the formula accross the rows.
please advise
thanks in advance

sorabh
Click to expand...

Much quicker to do than to describe :))

Let us say you have data in A1:A5000. You put a formula in B1 and wish to drag
it down to B5000.

1. Put the formula in B1.
2. Select A1.
3. <ctrl><down> takes you to A5000.
3. <right-arrow> to B5000.
4. <ctrl><shift><up> takes you to B1 and selects the range B1:B5000.
5. Edit/Fill/Down (or <ctrl><D>) will copy the formula in B1 down to B5000,
adjusting the cell references appropriately.


--ron
 
S

sorabh

Hey
guyz
thanks a lot ............ all of you... may god bless all of u
with....everything u want ;)
regard
sorab
 
H

hcj

How elegant! Thank you, sir.
-----Original Message-----
Hi
after inserting this formula in the first row double click on the lower
right corner of your cell selection


--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Top