hat
Nòmalman Excel ajiste referans selil yo si ou kopye fòmil ou nan yon lòt kote nan fich travay ou a. Ou ta dwe ranje tout referans selil ak yon siy dola ($) oswa laprès F4 kle nan aktive relatif la bay referans absoli pou anpeche ajiste referans yo selil nan fòmil otomatikman. Si ou gen yon ran de fòmil bezwen kopye, metòd sa yo pral trè fatigan ak tan konsome. Si ou vle kopi fòmil yo san yo pa chanje referans selil rapidman ak fasil, eseye metòd sa yo:
eng
Normally Excel adjusts the cell references if you copy your formulas to another location in your worksheet. You would have to fix all cell references with a dollar sign ($) or press F4 key to toggle the relative to absolute references to prevent adjusting the cell references in formula automatically. If you have a range of formulas need to be copied, these methods will be very tedious and time-consuming. If you want to copy the formulas without changing cell references quickly and easily, try the following methods: