Daim Ntawv Microsoft Excel txhawb nqa lub peev xwm los tsim cov ntxhuav los tswj thiab txheeb xyuas cov ntaub ntawv muaj feem xyuam. Txhawb nqa lub peev xwm los theej thiab muab rooj thiab lawv qhov chaw nrog tag nrho lossis ib nrab khaws cia ua ntej ntawm kev tawm qauv.
Cov Lus Qhia
Kauj ruam 1
Thaum ua tiav kev luam ntawm lub rooj los ntawm ib daim ntawv mus rau lwm tus, muaj cai-nyem qhov kev sib tshuam ntawm kem npe thiab kab lej. Xaiv daim ntawv los ntawm cov ntawv qhia zaub mov nco-down. Mus rau lwm daim ntawv thiab muab cov ntsiab lus los teev qhia ib seem, xaiv cov khoom "Paste". Tag nrho cov ntaub ntawv yuav muab tso rau hauv tag nrho raws li daim tseem cia nrog (hom ntawv, font, kab ntawv dav, kab qhov siab, thiab lwm yam).
Kauj ruam 2
Hauv qhov xwm txheej uas tsis tiav cov ntaub ntawv theej, lossis muaj ob peb lub rooj ntawm nplooj ntawv, xaiv qhov uas xav tau. Txhawm rau ua qhov no, nias lub pob kom laug thiab, tsis tas tso nws, cab tus contour mus rau cov xov tooj ntawm cov hlwb. Nias Ctrl + c, lossis xaiv "Hloov", "Luam" los ntawm cov ntawv qhia zaub mov tseem ceeb. Tib yam yuav ua tau siv cov ntawv qhia zaub mov siv txoj khawm nas.
Kauj ruam 3
Txoj hauj lwm tus cursor rau lub cell los ntawm qhov koj xav ntxig. Qhov no yuav yog kaum sab laug sab saum toj ntawm cov pasted fragment. Hu rau lub ntsiab lus teb ntawv qhia zaub mov los ntawm txoj cai nas khawm. Nyob rau hauv rooj plaub thaum koj nyuam qhuav yuav tsum tau muab tshuaj txhuam cov hlwb raws li lawv, xaiv "Paste" (lossis Ctrl + v). Yog tias koj tsuas xav tau sau cov qauv ua qauv, khaws qhov dav ntawm cov hlwb, coj mus rau lwm tus li lwm qhov qauv coj mus kuaj, siv Daim Paste Tshwj Xeeb. Tib qho kev pabcuam tso cai rau koj los txuas qhov txuas ntawm cov ntaub ntawv.
Kauj ruam 4
Yog tias koj xav tau ntxiv cov ntawv theej rau hauv lub rooj uas twb muaj lawm, xaiv "Ntxiv cov theej theej hlwb" los ntawm cov ntawv qhia zaub mov. Hauv lub npov xov tooj, hais kom meej tias kom nkag mus rau thaj tsam - hloov mus rau sab xis lossis hloov mus rau qis dua.
Kauj ruam 5
Nrhiav "Ntxig" tab nyob rau hauv cov ntawv qhia zaub mov tseem ceeb ntawm qhov kev zov me nyuam. Nyem rau ntawm no "Kem" khawm. Lub nruas khoom tsim yuav pib ua. Kos cim rau yog tias xav tau dab tsi yog xav tau los ntawm khij lub npov ntawm “Kem nrog kab ntawv”. Nyem rau ntawm lub icon nkag mus xaiv lub cell xaiv hom kom qhia cov chaw ntawm lub rooj. Xaiv lub hlwb yuav tsum tau. Thaum ua tiav, nyem tawm ntawm xaiv xaiv lub icon. Hauv cov khoom raug xaiv, ib lub rooj tshwm nrog cov lus npe xws li "Column1", "Column2", thiab lwm yam.
Kauj Ruam 6
Tib lub sijhawm nrog cov zis ntawm lub rooj tshiab, tus tsim qauv coj thiaj ua tau. Xaiv cov kev pabcuam uas xav tau nyob ntawm cov haujlwm. Koj tuaj yeem tsim lub rooj pivot, tshem tawm cov duplicates, hloov cov ntaub ntawv xaiv rau ntau. Txhawm rau ua haujlwm nrog cov ntxhuav sab nraud, xa tawm, hloov kho tshiab, muaj peev xwm qhib lub rooj hauv qhov browser, tsoo cov kab txuas rau sab nraud cov lus tau muab.
Kauj Ruam 7
Txhawm rau hloov cov qauv ntawm cov khoom tshiab, xaiv qhov tsim nyog tsim nyob rau hauv Table Styles teb ntawm tus tsim qauv. Rau sab xis, hais kom meej cov kev txwv uas xav tau. Tshwj xeeb, txheeb xyuas seb koj puas xav tau kab sib tw header, seb puas yuav tso tawm cov kab sib txuas tag nrho, lossis seb puas yuav qhia txog kab kev hloov pauv lossis lwm seem. Nws yog ib qho ua tau los qhia thawj thawj lossis hauv kem sab nrauv kom pom cov xim.
Kauj ruam 8
Txhawm rau txheeb cov ntaub ntawv, piv txwv li, hauv thawj kab ntawv, nyem daim duab peb sab icon tsis sib thooj lub taub, uas qhib cov ntawv qhia zaub mov ntawm cov haujlwm ntxiv. Cov ntaub ntawv tuaj yeem txheeb nyob rau hauv kev txiav txim siab, nce saum toj, thiab xim. Lwm cov haujlwm cia koj siv cov ntxaij lim dej rau lawv, tshawb cov ntaub ntawv ncaj qha hauv kem no.
Kauj Ruam 9
Txhawm rau pauv cov nqe lus ntawm ib kem, xaiv nws los ntawm ob npaug nias tus nas laug thiab sau lub npe tshiab hauv kab tswv yim rau cov qauv thiab cov ntaub ntawv. Tom qab koj nias lub pob Enter, lub npe yuav tshwm nyob qhov yog.
