Thaum manually nkag mus rau cov ntaub ntawv lossis luam lawv los ntawm lwm qhov chaw, cov phau ntawv khoos phis tawj Microsoft Office Excel ntawm nws tus kheej txiav txim siab cov hom ntawv - ntawv nyeem, lej, hnub. Nws tsis ib txwm tswj los ua nws kom raug, thiab qee zaum tus neeg siv nws tus kheej yuav tsum ua yuam kev ntawm qhov kev zov me nyuam thiab hloov hom ntawv ntawm cov pab pawg ntawm lub hlwb. Muaj ob peb txoj hauv kev los ua, piv txwv li cov ntawv sau ua lej hauv Excel.
Nws yog qhov tsim nyog
Tabular editor Microsoft Office Excel 2007 lossis 2010
Cov Lus Qhia
Kauj ruam 1
Pib Excel, thauj cov ntawv xav tau rau hauv nws, thiab xaiv cov hlwb koj xav ua hom ntawv. Feem ntau, qhov kev ua haujlwm no yuav tsum tau siv rau cov kab ntawm ib kab lossis kab, kom xaiv qhov nws tau txaus los nyem lub taub hau ntawm kab rov tav lossis kab ntsug no.
Kauj ruam 2
Hauv "Tus naj npawb" cov pab pawg ntawm cov lus txib rau ntawm "Lub Tsev" tab, qhib lub ntsiab lus tswj hwm saum toj kawg nkaus - daim ntawv teev xa khoom. Scroll cia cov npe ntawm hom ntawv thiab xaiv kab ntawv sau tshwj xeeb - "Ntawv" - thiab cov hom ntawv xaiv pawg ntawm cov hlwb yuav hloov.
Kauj ruam 3
Ib yam yuav ua tau hauv lwm txoj kev. Tom qab xaiv qhov chaw yam xav tau, txoj nyem rau nws thiab xaiv kab "Format cells" hauv kab ntawv pop-up cov zaub mov. Excel yuav qheb dua cov qhov xaiv qhov siab nyob ntawm tus Naj Npawb Naj Npawb. Hauv cov ntawv "Number Formats", xaiv kab "Ntawv" thiab nyem OK.
Kauj ruam 4
Koj kuj tseem tuaj yeem siv "Cov Ntawv" ua haujlwm ua rau hauv cov ntawv sau hloov kho - qhov no yooj yim yog tias koj xav tau hloov hom ntawv hauv cais cov hlwb xaiv, lossis cov ntawv nyeem yuav tsum yog ib feem ntawm qee cov qauv, lossis koj yuav tsum ua cov ntawv sib txuas ua kom muaj nuj nqis. los ntawm ntau lub hlwb, thiab lwm yam. Hauv rooj plaub yooj yim, pib ua raws li hauv qab no: pib los ntawm qhov tseem ceeb hauv xov tooj ntawm tes uas koj xav tau los ua kom pom tus lej ntawm cov nqi hauv cov ntawv sau. Tom qab ntawv, ntawm daim Formulas, hauv Function Library Cov lus txib pab pawg, nthuav cov Ntawv Sau thiab xaiv TEXT.
Kauj ruam 5
Hauv thaj chaw "Tus nqi" ntawm lub pib ua haujlwm tsim cov txheej txheem, qhia qhov chaw nyob ntawm tus hloov pauv ntawm tes - ntaus nws los ntawm cov keyboard lossis nyem lub cell nrog nas. Hauv kab ntawv Format, nkag mus rau ib daim npog ntsej muag. Piv txwv li, yog tias koj tso 0 rau hauv daim teb no, yuav tsis muaj qhov chaw decimal hauv tus lej kawg, txawm tias lawv yuav nyob hauv thawj lub xov tooj. Daim npog qhov ncauj 0, 0 sib raug nrog tus naj npawb nrog ib qhov chaw muaj zauv, npog ntsej muag 0, 00 - nrog ob, thiab lwm yam. Cov cai no tau siv yog tias lub chaw rau sau raws li cov lej cais hauv cov lej Excel. Nrog rau cov chaw no, yog tias koj nkag mus rau hauv daim npog xws li 0.0 hauv daim teb no, Excel yuav faib tus lej qub los ntawm 10 ua ntej hloov nws hom. Nrog lub npog ntsej muag ntawm 0.00, tus lej yuav raug muab faib los ntawm 100, thiab lwm yam.
Kauj Ruam 6
Nyem OK hauv qhov New Formula Wizard dialog box, thiab lub cell qhia cov ntawv sau sib npaug ntawm thawj tus lej hom ntawv tus nqi.
