![]() |
#1
|
|||
|
|||
![]()
First Hi Everyone.
I'm new here, and i could say i'm new to Excel :P This is my first time i have to make an table in Excel and ofc its kinda hard for me... Here is what i need to do I have a table with 5 columns and like 1000 rows. i've started to add the functions manually but i think ill go crazy if i continue with this... (my bad english prevents me from writing down whats realy about) so im at 137th row wrtiting down in F136 function =D136*E136 is there any fast way to do it for all 1000 rows ![]() I am kinda sure some of you will ROFL about this, but what to say, i'm a newb. |
#2
|
|||
|
|||
![]()
Select the F136 box and in the bottom right corner there should be a solid black square. Right click and hold that little black box, then drag down to your desired box and it should auto complete the formula for you. This should work for any formula there isn't anything special about that cell, I just assumed it was the last box in your line.
|
#3
|
|||
|
|||
![]()
Left Click**** I apologize I meant Left Click when I said right
|
#4
|
|||
|
|||
![]()
Big thanks for this
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
divya | Excel | 1 | 10-23-2014 01:23 PM |