Maitiro ekukopa iyo chaiyo formula muExcel

Paunokopa fomula, Excel inogadzirisa otomatiki mareferensi esero kuitira kuti fomula yacho ikopwe musero idzva rega rega.

Mumuenzaniso pazasi, sero A3 ine formula inopfupikisa kukosha mumaseru A1 и A2.

Kopira fomula iyi musero B3 (sarudza cell A3, dzvanya nzira yekudimbudzira kiibhodhi CTRL + C, sarudza sero B3, uye tinya CTRL+V) uye fomula yacho inozongotaura kune zvakakosha mukoramu B.

Kana iwe usingade izvi, asi uchida kukopa iyo chaiyo formula (pasina kushandura maseru mareferensi), tevera matanho akareruka aya:

1. Isa chitubu mubhari yeformula uye simbisa iyo formula.
2. Dzvanya nzira yekudimbudzira kiibhodhi CTRL + CZvadaro pinda.
3. Simbisa sero B3 uye tinya pane formula bar zvakare.
4. dzvanya CTRL+V, ipapo kiyi pinda .

Mhinduro:

Iye zvino ese masero (A3 и B3) ine fomula imwe chete.