Copying Formulas

 
Home
Excel Welcome
Spreadsheet Tutorial
Why on a Computer?
Basics of a Spreadsheet
COLUMN Defined
ROW Defined
CELL Defined
150Data Types
Labels in Excel
Constants in Excel
Formulas in Excel
Basic Formulas in Excel
Change in Formulas
Basic Math Functions
Methods of Selecting Cells
Sum Function
Average Function
Max Function
Min Function
Count Function
CountA Function
IF Function
PMT (loan stuff)
SIN COS TAN etc.
Function Wizard
Copying Formulas
Fill Down
Absolute Positioning
Fill Right
Formatting Text
I P Copying Formulas N

Sometimes when we enter a formula, we need to repeat the same formula for many different cells. In the spreadsheet we can use the copy and paste command. The cell locations in the formula are pasted relative to the position we Copy them from.

ABC
153=A1+B1
282=A2+B2
346=A3+B3
438=? + ?
 Cells information is copied from its relative position. In other words in the original cell (C1) the equation was (A1+B1). When we paste the function it will look to the two cells to the left. So the equation pasted into (C2) would be (A2+B2). And the equation pasted into (C3) would be (A3+B3).

If you have a lot of duplicate formulas you can also perform what is referred to as a FILL DOWN. (discussed next). 988032

  info@exceltalk.net