Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'anchoring' or 'grounding' part of a formula
hi there - i'd like to multiply a variety of cells by the same cell - so, i'd
like to multiply the information in cell A1 by the information in b1 through b10 and c1 through c10 and d1 through d10. is there a way to set up the formula so that when i copy and paste the a1*b1 to the cell next to it, it says a1*c1 or when i copy and paste below instead of a2*b2 it pastes a1*b2 and then a1*c3 etc etc thanks dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
'anchoring' or 'grounding' part of a formula
When you enter the A1 part, press your <F4 key, and you will notice that A1
changes to $A$1. If you copy $A$1*to the adjacent cell, it will copy as $A$1*C1, and if you copy $A$1*C1 to the cell below, it will change to $A$1*C2. If you press <F4 repeatedly, it will change the $ signs to $A1 and A$1. Doing this will "anchor" either the column or the row indicator. "dave" wrote: hi there - i'd like to multiply a variety of cells by the same cell - so, i'd like to multiply the information in cell A1 by the information in b1 through b10 and c1 through c10 and d1 through d10. is there a way to set up the formula so that when i copy and paste the a1*b1 to the cell next to it, it says a1*c1 or when i copy and paste below instead of a2*b2 it pastes a1*b2 and then a1*c3 etc etc thanks dave |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
'anchoring' or 'grounding' part of a formula
Use absolute references for your anchor cell: $A$1 (note the dollar
signs--this is an absolute reference, so that if you have =$A$1*B1 and copy down you will get $A$1*B2, etc. To keep only the column as an absolute reference, use $A1. To keep only the row as an absolute reference, use A$1. Finally, the reference you're using below is called a relative reference. -- Brevity is the soul of wit. "dave" wrote: hi there - i'd like to multiply a variety of cells by the same cell - so, i'd like to multiply the information in cell A1 by the information in b1 through b10 and c1 through c10 and d1 through d10. is there a way to set up the formula so that when i copy and paste the a1*b1 to the cell next to it, it says a1*c1 or when i copy and paste below instead of a2*b2 it pastes a1*b2 and then a1*c3 etc etc thanks dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Q: DDE Link - Replace Part of the Formula | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
IF/AND Formula seems to only be reading 1st part of formula | Excel Worksheet Functions |