Ungakopisha kanjani ifomula ngqo ku-Excel

Lapho ukopisha ifomula, i-Excel ilungisa ngokuzenzakalelayo izinkomba zeseli ukuze ifomula ikopishelwe kuseli elisha ngalinye.

Esibonelweni esingezansi, iseli A3 iqukethe ifomula ehlanganisa amanani kumaseli A1 и A2.

Kopisha le fomula kuseli B3 (khetha iseli A3, cindezela isinqamuleli sekhibhodi I-CTRL + C, khetha iseli B3, bese ucindezela I-CTRL + V) futhi ifomula izobhekisela ngokuzenzakalelayo kumanani akukholomu B.

Uma ungakufuni lokhu, kodwa ufuna ukukopisha ifomula okuyiyonayona (ngaphandle kokushintsha izinkomba zeseli), landela lezi zinyathelo ezilula:

1. Beka ikhesa kubha yefomula bese ugqamisa ifomula.
2. Cindezela isinqamuleli sekhibhodi I-CTRL + CBese Faka.
3. Gqamisa iseli B3 bese uchofoza ibha yefomula futhi.
4. Cindezela I-CTRL + V, bese kuba ukhiye Faka .

Umphumela:

Manje womabili amaseli (A3 и B3) aqukethe ifomula efanayo.