Feem ntau, qhov kawg ntawm kev ua hauj lwm rau ntawm Excel daim ntawv yog sau nws. Yog tias koj xav sau tag nrho cov ntaub ntawv ntawm cov ntaub ntawv mus rau lub tshuab luam ntawv, ces nws yooj yim heev ua qhov no. Tab sis yog koj yuav tsum luam tawm ib qho ntawm cov ntaub ntawv, teeb meem pib nrog qhov txheej txheem no. Cia peb mam li paub txog lub ntsiab ntawm cov txheej txheem no.
Kev qhia ntawm cov nplooj ntawv
Thaum luam nplooj ntawv ntawm ib daim ntawv, koj tuaj yeem kho cheeb tsam ntawm koj cheeb tsam txhua lub sijhawm, los yog koj tuaj yeem ua tau ib zaug thiab khaws cia rau hauv cov ntaub ntawv. Nyob rau hauv rooj plaub thib ob, qhov kev zov me nyuam yuav tau muab tus neeg siv los sau ua raws nraim li cov khoom seem uas nws tau qhia ua ntej. Xav txog ob qho ntawm cov kev xaiv no nyob rau hauv qhov piv txwv ntawm Excel 2010. Txawm hais tias qhov kev siv algorithm tuaj yeem yuav siv mus rau yav tom ntej ntawm qhov kev kawm no.
Txoj kev cai 1: ib zaug ib zaug
Yog tias koj npaj sau ib cheeb tsam ntawm daim ntawv rau lub tshuab luam ntawv ib zaug xwb, ces tsis muaj ib qho teeb meem hauv qhov chaw nyob ruaj khov. Nws yuav txaus kom siv lub sijhawm ib zaug, uas qhov kev pab cuam yuav tsis nco qab.
- Xaiv tus nas nrog sab laug khawm pressed, thaj tsam ntawm daim ntawv uas koj xav sau. Tom qab ntawd mus rau ntawm tab "Cov Ntaub Ntawv".
- Hauv sab laug ntawm lub qhov rais qhib, mus hauv qhov khoom "Sau". Nias ntawm daim teb, uas yog nyob rau hauv cov lus tam sim ntawd "Teeb". Ib daim ntawv teev cov kev xaiv uas xaiv tsis tau qhib:
- Sau cov ntawv khij nquag;
- Sau tag nrho phau ntawv;
- Sau qhov xaiv.
Peb xaiv qhov xaiv kawg, raws li nws tsuas yog haum rau peb cov ntaub ntawv.
- Tom qab ntawd, nyob rau hauv thaj chaw saib ua ntej, tsis yog tag nrho cov nplooj ntawv yuav nyob, tab sis tsuas yog xaiv cov khoom tawg xwb. Tom qab ntawd, ua tus txheej txheem ncaj nraim, nias ntawm lub pob. "Sau".
Tom qab ntawd, lub tshuab luam ntawv yuav luam tawm raws nraim li cov khoom seem uas koj tau xaiv lawm.
Txoj kev 2: Teeb Seem Tej Yam Nres
Tab sis, yog tias koj npaj yuav sau cov ntawv pov thawj ib qho tib si, ces nws ua rau kev txiav txim siab kom muab tso rau hauv thaj chaw mus tas li.
- Xaiv qhov khwv ntawm daim ntawv uas koj yuav ua rau thaj tsam chaw sau. Mus rau lub tab "Nplooj Layout". Ndliv lub khawm "Kev luam tawm"uas muab tso rau ntawm ib kab xev hauv ib pawg ntawm cov cuab yeej "Nplooj Nplooj". Nyob rau hauv lub me me zaub mov uas muaj ob yam khoom, xaiv lub npe "Teeb".
- Tom qab ntawd, cov chaw nyob ruaj khov lawm. Kom xyuas qhov no, mus rau ntawm lub tab dua. "Cov Ntaub Ntawv", thiab mam li txav mus rau seem "Sau". Raws li koj tau pom, hauv qhov kev saib ua ntej lub qhov muag pom tseeb raws cheeb tsam uas peb tau nug.
- Yuav kom luam tau cov ntsiab lus muab rau ntawm qhov tom qab qhib cov ntaub ntawv ntawm lub neej ntawd, peb rov qab mus rau lub tab "Tsev". Yuav kom txuag hloov nias ntawm khawm nyob rau hauv daim ntawv ntawm lub tshuab floppy nyob rau sab laug ntawm sab laug ntawm lub qhov rais.
- Yog tias koj xav tau luam daim ntawv los yog lwm daim ntawv, ces qhov no koj yuav tsum tau tshem tawm thaj tsam chaw ruaj. Nyob hauv tab "Nplooj Layout", nyem rau ntawm txoj hlua ntawm khawm "Sau Cheeb Tsam". Nyob rau hauv daim ntawv teev lus qhib, nias ntawm qhov khoom "Tshem tawm". Tom qab cov kev ua no, cov cheeb tsam ntawm daim ntawv no yuav raug rho tawm, uas yog, cov chaw xa rov qab mus rau lub xeev pheej, xws li tus neeg siv tsis tau hloov dab tsi.
Raws li koj tau pom, nws tsis yog ib qho nyuaj rau koj muab ib qho khoom tshwj xeeb rau kev tso zis rau ib lub tshuab luam ntawv hauv Excel, raws li nws yuav zoo li ib tug neeg tom ntej glance. Tsis tas li ntawd, koj tuaj yeem tsim ib qho chaw nyob ruaj khov, uas qhov kev zov me nyuam yuav muab luam tawm cov khoom. Txhua qhov chaw tau ua nyob rau hauv ib txhia ntawm cov lus teb.
