Excel cov ntawv nthuav qhia yog ib qho cuab yeej siv tau los ntawm yuav luag txhua tus: cov tub ntxhais kawm, cov tub ntxhais kawm, cov kws tshaj lij hauv kev tsim khoom, thiab txawm tias cov niam tsev uas tab tom suav tsev neeg cov nyiaj txiag. Lub interface ntawm cov khoom lag luam software no yog tus phooj ywg zoo thiab muaj kev paub, thiab koj tuaj yeem paub qee tus ntawm subtleties thiab nuances ntawm kev ua haujlwm nyob rau hauv cov ntawv sau nthuav tawm thaum ua qee yam haujlwm.
Cov Lus Qhia
Kauj ruam 1
Xaiv kab ntawv uas nws dav koj xav hloov. Txhawm rau ua qhov no, cia li tshem tus cursor dhau tus ntawv, uas nws tau tsim ua haujlwm tav toj, thiab nyem rau ntawm nws nrog sab laug nas khawm. Koj tuaj yeem xaiv ob peb kab ntawv uas nyob ib sab lossis cov uas tsis nyob ze rau qhov chaw uas raug xaiv. Yog tias koj xav xaiv cov kab ntawv nyob ib sab, nyem rau ntawm lawv thawj thiab ntawm qhov kawg, thaum tuav cia tus yawm sij Shift. Yog tias koj xav tau xaiv ob peb kab uas tsis nyob ib sab kom hloov qhov dav, khij qhov xaiv thaum tuav cia tus yuam sij Ctrl. Koj tuaj yeem hloov qhov dav ntawm kab ntawv xaiv lossis ob peb txoj kev siv ntau txoj hauv kev.
Kauj ruam 2
Tso tus cim tus cim rau ntawm sab xis ntawm lub xov tooj ntawm uas tsab ntawv yog sau thiab cab nws, kho tus kheej ntawm cov kab ntawv dav dav "los ntawm qhov muag". Ua ke nrog cov kem no, qhov dav ntawm tag nrho lwm cov uas koj xaiv yuav hloov pauv. Nws yuav zoo ib yam rau txhua tus, txawm tias lawv qhov pib dav txawv.
Kauj ruam 3
Hauv cov ntawv qhia zaub mov "Tsev" xaiv lub teb "Cell" thiab nyem rau ntawm kab ntawv "Hom", xaiv qhov khoom thib peb los ntawm sab saum toj - "Kem dav". Hauv lub thawv qhib uas qhib, koj tuaj yeem tsim qhov xav tau ntawm kab dav los ntawm kev ntaus nws tus nqi pes tsawg. Qhov dav ntawm txhua kab ntawv xaiv yuav ua ncaj rau tus nqi no.
Kauj ruam 4
Yog tias koj xav tau kho cov kem dav raws li qhov ntev ntawm kab ntawm kab ntawv lossis cov lej muaj nuj nqis, ua raws tib theem, tsuas xaiv plaub kab los ntawm sab saud - "AutoFit Dav" los ntawm "Ntawv qhia" ntawv qhia zaub mov. Hauv qhov no, qhov dav ntawm txhua kem xaiv yuav txawv. Rau txhua ntawm lawv, nws yuav dhau los ua qhov ntev ntawm cov ntaub ntawv nyob hauv kab ntawv no, uas muaj cov cim ntau ntawm cov cim. Qhov no yooj yim thaum cov naj npawb ntawm cov kab nyob hauv lub rooj yog qhov loj heev, thiab koj tsis tas yuav thawb nws los teeb cov kab ntawv qhov xav tau ntawm tus kheej. Autofit dav kuj tseem tuaj yeem ua los ntawm ob zaug nias ntawm txoj cai ciam teb ntawm tsab ntawv nqe lus ntawm kab ntawv xaiv.
