Cov hlua hauv daim ntawv nthuav qhia Microsoft Office Excel tsis yog ib txwm hu ua qhov qub uas yog txhais thaum ua haujlwm nrog cov ntawv nyeem lub tiaj - hauv daim ntawv thov no, xws li cov lus txhais tau muab rau tus lej ntawm lub rooj hlwb hlau. Yog li no, tus kwv ntawm lub lag luam hloov chaw ntawm no tuaj yeem yog pawg kab rov tav ntawm cov kab ntawv ntawm cov kab ntawv lossis kab ntawv ntawm cov ntawv tso rau hauv lwm cov kem.
Tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Tom qab tsim cov ntawv xov xwm tshaj tawm, thauj cov ntawv xav tau rau hauv nws thiab xaiv kab uas koj xav hloov mus rau lwm qhov chaw hauv lub rooj no. Txhawm rau ua qhov no, sab laug nyem rau ntawm kab ntawv ntawm kab xav tau ntawm cov kab - ntawm lub xov tooj nrog tus naj npawb ntawm txoj kab, muab tso rau sab laug ntawm thawj kem.
Kauj ruam 2
Txiav rau txoj kab xaiv - nias qhov tseem ceeb ua ke Ctrl + X lossis nyem-xaiv xaiv thiab xaiv "Txiav" los ntawm cov ntawv qhia lub ntsiab lus teb.
Kauj ruam 3
Xaiv cov kab ntawm lub rooj nyob rau hauv pem hauv ntej ntawm qhov koj xav tso rau kab yuav raug qhwv, thiab rov qhib cov ntawv qhia zaub mov ntsiab lus - nyem txoj xaiv xaiv. Lub sijhawm no, xaiv "Paste Hlais Hlua" hais kom ua thiab ua haujlwm cov kab ua haujlwm yuav ua tiav.
Kauj ruam 4
Yog tias koj tsis tas yuav tsiv txoj kab, tab sis ntxig rau "tsis xaus" ntawm kab ntawv hauv qhov chaw tshwj xeeb ntawm cov kab ntawv ntawm ib ntawm cov hlwb, pib los ntawm tig rau hom kho kom raug rau lub xov tooj ntawm no. Txhawm rau ua qhov no, xaiv nws thiab nyem ob npaug rau sab laug nas khawm lossis nias F2 tus yuam sij. Tom qab ntawd txav tus cursor mus rau txoj haujlwm xav tau thiab nias qhov tseem ceeb ua ke alt="Duab" + Sau. Txhua cov ntawv sau tshuav rau sab xis ntawm tus cursor yuav muab qhwv rau kab tom ntej.
Kauj ruam 5
Yog tias koj xav tau cia li tso cov cim rau hauv tag nrho cov kab ntawm ib qho kab ntawv uas muaj kab ntawv uas tsis haum rau qhov dav ntawm ib kem, xaiv tag nrho cov lus - nias Ctrl + A. Yog tias cov ntawv tsis nyob hauv txhua kab thiab kab, koj tuaj yeem xaiv xwb qhov tsim nyog ntawm lub rooj. Tom qab ntawv, nyob rau ntawm Lub Tsev tab, hauv Excel cov zaub mov, nyem khawm Cov Ntawv Sau - nws nyob rau sab xis sab xis saum toj ntawm Align cov lus txib pab pawg.
Kauj Ruam 6
Tib cov txiaj ntsig tuaj yeem tiav hauv lwm txoj kev. Tom qab xaiv cov cheeb tsam uas yuav tsum tau ntawm lub rooj, nyem nws thiab xaiv kab "Format hlwb" kab hauv cov ntawv qhia zaub mov. Lub qhov rais cais yuav qhib, uas mus rau "Alignment" tab thiab kos rau lub thawv "Qhwv los ntawm cov lus". Tom qab ntawd nias lub khawm OK thiab cov haujlwm yuav ua tiav.
