Excel lub phab ntawv hom teeb meem yog ib qho cuab yeej zoo uas koj tuaj yeem pom sai npaum li cas cov ntsiab lus yuav los saib rau nplooj ntawv raws li lawv tau luam tawm thiab kho lawv tam sim ntawd. Tsis tas li ntawd, nyob rau hauv hom no, koj tuaj yeem saib cov headers thiab footers - sau ntawv tshwj xeeb rau saum toj thiab hauv qab ntawm cov nplooj ntawv uas tsis pom nyob rau hauv ib txwm ua haujlwm. Tab sis, tag nrho cov tib yam, tsis yog ib txwm ua hauj lwm nyob rau hauv xws li tej yam kev mob rau tag nrho cov neeg siv yog tseem ceeb. Ntxiv mus, tom qab tus neeg siv nkag mus rau kev lag luam, nws yuav pom tias txawm tias tom qab ntawd cov kab uas cim rau sab ciam teb yuav nyob pom.
Tshem tawm cim npe
Cia peb kawm seb yuav ua li cas thiaj li tua tau cov nplooj ntawv tawm hauv tsev thiab tshem tawm ntawm kev kos duab ntawm ciam teb rau ntawm daim ntawv.
Txoj kev cai 1: lov tes taw cov nplooj ntawv cim npe nyob hauv tus txheej xwm
Qhov yoojyim txoj kev tawm ntawm phab ntawv layout hom yog hloov nws ntawm lub icon nyob rau hauv txheej xwm bar.
Peb khawm nyob rau hauv daim ntawv ntawm cov icons hloov tus saib hom muaj nyob rau sab xis ntawm tus txheej xwm bar mus rau sab laug ntawm zoom slider. Siv lawv, koj tuaj yeem kho cov txheej txheem hauv qab no:
- zoo tib yam;
- nplooj ntawv;
- phab layout.
Hauv ob hom dhau los, daim ntawv no faib ua feem. Tshem tawm qhov kev faib no, nias ntawm qhov icon. "Zoo". Lub hom hloov.
Hom no zoo vim nws tuaj yeem siv rau ib qho nias, nyob rau hauv tab ntawm qhov kev zov me nyuam.
Txoj kev 2: Saib tab
Koj tuaj yeem hloov kev khiav hauj lwm hom hauv Excel los ntawm cov nyees khawm ntawm txoj cai hauv qhov tab "Saib".
- Mus rau lub tab "Saib". Rau daim kab xev hauv lub nras cov cuab yeej "Cov Ntawv Pom Saib Phau Ntawv" nyem rau ntawm lub pob "Zoo".
- Tom qab ntawd, qhov kev zov me nyuam yuav raug hloov los ntawm cov hauj lwm ntawm kev ua hauj lwm hauv kev kos cim rau qhov qub.
Qhov no, tsis zoo li yav dhau los, yuav ntxiv kev tswj nrog kev hloov mus rau lwm tab, tab sis, txawm li ntawd los, qee cov neeg siv xav siv nws.
Method 3: Tshem tawm cov kab ntawv dotted
Tab sis, txawm hais tias koj hloov los ntawm nplooj ntawv los yog phab teeb layout mus rau qhov qub, txoj kab ntawm dashes luv kawg, rhuav cov ntawv rau hauv qhov chaw, yuav tseem nyob twj ywm. Ntawm qhov one hand, nws yuav pab txhim kho seb cov ntaub ntawv puas haum rau hauv cov ntawv luam tawm. Ntawm qhov kev tes, tsis yog txhua leej txhua tus yuav nyiam daim ntawv no, nws muaj peev xwm cuam tshuam nws. Tsis tas li ntawd, tsis yog txhua daim ntawv uas tau npaj tshwj xeeb rau kev luam, uas txhais tau tias qhov kev ua haujlwm no tsuas yog siv tsis tau.
Tam sim ntawd nws yuav tsum tau muab sau tseg tias tsuas yog txoj kev yooj yim kom tshem tau cov kab no luv luv yog rov qab pib dua cov ntaub ntawv.
- Ua ntej yuav kaw lub qhov rais, tsis txhob hnov qab txuag cov kev tshwm sim ntawm kev hloov los ntawm cov cim hauv daim ntawv ntawm lub diskette nyob rau sab laug sab sauv.
- Tom qab ntawd, nyem rau ntawm daim duab nyob rau hauv daim ntawv ntawm ib tug dawb hla inscribed nyob rau hauv ib tug liab square nyob rau hauv lub ces kaum sab xis ntawm lub qhov rais, uas yog, nias ntawm tus qauv ze khawm. Nws tsis tas yuav kaw tag nrho cov qhov rais Excel yog tias koj muaj ob peb cov ntaub ntawv uas khiav tib lub sijhawm, raws li nws txaus los ua txoj hauj lwm hauv cov ntaub ntawv tshwj xeeb uas muaj cov kab uas twb muaj lawm.
- Daim ntawv yuav raug kaw, thiab thaum twg nws tau rov qab pib lawm, yuav tsis muaj cov kab luv luv uas ua rau daim ntawv txiav.
Txoj kev 4: Tshem tawm Kev Tawm
Tsis tas li ntawd, cov ntawv Excel kuj tuaj yeem dai nrog cov kab das ntev. Cov cim no yog hu ua nplooj ntawv so. Nws tsuas yog enabled manually, thiaj li lov tes taw nws koj yuav tsum tau ua ib co manipulations nyob rau hauv qhov kev pab cuam. Xws li khoob muaj xws li yog tias koj xav sau cov seem ntawm daim ntawv cais tawm ntawm lub cev. Tab sis, tsis tas li ntawd, yuav tsum tsis txhob muaj txhua lub sijhawm, dhau li ntawm, qhov no yuav ua rau tsis muaj kev tsis txaus siab, thiab tsis zoo li cov nplooj ntawv teev lus yooj yim, tsuas pom ntawm qhov kev tshuaj ntsuam xwb, cov khoob no yuav ua rau cov ntaub ntawv sib nrug thaum tawm, uas feem ntau yog tsis tsim nyog . Tom qab ntawd nws ua ntau yam rau lov tes taw no feature.
- Mus rau lub tab "Markup". Rau daim kab xev hauv lub nras cov cuab yeej "Nplooj Nplooj" nyem rau ntawm lub pob "So". Lub tshuab raj xa ntawv qhib opens. Mus dhau qhov khoom "Rov pib dua so". Yog tias koj nyem qhov khoom "Tshem tawm daim ntawv so", tsuas muaj ib lub caij yuav muab deleted, thiab tag nrho lwm cov neeg yuav nyob hauv daim ntawv.
- Tom qab qhov no, gaps nyob rau hauv daim ntawv ntawm ntev dashed kab yuav tau muab tshem tawm. Tab sis yuav muaj cov kab kos me me. Lawv, yog tias koj xav tias nws tsim nyog, yuav raug tshem tawm, raws li tau piav qhia nyob rau yav dhau los.
Raws li koj tau pom, disabling lub phab layout hom yog yooj yim heev. Ua li no, koj tsuas yog ua kom muaj qhov hloov los ntawm txhaj qhov khawm tsim nyog rau hauv qhov kev pab cuam interface. Yuav kom tshem tawm cov ntawv sau tseg, yog tias nws cuam tshuam nrog tus neeg siv, koj yuav tsum pib dua qhov program. Tshem tawm hauv cov kab uas muaj kab ntev ntev tau muab los ntawm khawm rau ntawm daim kab xev. Yog li, nws muaj ib qho kev cais cais tawm rau txhua qhov sib txawv ntawm qhov kev sau cim.
