Phab ntawv tso npe hom hauv Excel yog qhov yooj yim heev uas koj tuaj yeem pom tam sim ntawd yuav ua li cas cov khoom yuav tshwm rau ntawm nplooj ntawv thaum luam ntawv thiab hloov kho lawv nyob ntawd. Tsis tas li ntawd, nyob hauv hom no, saib ko taw muaj - cov ntawv tshwj xeeb nyob rau sab saud thiab hauv qab ntawm nplooj ntawv uas tsis pom nyob hauv cov hauj lwm ib txwm ua. Tab sis, txawm li cas los xij, deb ntawm ib txwm ua haujlwm nyob rau hauv cov xwm txheej zoo li no cuam tshuam rau txhua tus neeg siv. Ntxiv mus, tom qab tus neeg siv hloov mus rau lub hom qub ntawm kev ua haujlwm, nws yuav pom tias txawm tias tom qab ntawv sau cov kab yuav nyob rau pom uas qhia cov ciam teb ntawm nplooj ntawv.
Rho tawm markup
Cia peb paub yuav ua li cas tawm ntawm nplooj ntawv nplooj ntawv hom thiab tshem ntawm qhov pom kev tsim cov ciam teb ntawm daim ntawv.
Txoj Kev 1: tua cov nplooj ntawv nplooj ntawv hauv qhov xwm txheej
Txoj kev yooj yim tshaj plaws ntawm kev tawm ntawm nplooj ntawv nplooj ntawv hom yog hloov nws ntawm lub icon ntawm qhov xwm txheej.
Peb lub nyees khawm nyob rau hauv daim ntawv ntawm lub cim rau hloov mus rau saib hom yog nyob rau sab xis ntawm txoj cai bar rau sab laug ntawm lub zoom tswj. Siv lawv, koj tuaj yeem tsim cov qauv hauv qab ntawm kev ua haujlwm:
- zoo tib yam;
- nplooj ntawv;
- nplooj ntawv teeb.
Hauv ob hom kawg, daim ntawv faib ua ntu. Txhawm rau tshem tawm qhov kev sib cais no, cia li nias ntawm lub cim "Li Qub"Cov. Cov hom hloov.
Hom no tau zoo nyob rau hauv uas nws tuaj yeem siv rau hauv ib tus nias, ua nyob rau hauv txhua qhov txheej ntawm qhov program.
Txoj Kev 2: Saib Tab
Koj tuaj yeem tuaj yeem hloov hom kev ua haujlwm hauv Excel siv cov nyees khawm ntawm pob xov hauv lub tab "Saib".
- Mus rau hauv lub tab "Saib"Cov. Ntawm txoj hlua rau ntawm pob khawm Phau Ntawv Saib Cov Qauv nyem rau ntawm lub pob "Li Qub".
- Tom qab ntawd, qhov kev zov me nyuam yuav hloov pauv ntawm kev ua haujlwm ntawm kev ua cim hom ua haujlwm.
Cov qauv no, tsis zoo li yav dhau los dhau los, cuam tshuam txog kev siv ntxiv nrog kev hloov mus rau lwm lub tab, tab sis, txawm li cas los xij, qee tus neeg siv nyiam siv nws.
Txoj Kev 3: tshem tawm cov kab nriav kab
Tab sis, txawm hais tias koj hloov los ntawm nplooj ntawv lossis nplooj ntawv txheej hom mus rau ib txwm, cov kab ntawv ploj nrog cov kab luv, rhuav daim ntawv rau hauv cov ntawv, yuav tseem nyob. Ntawm ib txhais tes, nws pab txhawm rau txheeb xyuas seb cov ntsiab lus ntawm cov ntaub ntawv yuav haum rau hauv daim ntawv luam tawm. Ntawm qhov tod tes, tsis yog txhua tus neeg siv yuav nyiam xws li kev faib tawm ntawm daim ntawv; nws tuaj yeem cuam tshuam nws cov xim. Ntxiv mus, tsis yog txhua daim ntawv yuav npaj tshwj xeeb rau kev luam ntawv, uas txhais tau hais tias kev ua haujlwm ntawd dhau los tsis muaj nuj nqis.
Nws yuav tsum raug sau tseg tam sim ntawd tsuas yog txoj hauv kev yooj yim kom tau txais ntawm cov luv luv ntab kab no yog kom rov pib cov ntawv.
- Ua ntej kaw lub qhov rai, tsis txhob hnov qab txuag cov txiaj ntsig ntawm qhov kev hloov pauv los ntawm txhaj rau lub cim nyob rau hauv daim ntawv ntawm daim ntawv diskette nyob rau sab saud.
- Tom qab ntawd, nyem rau ntawm lub cim hauv daim ntawv ntawm daim ntoo khaub lig dawb sau rau hauv plaub fab xim liab nyob rau sab xis ntawm sab xis ntawm lub qhov rais, uas yog, nyem rau ntawm kab txheem khawm. Nws tsis tas yuav kaw tag nrho Excel qhov rais yog tias koj muaj ob peb cov ntaub ntawv ua haujlwm nyob rau tib lub sijhawm, vim nws txaus los ua kom tiav kev ua haujlwm hauv cov ntawv tshwj xeeb ntawd qhov twg kab sau rau ntawd.
- Cov ntaub ntawv yuav raug kaw, thiab thaum koj rov pib ua nws, txoj kab luv ntawm kab ntawv uas rhuav cov ntawv yuav tsis ua.
Txoj Kev 4: tshem tawm cov nplooj ntawv so
Ntxiv rau, ib daim ntawv ua haujlwm Excel tseem tuaj yeem khij nrog cov kab ntawv ntev. Cov markup no yog hu ua nplooj so. Nws tuaj yeem tsuas muab tig tau ntawm manually, yog li yuav tsum lov tes taw nws koj yuav tsum tau ua qee yam kev tswjfwm hauv txoj haujlwm. Cov khoob no muaj nrog yog tias koj xav sau qee qhov ntawm daim ntawv cais tawm ntawm lub cev loj. Tab sis, xws li qhov kev xav tau tsis muaj nyob txhua lub sijhawm, ntxiv rau, qhov haujlwm no tuaj yeem tig los ntawm kev tsis saib xyuas, thiab tsis zoo li cov nplooj ntawv yooj yim, pom tau tsuas yog los ntawm lub vijtsam soj ntsuam, cov khoob no yuav ua rau rhuav daim ntawv sib txawv thaum luam ntawv, uas feem ntau tsis tuaj yeem lees txais. Cov. Tom qab ntawd qhov teeb meem ntawm kev xiam oob qhab cov ntsiab lus no cuam tshuam.
- Mus rau hauv lub tab NpavCov. Ntawm txoj hlua rau ntawm pob khawm Nplooj Ntawv Chaw nyem rau ntawm lub pob TxhawmCov. Ib tug nco cia zaub mov yuav qhib. Mus rau qhov khoom ntawd Rov Pib Nplooj NtawvCov. Yog tias koj nyem rau ntawm qhov khoom "Rho tawm nplooj so", tom qab ntawd tsuas yog ib qho khoom yuav raug muab lwv, thiab txhua tus so yuav nyob ntawm daim ntawv.
- Tom qab ntawd, qhov khoob hauv daim ntawv ntawm cov kab ploj ntev yuav tau muab tshem tawm. Tab sis me me me kab kab ntawm kev kos yuav tshwm sim. Lawv, yog tias koj xav tias nws tsim nyog, tuaj yeem tshem tawm, raws li tau piav qhia hauv cov txheej txheem dhau los.
Raws li koj tuaj yeem pom, disabling nplooj ntawv txheej hom yog qhov yooj yim heev. Txhawm rau ua qhov no, koj tsuas yog yuav tsum hloov pauv los ntawm nias lub pob sib txuas hauv txoj haujlwm interface. Txhawm rau tshem tawm cov ntawv teev cim, yog tias nws cuam tshuam nrog tus neeg siv, koj yuav tsum rov qab ua qhov program. Kev tshem tawm txoj hauv kev hauv daim ntawv ntawm kab nrog kab ntev kab tau ua tau dhau los ntawm lub pob ntawm lub pob tw. Yog li ntawd, txhawm rau tshem tawm txhua yam txawv ntawm teeb meem kev teeb tsa, muaj cov tshuab cais tawm.
