Thaum ua hauj lwm hauv Excel, qee cov ntawv ncav cuag ib qho loj me me. Qhov no ua rau lub fact tias qhov luaj li cas ntawm cov ntaub ntawv tsub kom, qee zaus ncav cuag txawm tias lub teb chaws megabytes lossis ntau dua. Ib qho kev nce hauv qhov nyhav ntawm phau ntawv Excel ua rau tsis nce rau qhov nyiaj ntawm qhov chaw nws nyob rau ntawm daim hard disk, tab sis, qhov tseem ceeb dua, rau kev khiav ceev ntawm kev ua tiav ntau yam thiab cov txheej txheem hauv nws. Tsuas pub, thaum koj ua hauj lwm nrog tej ntaub ntawv, Excel pib qeeb. Yog li ntawd, qhov teeb meem ntawm qhov zoo thiab txo qhov loj ntawm xws li cov phau ntawv ua ceev. Cia saib seb koj yuav ua licas thiaj li txo tau cov ntaub ntawv hauv Excel.
Cov txheej txheem rau kev txo qhov loj ntawm phau ntawv
Optimize cov ntaub ntawv muab ua kom tiav yuav tsum muaj ntau yam lus qhia ib zaug. Ntau tus neeg tsis paub, tab sis feem ntau ntawm Excel cov ntawv muaj ntau yam tsis tseem ceeb. Thaum twg cov ntaub ntawv me me, tsis muaj leej twg them nyiaj tshwj xeeb rau nws, tab sis yog tias daim ntawv ua cumbersome, koj yuav tsum optimize nws nrog txhua yam tsis tau.
Txoj kev cai 1: txo cov haujlwm ua haujlwm
Qhov ua hauj lwm ntau yog thaj tsam uas Excel nco txog cov kev ua. Thaum recalculating ib daim ntawv, qhov kev zov me nyuam rov ntsuas cov hlwb txhua lub chaw ua haujlwm. Tab sis nws tsis tas sib haum mus rau ntau yam nyob rau hauv uas tus neeg siv yeej ua haujlwm. Piv txwv, ib qho chaw tsis muaj teeb meem nyob hauv qab lub rooj yuav nthuav dav qhov kev ua hauj lwm ntau rau lub caij uas qhov chaw no nyob. Nws hloov tawm tias thaum recalculated, Excel yuav ua ib txheej ntawm cov hlwb tas txhua lub sijhawm. Wb pom li cas koj tuaj yeem txhim kho qhov teeb meem no los ntawm qhov piv txwv ntawm ib lub rooj.
- Ua ntej, ua tibzoo saib nws qhov hnyav ua ntej qhov ua kom zoo, los sib piv nws yuav ua licas tomqab tus txheej txheem. Qhov no yuav ua tau los ntawm kev hloov mus rau lub tab "Cov Ntaub Ntawv". Mus rau seem "Cov ntsiab lus". Nyob rau sab xis ntawm lub qhov rais qhib lub ntsiab ntawm phau ntawv raug qhia. Thawj cov khoom ntawm cov khoom yog qhov loj ntawm daim ntawv. Raws li koj tau pom, nyob rau hauv peb cov ntaub ntawv nws yog 56,5 kilobytes.
- Ua ntej tshaj, koj yuav tsum paub seb qhov chaw ua haujlwm tiag tiag ntawm daim ntawv txawv ntawm ib qho uas tus neeg siv xav tau tiag tiag. Qhov no zoo nkauj ua tau yooj yim. Peb ua nyob rau hauv txhua lub xov tooj ntawm lub rooj thiab ntaus lub ntsiab ua ke Ctrl + kawg. Excel tam sim ntawd txav mus rau lub xeem lub xov tooj, uas qhov kev zov me nyuam pom raws li lub caij kawg ntawm qhov chaw ua haujlwm. Raws li koj tuaj yeem pom, hauv peb cov ntaub ntawv tshwj xeeb, qhov no yog kab 913383. Muab cov lus qhia ua tau los ua ntej rau kab thawj zaug, nws tuaj yeem hais tias cov kab 913377 yog, qhov tseeb, kev siv nyiaj tsis muaj txiaj, uas tsis tsuas yog nce cov ntaub ntawv loj, tab sis, Tawm rov qab ntsuas ntawm tag nrho ntau qhov kev zov me nyuam thaum ua yeeb yam, ua rau kev qaug zog hauv txoj haujlwm.
Tau kawg, qhov tseeb, xws li ib qho kev sib txawv loj ntawm qhov kev ua hauj lwm ntau thiab tus Excel siv rau nws yog qhov tsawg kawg, thiab peb tau siv ntau txoj kab rau kev pom tseeb. Txawm hais tias, qee lub sij hawm kuj muaj cov rooj sib hais thaum tag nrho cheeb tsam ntawm ib daim ntawv yog qhov chaw ua haujlwm.
- Yuav kom kho qhov teeb meem no, koj yuav tsum rho tag nrho cov kab, pib ntawm thawj khoob thiab mus kawg ntawm daim ntawv. Ua li no, xaiv thawj lub xovtooj ntawm, uas nyob rau hauv qab lub rooj zaum, thiab ntaus lub ntsiab ua ke Ctrl + Ua haujlwm + Nqes.
- Raws li koj tau pom, tom qab ntawd, tag nrho cov ntsiab lus ntawm thawj kem tau raug xaiv, pib ntawm lub xov tooj ntawm tes thiab mus rau thaum xaus ntawm lub rooj. Ces nias rau cov ntsiab lus uas muaj cai nas khawm. Hauv cov ntawv teb qhib lub ntsiab lus, xaiv qhov khoom "Rho tawm".
Ntau tus neeg siv sim rho tawm los ntawm txhaj khawm. Rho tawm ntawm cov keyboard, tab sis qhov no tsis yog lawm. Qhov kev txiav txim no yuav ua rau tus txheem ntawm lub hlwb tshem tawm, tab sis tsis rho tawm lawv tus kheej. Yog li ntawd, nyob rau hauv peb cov ntaub ntawv nws yuav tsis pab.
- Tom qab peb xaiv qhov khoom "Rho tawm ..." nyob rau hauv lub ntsiab lus teb cov ntawv qhia, qhib qhov rais tshem me me ntawm qhov rais. Peb muab tso rau hauv nws qhov kev hloov mus rau txoj haujlwm "Txoj hlua" thiab nyem rau ntawm lub pob "OK".
- Tag nrho cov kab ntawm kev xaiv tau raug tshem tawm. Nco ntsoov resave phau ntawv los txhaj rau lub cim icon hauv lub ces kaum sab laug ntawm lub qhov rais.
- Tam sim no cia saib seb nws pab peb li cas. Xaiv ib lub xov tooj ntawm tes thiab sau cov ntawv me me Ctrl + kawg. Raws li koj pom, Excel xaiv lub xeem lub xov tooj ntawm lub rooj, uas txhais tau hais tias nws yog tam sim no lub xeem caij ntawm lub ntshoo ntawm daim ntawv.
- Tam sim no peb tsiv mus rau seem "Cov ntsiab lus" tabs "Cov Ntaub Ntawv"kom paub seb qhov nyhav npaum li cas ntawm peb daim ntawv tau raug txo. Raws li koj tau pom, nws yog tam sim no 32,5 KB. Nco qab tias ua ntej txoj kev kho kom zoo, nws loj npaum li cas yog 56.5 KB. Yog li, nws tau txo los ntawm ntau tshaj 1.7 lub sij hawm. Tab sis qhov no, qhov kev ua tau zoo tshaj plaws yog tsis yog qhov txo ntawm cov ntaub ntawv, tab sis qhov tseeb tias qhov kev pab cuam yog tam sim no zam los ntawm recounting cov tsis siv ntau yam, uas yuav ua rau kom qhov ceev ntawm kev ua daim ntawv.
Yog tias phau ntawv muaj ntau ntau cov nplooj ntawv uas koj ua haujlwm nrog, koj yuav tsum tau ua kom zoo ib yam nkaus nrog txhua tus ntawm lawv. Qhov no yuav ntxiv txo qhov luaj li cas ntawm daim ntawv.
Txoj kev 2: tshem tawm cov lus teb rov qab dua
Ib qho tseem ceeb uas ua rau Excel ntaub ntawv hnyav dua yog rov ua dua daim ntawv no. Qhov no kuj muaj xws li siv ntau hom xim, ciam teb, tawm tswv yim, tab sis ua ntej ntawm txhua yam nws txhawj txog kev sau cov hlwb uas txawv xim. Yog li ua ntej koj muab cov ntaub ntawv, koj yuav tsum xav ob zaug, thiab seb nws puas tsim nyog nws ua nws los yog tsis muaj tus txheej txheem no, koj tuaj yeem ua tau yooj yim.
Qhov no yog qhov tseeb tshwj xeeb ntawm cov phau ntawv uas muaj ntau ntau cov ntaub ntawv, uas lawv tus kheej twb muaj qhov loj me me. Ntxiv cov kev ua kom haum rau phau ntawv tuaj yeem ua rau nws qhov hnyav dua ob peb zaug. Yog li, nws yuav tsum xaiv qhov "Golden txhais" ntawm qhov pom tau ntawm cov ntaub ntawv qhia hauv cov ntaub ntawv thiab cov ntaub ntawv loj, siv qhov formatting tsuas yog qhov twg nws yeej tsim nyog.
Lwm qhov tseem ceeb muaj feem xyuam rau cov formatting, hnyav hnyav, yog tias qee cov neeg siv xav muab lub zauv lub hlwb "nrog ib tug paj tau paj." Uas yog, lawv cov hom tsis tsuas yog lub rooj nws tus kheej, tab sis kuj qhov ntau uas yog nyob hauv nws, qee zaum txawm mus rau thaum xaus rau ntawm daim ntawv, nrog lub expectation tias thaum tshiab kab ntxiv rau lub rooj, nws yuav tsis tsim nyog rau lawv dua txhua zaus.
Tab sis nws tsis paub tias thaum twg cov kab tshiab yuav muab ntxiv thiab pes tsawg yuav muab ntxiv, thiab nrog rau qhov ua ntej hom ntawv no koj yuav ua rau cov ntaub ntawv txawm tias tam sim no, uas yuav muaj qhov tsis zoo ntawm kev ua haujlwm nrog daim ntawv no. Yog li ntawd, yog tias koj tau ua ntawv thov kom muab cov ntawv tawm rau cov hlwb uas tsis muaj nyob hauv lub rooj, ces koj yuav tsum tshem tawm nws.
- Ua ntej tshaj, koj yuav tsum xaiv tag nrho cov hlwb uas nyob rau hauv qab cov kab ntawv nrog cov ntaub ntawv. Ua li no, nyem rau ntawm cov kab lus thawj khoob ntawm lub vaj huam sib luag ntawm txoj kab ke. Tag nrho kab yog qhov tseem ceeb. Tom qab ntawd siv qhov kub siab tseem ceeb uas peb twb paub lawm. Ctrl + Ua haujlwm + Nqes.
- Tom qab ntawd, tag nrho cov kab hauv qab hauv qab ntawm ib feem ntawm lub rooj muaj cov ntaub ntawv tseem ceeb. Nyob hauv tab "Tsev" nyem rau ntawm lub cim "Tseeb"uas yog nyob rau ntawm daim kab xev hauv lub nras cov cuab yeej Editing. Ib lub tshuab raj me me opens. Xaiv ib txoj hauj lwm hauv nws "Tshaj tawm".
- Tom qab qhov kev txiav txim hauv txhua lub hlwb ntawm cov xaiv ntau, lub formatting yuav raug tshem tawm.
- Nyob rau hauv tib txoj kev, koj muaj peev xwm tshem tawm tsis tseem ceeb formatting nyob rau hauv lub rooj nws tus kheej. Ua li no, peb xaiv cov tib neeg lub hlwb los sis ib qhov chaw uas peb xav txog kev ua kom hom ntawv siv tau yooj yim, nias ntawm lub pob. "Tseeb" Nyob rau daim kab xev thiab ntawm daim ntawv, xaiv qhov khoom "Tshaj tawm".
- Raws li koj tau pom, qhov formatting hauv xaiv ntau yam ntawm lub rooj tau raug tshem tawm tag nrho.
- Tom qab ntawd, peb rov mus txog qhov no qee tus qauv ntsiab lus uas peb xav tias tsim nyog: ciam teb, hom ntawv zauv, thiab lwm yam.
Cov kauj ruam saum toj saud yuav pab txo qhov luaj li cas ntawm Excel phau ntawv thiab ua kom txoj haujlwm tau zoo dua. Tab sis nws yog qhov zoo dua rau chiv siv lub formatting xwb qhov twg nws yog tiag tiag tsim nyog thiab tsim nyog, tshaj li siv lub sij hawm nyob rau hauv optimizing daim ntawv.
Tshooj: Ua Formating Excel Ntxhuav
Txoj kev 3: rho tawm cov kev sib txuas
Hauv qee cov ntaub ntawv, muaj ntau cov kev sib txuas, los ntawm qhov tseem ceeb yog rub tawm. Qhov no tuaj yeem ua kom qeeb qeeb ntawm kev ua haujlwm ntawm lawv. Sab nraud mus rau lwm phau ntawv qhia tau tias qhov no tseem ceeb heev, txawm hais tias kev sib txuas lus los kuj muaj kev ntxim ntxub rau kev ceev. Yog qhov chaw ntawm qhov txuas uas siv cov ntaub ntawv tsis yog tas li tshiab, uas yog, nws ua rau kev txiav txim siab los hloov cov chaw nyob siv nyob rau hauv lub hlwb nrog qhov tseem ceeb. Qhov no tuaj yeem ua rau qhov ua haujlwm ntawm daim ntawv. Koj tuaj yeem pom tau tias qhov txuas lossis tus nqi yog nyob rau ntawm ib lub xovtooj ntawm tes; koj tuaj yeem nyob rau hauv cov qauv formula tom qab xaiv lub caij.
- Xaiv lub cheeb tsam uas muaj cov kev sib txuas. Nyob hauv tab "Tsev", nyem rau ntawm lub pob "Daim qauv" uas yog nyob rau ntawm txoj hlua nyob rau hauv pawg koom haum "Ntawv Teev Npe".
Xwb, tom qab koj xaiv qhov ntau, koj tuaj yeem siv lub sijhawm ua ke ntawm cov yuam sij kub. Ctrl + C.
- Tom qab peb tau theej cov ntaub ntawv, tsis txhob tshem tawm ntawm cheeb tsam, tab sis nias rau ntawm nws nrog txoj kev nas khawm. Lub ntsiab lus teb lub ntsiab lus yog pib. Nyob rau hauv nws nyob rau hauv lub block "Insertion Options" yuav tsum tau nyem rau ntawm lub icon "Qhov tseem ceeb". Nws zoo li lub pictogram uas muaj cov duab pom.
- Tom qab ntawd, tag nrho cov kev sib txuas hauv cheeb tsam uas raug xaiv yuav raug muab hloov nrog qhov tshwm sim tawm.
Tab sis nws yuav tsum nco ntsoov hais tias qhov kev xaiv no ntawm qhov zoo ntawm ib qho Excel workbook tsis yog ib txwm siv tau. Nws tuaj yeem siv tau thaum cov ntaub ntawv los ntawm qhov chaw yuavtsum tsis yog dynamic, uas yog, lawv tsis hloov nrog lub sijhawm.
Txoj kev 4: kev hloov pauv
Lwm txoj kev los txo cov ntaub ntawv me me yog hloov nws cov hom ntawv. Txoj kev no yuav pab tau ntau dua li lwm tus los luam cov phau ntawv, tab sis cov kev xaiv saum toj no kuj yuav tsum tau siv nrog ua ke.
Nyob rau hauv Excel, muaj ntau ntau hom "hom ntawv" - xls, xlsx, xlsm, xlsb. Lub xls hom yog qhov pib txuas rau qhov program version ntawm Excel 2003 thiab yav dhau los. Nws twb yog outdated, tab sis, cuaj kaum, ntau tus neeg siv tseem tseem ua ntaub ntawv thov. Tsis tas li, muaj qee zaum thaum koj yuav tsum rov qab mus ua haujlwm nrog cov ntaub ntawv qub uas tau tsim ntau xyoo dhau los txawm nyob rau lub sijhawm tsis muaj cov qauv tshiab. Tsis hais qhov tseeb tias ntau qhov kev pabcuam thib peb uas tsis paub yuav ua licas tom qab ntawm Excel cov ntaub ntawv ua haujlwm nrog cov ntawv nrog qhov kev txuas ntxiv no.
Nws yuav tsum tau muab sau tseg tias phau ntawv nrog xls extension muaj ib qhov loj dua qhov nws niaj hnub analogue ntawm xlsx hom, uas Excel tam sim no siv raws li lub ntsiab lus tseem ceeb. Ua ntej tshaj, qhov no yog vim yog qhov tseeb tias xlsx cov ntaub ntawv, qhov tseeb, yog cov ntaub ntawv sau tawm. Yog li, yog hais tias koj siv cov xls extension, tab sis xav kom txo qhov nyhav ntawm phau ntawv, ces qhov no yuav ua tau tsuas yog resaving nws nyob hauv xlsx hom ntawv.
- Hloov ib daim ntawv los ntawm xls hom rau xlsx hom, mus rau lub tab "Cov Ntaub Ntawv".
- Nyob rau hauv lub qhov rais qhib, tam sim ntawd xyuam xim rau hauv seem "Cov ntsiab lus"qhov twg nws yog qhia hais tias tam sim no tus luj ntawm daim ntawv no yog 40 Kb. Tom ntej, nias lub npe "Txuag Raws Li ...".
- Ib qho qhib qhov rais qhib. Yog tias koj xav tau, koj tuaj yeem mus rau ib lub npe tshiab hauv nws, tab sis rau feem ntau cov neeg siv nws yooj yim dua los khaws cov ntaub ntawv tshiab hauv tib qhov chaw raws li lub hauv paus. Lub npe ntawm phau ntawv, yog tias xav tau, tuaj yeem hloov tau nyob rau hauv "Cov Ntaub Ntawv Lub Npe", tab sis tsis tas. Qhov tseem ceeb tshaj plaws nyob rau hauv txoj kev ua no yog muab tso rau hauv qhov chaw "Cov Ntaub Ntawv Siv" lub ntsiab lus "Excel workbook (.xlsx)". Tom qab ntawd, koj tuaj yeem nias lub khawm "OK" nyob hauv qab ntawm qhov rais.
- Tom qab txuag tiav, mus rau seem "Cov ntsiab lus" tabs "Cov Ntaub Ntawv", saib ntau npaum li cas hnyav yog txo. Raws li koj tau pom, nws yog tam sim no 13.5 KB tiv thaiv 40 KB ua ntej txoj kev hloov dua siab tshiab. Ntawd yog, tsuas yog ib qho kev txuag nyob rau hauv ib hom qauv tshiab uas peb tau muab cov phau ntawv yuav luag peb zaug.
Tsis tas li ntawd, hauv Excel muaj lwm hom xlsb hom ntawv tshiab los yog hauv phau ntawv binary. Nyob rau hauv nws, cov ntaub ntawv yog cia rau hauv binary encoding. Cov ntaub ntawv no nyhav txawm tsawg tshaj xlsx phau ntawv. Tsis tas li ntawd, cov lus uas lawv tau sau cia yog nyob ze rau Excel. Yog li, nws ua haujlwm nrog cov ntawv zoo li sai dua nrog rau lwm qhov ntxiv. Nyob rau tib lub sijhawm, phau ntawv ntawm cov hom ntawv teev hais txog kev ua haujlwm thiab kev siv ntau yam cuab yeej (kev hloov, kev ua haujlwm, duab kos, thiab lwm yam) tsis zoo rau xlsx hom ntawv thiab tshaj qhov xls hom ntawv.
Lub ntsiab yog vim li cas xlsb tsis dhau los ua hom haujlwm hauv Excel yog qhov kev pabcuam thib peb cuam tshuam nrog nws. Piv txwv li, yog tias koj xav tau ntaub ntawv tawm los ntawm Excel mus rau qhov kev pab cuam 1C, qhov no yuav ua tau nrog xlsx lossis xls cov ntaub ntawv, tab sis tsis nrog xlsb. Tab sis, yog tias koj tsis npaj muab cov ntaub ntawv xa mus rau lwm qhov kev pabcuam thib peb, ces koj tuaj yeem muaj kev ruaj ntseg rau txuag tau daim ntawv hauv xlsb hom ntawv. Qhov no yuav ua rau koj txo qhov me me ntawm daim ntawv thiab nce kev ceev ntawm kev ua haujlwm hauv nws.
Cov txheej txheem rau txuag tau cov ntaub ntawv hauv xlsb extension yog zoo ib yam li peb tau ua rau xlsx extension. Hauv tab "Cov Ntaub Ntawv" nyem qhov khoom "Txuag Raws Li ...". Nyob rau hauv qhib lub qhov rais qhib tom teb "Cov Ntaub Ntawv Siv" yuav tsum tau xaiv ib qho kev xaiv "Excel binary workbook (* .xlsb)". Ces nyem rau ntawm lub pob. "Txuag".
Peb saib qhov nyhav ntawm daim ntawv hauv tshooj. "Cov ntsiab lus". Raws li koj tau pom, nws tau txo ntau heev thiab tam sim no tsuas yog 11.6 KB.
Ua kom tiav, peb tuaj yeem hais tau tias yog koj ua haujlwm nrog cov ntaub ntawv, txoj kev zoo tshaj los txo qhov nws loj yog rov txuag hauv cov qauv xlsx tshiab lossis xlsb. Yog hais tias koj twb siv cov ntaub ntawv txuas ntxiv, ces kom txo lawv qhov nyhav, koj yuav tsum tau kho qhov khij nyuab, tshem tawm cov ntawv rov qab thiab cov kev tsis tseem ceeb. Koj yuav tau txais qhov khoom loj tshaj yog tias koj ua txhua yam haujlwm no, thiab tsis txwv koj tus kheej rau ib qho kev xaiv.
