Tus lej hloov pauv feem ntau yog siv ntau hauv Excel. Piv txwv li, xam txhua hli lossis tag nrho cov kev hloov pauv.
Hloov txhua hli
- Xaiv lub cell C3 thiab sau cov qauv qhia hauv qab no.
- Xaiv lub cell C3 thiab siv feem pua hom ntawv rau nws.
- Txhawm rau kom tsis txhob rov ua dua 1st thiab 2nd kauj ruam kaum ntxiv, xaiv lub xov tooj ntawm tes C3, nyem rau ntawm nws sab xis ces kaum thiab luag nws mus rau hauv lub xov tooj ntawm tes C13.
- Xyuas seb txhua yam mus zoo.
Kev hloov pauv dav dav
- Ib yam li ntawd, peb tuaj yeem suav tag nrho cov kev hloov pauv. Lub sijhawm no peb kho qhov kev siv rau ntawm tes V2. Highlight ib cell D3 thiab sau cov qauv qhia hauv qab no.
- Xaiv lub cell D3 thiab siv feem pua hom ntawv rau nws.
- Highlight ib cell D3, nyem rau ntawm nws sab xis ces kaum thiab luag nws mus rau hauv lub xov tooj ntawm tes D13.
- Xyuas seb txhua yam mus zoo.
Piav qhia: Thaum peb rub (daim) cov qauv hauv qab, qhov kev siv tsis raug ($B$2) tseem tsis hloov, tab sis tus txheeb ze siv (B3) hloov - B4, B5, B6, thiab lwm yam. Qhov piv txwv no yuav nyuaj rau koj nyob rau theem no, tab sis nws qhia qee qhov muaj txiaj ntsig thiab muaj txiaj ntsig zoo uas Excel muaj.