Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to copy a formula to a 100 cells
e4=1.075 Tax
=c10*e4 original formula =c11*e5 (should be e4) =c12*e6 (should be e4) =c13*e7 (should be e4) =c14*e8 (should be e4) =c15*e9 (should be e4) =c16*e10 (should be e4) =c17*e11 (should be e4) =c18*c12 (should be e4) =c19*c13 (should be e4) I need to copy the formula C10*E4 to a hundred rows. I need E4 to stay the same and not Increment to e5,e6.e7.e8 ect. what do I put infront of e4 to stop it from incrementing |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy cells using formula | Excel Worksheet Functions | |||
Copy Cells Formula | Setting up and Configuration of Excel | |||
Using formula to copy cells | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
copy cells with formula without references | Excel Worksheet Functions |