Hauv Microsoft Office Excel cov ntawv tshaj xo, cov ntaub ntawv xaiv haujlwm tau siv los hloov pauv qhov kev txiav txim ntawm cov kab hauv ib kem. Nws txiav txim siab qhov kev txiav txim nyob rau qhov tseem ceeb tau muab tso rau hauv ib kem los ntawm kev sib piv nrog lwm yam. Txawm li cas los xij, qee zaum nws tsim nyog yuav tsum rov qab qhov kev txiav txim ntawm cov kab, tsis hais tus nqi hauv lub hlwb. Ib txoj hauv kev los ua qhov no yog coj kom zoo dua ntawm cov ua haujlwm hauv Excel.
Tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Koj yuav tsum tau sau qhov chaw nyob ntawm thawj tus thiab thawj tus ntawm kawg hauv kab ntawv kho kom raug rau hauv cov qauv. Yog tias cov lus loj txaus kom haum rau hauv ib lub vijtsam, nqes taub hau thiab sau lossis sau cov kab lej ntawm thawj lub thiab thawj theem hauv thaj chaw flip.
Kauj ruam 2
Xaiv ib kem pub dawb ntawm daim ntawv rau cov ntu pab - nws qhov siab yuav phim rau qhov siab ntawm thawj ncej. Tso kab nkag rau hauv thawj kab ntawm kab ntawv no. Nkag mus rau "Formulas" tab nyob rau hauv daim ntawv teev cov khoos phis tawm thiab nyob rau hauv "Function Library" cov lus txib pab pawg, qhib cov npe "References thiab Arrays" nqis los. Hauv daim ntawv teev cov haujlwm, xaiv kab "OFFSET".
Kauj ruam 3
Hauv thawj daim teb - "Txuas" - ntawm cov lus qhib qhib, ntaus qhov chaw nyob ntawm tus xovtooj kawg ntawm kab ntawv dhau. Tso cov phiajcim nyiaj ua ntej ntawm kab ntawv thiab kem tsim nyob hauv qhov chaw nyob no. Piv txwv li, yog hais tias cov kem xaus rau ntawm tes F63, cov ntaub ntawv yuav tsum zoo li qhov no: $ F $ 63.
Kauj ruam 4
Cov mis no nyob hauv daim teb tom ntej - "Offset_by_lines" - yuav tau ntaus ntaus nws. Ua ntej, luam tawm thiab muab cov haujlwm thiab cov haujlwm ua tiav rau hauv ib daim ntawv hauv Excel: (LINE () - LINE ()) * - 1. Tom qab ntawd, sab hauv kab npoo ntawm txoj kab thib ob () muaj nuj nqi, sau chaw nyob ntawm thawj kab ntawm kab thim rov qab, raws li nyob rau theem yav dhau los, cais cov ntawv thiab cov lej nrog lub cim duas. Piv txwv, yog tias qhov chaw nyob ntawm thawj lub xovtooj yog F25, tag nrho kab yuav tsum zoo li no: (LINE () - LINE ($ F $ 25)) * - 1.
Kauj ruam 5
Hauv daim teb txuas ntxiv ntawm daim foos - "Offset_by_columns" - muab xoom, thiab tawm ntawm cov chaw seem. Nyem OK, thiab tus qauv xov tooj qhia cov ntsiab lus ntawm kab kawg ntawm kem flipped.
Kauj Ruam 6
Tshaj tawm cov mis no hla kem kom txog rau qhov siab ntawm kem flip - cab lub teev dub hauv qab ces kaum ntawm sab xovtooj cia rau kab uas xav tau nrog nas. Yog li ntawd, tag nrho cov ntu pabcuam yuav tau sau rau hauv cov thim rov qab nrog cov nqi ntawm daim tseem.
Kauj Ruam 7
Xaiv thiab luam cov kab ntawm cov kab ntsug no. Tom qab ntawd luag-nias ntawm thawj lub xovtooj ntawm lub hauv paus kab ntawv thiab xaiv "Qhov tseem ceeb" hauv seem "Paste Xaiv" ntawm cov ntawv qhia zaub mov. Qhov no ua tiav txoj haujlwm thiab koj tuaj yeem rho tawm cov kem ntu nrog cov qauv.
