Hauv Microsoft Office Excel, koj tuaj yeem muab koj lub npe rau ib tus neeg ntawm tes lossis rau txhua qhov chaw ntawm lub rooj. Feem ntau, cov sijhawm no tau siv rau qhov yooj yim ntawm kev nkag mus rau cov ntaub ntawv muaj npe los ntawm cov qauv, thiaj li tsis qhia qhov chaw nyob txhua lub sijhawm. Kev muab thiab hloov cov npe muab tso rau cov chaw hauv kab ntawv yog yooj yim thiab tuaj yeem ua tau ob peb txoj hauv kev.
Tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Xaiv qhov chaw npe koj xav pauv. Yog tias nws yog kem, nyem rau nws lub header. Saum cov lus, saum kab taub hau, yog lub phij cuam formula. Qhov chaw nyob ntawm tus xovtooj ntawm tam sim no raug qhia nyob rau sab laug ntawm kab no. Tom qab xaiv cov npe muaj npe lossis qhov chaw cais, qhov chaw nyob hauv nws yuav tsum tau hloov los ntawm lub npe muab rau ntau. Yog tias tom qab xaiv cov kem no tsis tshwm sim, tom qab ntawd lub npe tau muab tso tsis yog rau tag nrho cov ntawv, tab sis rau ib pab pawg ntawm cov hlwb hauv nws. Maj mam nthuav tawm cov hlwb ntawm kem los ntawm sab saum toj mus rau nram qab, tos kom lub npe tshwm rau hauv daim teb no thiab mus rau theem tom ntej.
Kauj ruam 2
Xaiv lub npe kem nyob rau sab laug ntawm cov kab kob thiab hom tshiab. Hauv qhov no, siv cov tsiaj ntawv ntawm Lavxias lossis Latin cov tsiaj ntawv, cov lej thiab ib tug tsis muaj qab, tag nrho cov lej yuav tsum tsis txhob muaj ntau dua 255 tus cim. Thaum koj ua tiav kev ntaus ntawv, nias sau thiab lub npe tshiab ntawm kev xaiv yuav raug pinned.
Kauj ruam 3
Qhov thib ob kauj ruam tuaj yeem hloov los ntawm kev siv lub rooj sib tham nrog cov ncauj lus kom ntxaws ntxiv ntawm cov npe. Txhawm rau hu nws, mus rau Formulas tab thiab hauv Defined Names pawg ntawm cov lus txib, qhib Daim Ntawv Teev Npe Assign Npe-qhib. Qhov xav tau ntawm cov npe no tau sau npe zoo ib yam - "Tuav ib lub npe".
Kauj ruam 4
Hauv daim ntawv "Lub Npe" ntawm daim ntawv "Tsim Npe", sau lub npe tshiab rau kem. Hauv cov "Cov Cheeb Tsam" nqis npe, xaiv ib nplooj ntawv los yog ib phau ntawv ua haujlwm uas nws cov qauv yuav tsum siv tau lub npe no. Hauv daim "Sau Npe", koj tuaj yeem ntaus cov lus piav qhia. Tsis tas yuav hloov pauv tus nqi hauv lub tshav "Khwv" Ntau, vim hais tias Excel twb muab tso rau qhov chaw nyob hauv nws lawm. Nyem OK thiab kem lub npe yuav raug hloov pauv.
Kauj ruam 5
Feem ntau, hloov npe lub npe txhais tau tias kev ua haujlwm sib txawv kiag li - hloov cov txheej txheem kev sib hais. Los ntawm lub neej ntawd, kem hauv Excel cov lus yog txhais los ntawm Latin cov tsiaj ntawv, uas tau siv ua chaw nyob kem. Daim ntawv tsim qauv tuaj yeem hloov nrog tus lej. Yog tias koj xav tau ua raws nraim qhov no lossis rov qab ua haujlwm, ua nws dhau ntawm Excel chaw. Hauv xyoo 2010, qhib cov ntawv qhia zaub mov uas siv khawm khawm thiab xaiv Xaiv. Hauv xyoo 2007 version, lub pob no hu ua Office, thiab txhawm rau nkag mus rau lub chaw, nyem rau ntawm "Excel Settings" khawm hauv cov ntawv qhia zaub mov.
Kauj Ruam 6
Nkag mus rau tshooj "Cov txheej txheem" ntawm lub khoos phis tawm ntawm lub khoos phis tawm thiab hauv "Ua haujlwm nrog cov qauv" kos rau lossis kos lub thawv "R1C1 link style". Nyem OK thiab txoj kev sau rau kem npe yog yuav pauv.
