Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-04-2014, 12:19 PM
Volition87 Volition87 is offline Help with multiplication Windows XP Help with multiplication Office 2010 32bit
Novice
Help with multiplication
 
Join Date: Dec 2014
Posts: 2
Volition87 is on a distinguished road
Default Help with multiplication

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.
Reply With Quote
  #2  
Old 12-04-2014, 12:30 PM
PStark PStark is offline Help with multiplication Windows 7 64bit Help with multiplication Office 2013
Novice
 
Join Date: Dec 2014
Posts: 8
PStark is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 12-04-2014, 12:31 PM
PStark PStark is offline Help with multiplication Windows 7 64bit Help with multiplication Office 2013
Novice
 
Join Date: Dec 2014
Posts: 8
PStark is on a distinguished road
Default

Left Click**** I apologize I meant Left Click when I said right
Reply With Quote
  #4  
Old 12-04-2014, 12:37 PM
Volition87 Volition87 is offline Help with multiplication Windows XP Help with multiplication Office 2010 32bit
Novice
Help with multiplication
 
Join Date: Dec 2014
Posts: 2
Volition87 is on a distinguished road
Default

Big thanks for this
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with multiplication Multiplication in pivot divya Excel 1 10-23-2014 01:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft