Feem ntau, cov ntaub ntawv lej kev ua zauv yuav tsum ua cov haujlwm nyuaj rau ntawm cov lej muaj zauv. Feem ntau, nws tsis muaj teeb meem rau qhov kev zov me nyuam txawm hais tias cov txiaj ntsig ntawm cov qhob hloov tau sau rau hauv kab lossis kab - qhov tsis muaj qhov xav tau tuaj yeem tsim tawm hauv cov qauv. Tab sis yog tias koj xav tau los ua qee qhov kev ua nrog rau tag nrho kev ntsuas, koj yuav tsum coj mus rau hauv tus account tias Excel yuav muaj peev xwm ua txoj haujlwm ua haujlwm kom raug yog tias cov nuj nqi nyob hauv kab ntawv.
Cov Lus Qhia
Kauj ruam 1
Txawm li cas los xij, qhov xwm txheej no feem ntau tshwm sim thaum ua cov yeeb yaj duab sib txheeb zoo uas siv ntsuas tsom xam pob cov khoom ntxiv. Feem ntau kev ua lag luam matrix xav tau "tig" rau qhov yooj yim rau kev ua haujlwm ntxiv. Hauv ob qho tib si, hauv chav kawm yuav tsum muaj kev cuam tshuam lossis hloov pauv. Tom qab ntawd cov kab yuav tau "ntxeev" rau hauv kem.
Kauj ruam 2
Txhawm rau hla, cia li xaiv cov ntawv tsim nyog uas yuav tsum tau nrog tus cursor thiab luam nws mus rau daim ntawv txiav tawm siv cov ntawv qhia luv luv Ctrl + C, Ctrl + Ntxig, lossis los ntawm xaiv cov "Luam" cov khoom hauv "Hloov" ntawv qhia zaub mov. Muab tus cursor tso rau hauv A1 yog tias koj yuav mus rau qhov chaw hloov pauv ntawm daim ntawv tshiab. Tib txoj kev, koj tuaj yeem ntxig rau transposed matrix rau hauv daim ntawv qub, tshem cov thawj cov ntaub ntawv. Nws tsis yog yooj yim heev los tso qhov chaw hloov pauv ntawm tib daim ntawv thaum khaws daim qub thiab nws raug nquahu tsuas yog rau arrays ntawm ntim me me.
Kauj ruam 3
Tom qab ntawv xaiv Paste Tshwj Xeeb los ntawm cov ntawv qhia zaub mov kho kom raug. Koj yuav tsum tshaj tawm nrog lub "Paste Tshwj Xeeb" qhov rai, uas koj tuaj yeem qhia ntau yam kev txwv ntxiv. Qhov kawg kawg ntawm kev ua haujlwm yuav muaj ob lub npov: "hla lub hlwb khoob" thiab "transpose". Khij lub thawv ntawv tom kawg. Yog tias qhov txiaj ntsig ntawm cov khoom sib txawv tau hammered hauv "ntawm tes", tsuas yog nias OK kom ua tiav txoj haujlwm. Qhov no yuav yog kom txaus kom raug raws li cov thawj kev ntsuas.
Kauj ruam 4
Yog tias cov txiaj ntsig hauv cov ntsuas yog qhov tshwm sim ntawm kev suav siv qee cov qauv, rau kev hloov kho kom raug, koj yuav tsum tau qhia ntxiv cov kev txwv ntxiv hauv qhov "Paste Tshwj Xeeb" los ntawm "paste" pab pawg ntawm cov lus txib. Yog tias koj tsis xav tau daim qauv qub, xaiv qhov Tseem Ceeb lossis Qhov Muaj Nuj Nqis thiab Cov Qauv. Cov ntawv tom kawg yog xaiv thaum nws tsim nyog los khaws lub hom qub ntawm lub hlwb.
Kauj ruam 5
Thaum xaiv ib lossis lwm txoj hauv kev ntxig nrog kev khaws cia ntawm cov qauv, koj yuav tsum coj mus rau hauv tus lej version ntawm koj lub Chaw Haujlwm. Pib nrog xyoo kaum ntawm Office, suav nrog MS Excel 2002, cov qauv tuaj yeem hloov pauv yam tsis suav nrog qhov "tsis zoo" ntawm cov kev hloov pauv hloov: qhov kev zov me nyuam yuav txiav txim siab rau yam tseem ceeb no rau hauv tus account thiab qhia qhov muaj nuj nqis kom raug. Yog tias koj tab tom siv daim ntawv thov laus, thaum cov qauv hloov pauv, cov nqi yuav hloov dhau qhov tsis paub, vim tias koj tau txais cov lej uas txawv ntawm qhov ib txwm muaj.
