Momwe mungaphatikizire ndikuchotsa zipilala mu Excel?Chotsani mwachangu ma cell ophatikizidwa patebulo

Ngati mulowetsa nambala mu cell (masamu a masamu), idzawoneka ngatiSayansi, koma imafuna kuti iwonetsedwe ngati nambala.Kenako, gawani manambalawo kukhala magawo A ndi B, ndikuwaphatikiza kukhala ndime C, pomwe "=A1&B1".

Ndikufuna kusunga ndime C ndikuchotsa gawo A ndi B, koma ngati ndichotsa gawo A kapena B mosasamala, zomwe zili patsamba C zitha, nditani?

Momwe mungaphatikizire mizati iwiri kukhala tebulo limodzi mu Excel?

Choyamba, tiyeni tiwone momwe EXCEL imaphatikizira deta,Mutha kukwaniritsa kuphatikiza ndikuphatikiza ntchito & ▼

Koperani ndi kuwayika ngati "zofunika"▼

• Kenako chotsani ma cell musanaphatikizepo.

Deta yapakompyuta ya EXCEL imachotsa mwachangu maselo ophatikizidwa

Mukaphatikiza mu EXCEL, chotsani ma cell musanaphatikize, koma sungani deta yophatikizidwa.

Masitepe ogwiritsira ntchito njira iyi ndi awa:

1. Tsegulani tebulo la EXCEL kuti ligwiritsidwe ntchito pakompyuta ndikugwiritsa ntchito kuphatikiza mu cell yopanda kanthu=B4&C4, kenako dinani Enter kuti mumalize kusintha ndikulowetsa ▼

1. Lembani mu cell yopanda kanthu=
2. Mukadina pa cell yoyamba yomwe mukufuna kuphatikiza, lowetsani&
3. Mukadinanso cell yachiwiri yomwe mukufuna kuphatikiza, dinaniEnterlowani
4. Lembani maselo apansi ophatikizidwa ndi dontho pansi

• (muB4ndipoC4Kuti ma cell aphatikizidwa, amatha kusinthidwa malinga ndi momwe zilili)

2. Kenako dinani Ctrl+C kuti mukopere chotsatira chophatikizidwa▼

3. Dinani kumanja pa cell yopanda kanthu ndikusankha "Paste As Value" mu "Paste Special" ▼

• Chotsani ma cell musanaphatikizepo, ndikupeza kuti ma cell asanaphatikizidwe amachotsedwa pambuyo poti tebulo la EXCEL litaphatikizidwa, ndipo ntchito yosunga deta yophatikizidwa yatha.