Ua ntej koj sau ib daim ntawv ua tiav los ntawm txhua qhov kev pabcuam, nws yuav tsum tau saib ua ntej saib nws yuav sau licas. Tom qab tag nrho, nws muaj peev xwm hais tias ib feem ntawm nws tsis poob mus rau hauv cheeb tsam print los yog tshwm tawm incorrectly. Rau cov hom phiaj hauv Excel muaj xws li lub cuab tam tam li kev saib ua ntej. Cia peb xav paub seb yuav mus rau qhov twg, thiab yuav ua li cas nrog nws.
Saib kuj: Saib ua ntej hauv MS Word
Siv cov kev saib ua ntej
Qhov tseem ceeb ntawm txoj kev saib ua ntej yog tias hauv nws qhov rai daim ntawv yuav muab tso tawm tib yam li tom qab luam ntawv, nrog rau kev pagination. Yog tias qhov koj pom tsis txaus siab rau tus neeg siv, koj tuaj yeem hloov kho Excel lub workbook.
Xav txog kev ua hauj lwm nrog kev saib ua ntej ntawm qhov piv txwv ntawm Excel 2010. Tom qab lub sijhawm ntawm qhov kev pabcuam no muaj cov tswvyim zoo sib xws rau kev ua haujlwm ntawm qhov cuab yeej no.
Mus rau thaj chaw saib ua ntej
Ua ntej tshaj, cia peb xav paub seb yuav nkag mus rau hauv thaj chaw saib ua ntej.
- Thaum nyob rau hauv qhib Excel workbook window, mus rau lub tab "Cov Ntaub Ntawv".
- Tom qab, txav mus rau seem "Sau".
- Ntawm sab xis ntawm lub qhov rais qhib, yuav muaj thaj tsam saib ua ntej uas daim ntawv teev lus hauv daim ntawv uas nws yuav tshwm sim rau sau.
Koj tseem tuaj yeem hloov tau cov kev ua no nrog rau kev sib txuam nrog kev kub siab. Ctrl + F2.
Mus saib ua ntej nyob rau hauv cov ntawv qub
Tab sis nyob rau hauv versions ntawm daim ntawv thov ntxov nyob rau hauv Excel 2010, tsiv mus rau seem saib ua ntej yog me ntsis sib txawv tshaj nyob rau hauv niaj hnub counterparts. Cia peb qhia luv luv rau algorithm kom qhib qhov chaw saib ua ntej rau cov rooj plaub no.
Mus rau hauv lub qhov rais saib ua ntej hauv Excel 2007, ua raws li cov kauj ruam nram no:
- Nias ntawm lub logo Microsoft Office nyob rau sab qaum teb sab laug ntawm txoj kev khiav haujlwm.
- Hauv daim ntawv qhia zaub mov, txav tus cursor rau yam khoom ntawd "Sau".
- Ib daim ntawv ntxiv ntawm cov yeeb yam yuav qhib rau lub block ntawm sab xis. Hauv nws, koj yuav tsum xaiv qhov khoom "Saib ua ntej".
- Tom qab ntawd, nyob rau hauv ib qho cais tab opens lub qhov rais saib ua ntej. Qhov kaw nws, nias lub pob liab liab khawm loj. "Kaw qhov muag saib qhov rai".
Lub algorithm rau kev hloov mus rau lub qhov rais saib ua ntej hauv Excel 2003 yog txawm ntau los ntawm Excel 2010 thiab tom qab versions. Txawm hais tias nws yog yooj yim.
- Nyob rau hauv cov ntawv qhia kab rov tav ntawm qhov kev pab cuam qhib qhov rai, nyem qhov khoom "Cov Ntaub Ntawv".
- Nyob rau hauv cov npe uas tau qhib, xaiv qhov khoom "Saib ua ntej".
- Tom qab ntawd, qhib qhov rai yuav qhib.
Saib ua Ntej
Hauv cheeb tsam saib ua ntej, koj tuaj yeem hloov cov ntaub ntawv saib ua ntej. Qhov no yuav ua tau raws li siv ob lub khawm nyob rau hauv sab qis txoj cai ntawm lub qhov rais.
- Thaum koj nias lub pob tshuav "Qhia Tshaj" daim ntawv qhia cov lus teev tseg.
- Hovering tus cursor dua lub teb yam, thiab tuav cov laug nas khawm, yog tias tsim nyog, koj tuaj yeem nce lossis txo nws cov ciam teb, tsuas yog tsiv lawv, ua li cas editing phau ntawv rau luam ntawv.
- Txhawm rau tso saib cov lus teb, cia li nyem dua rau tib lub khawm uas ua rau lawv pom.
- Txoj kev cai saib ua ntej khawm - "Fit rau phab". Tom qab txhaj rau nws, nplooj ntawv tau txais qhov ntev ntawm thaj chaw saib ua ntej uas nws yuav tau sau.
- Yuav lov tes taw hom no, cia li nias lub pob dua tib dua.
Daim Ntawv Txheeb Xyuas
Yog tias cov ntaub ntawv muaj ob peb nplooj ntawv, tom qab ntawd ces yog lub hauv paus, tsuas yog thawj zaug ntawm lawv pom tam sim ntawd hauv qhov kev saib ua ntej. Tus lej nplooj ntawv tam sim no yog hauv qab ntawm thaj chaw saib ua ntej, thiab tag nrho cov nplooj ntawv nyob hauv phau Excel workbook rau ntawm sab xis ntawm nws.
- Txhawm rau saib cov nplooj ntawv xav tau hauv cheeb tsam ua ntej, koj yuav tsum nkag mus rau hauv nws lub xov tooj los ntawm cov keyboard thiab nias lub khawm ENTER.
- Mus rau nplooj ntawv tom ntej koj yuav tau nyem rau ntawm daim duab peb sab, angled rau sab xis, uas nyob rau ntawm sab xis ntawm nplooj ntawv.
Tawm mus rau phab dhau los, nias ntawm daim duab peb sab rau sab laug, uas nyob rau sab laug ntawm nplooj ntawv.
- Txhawm rau saib cov phau ntawv ua ke, koj tuaj yeem tso tus cursor rau ntawm qhov chaw khawm ntawm qhov kawg, khawm khawm nas khawm thiab cab tus cursor cia kom txog thaum koj saib daim ntawv raws li tag nrho. Ntxiv mus, koj tuaj yeem siv lub khawm nyob hauv qab no. Nws nyob hauv qab ntawm qhov scroll bar thiab yog daim duab peb sab coj mus downward. Txhua lub sij hawm koj nias ntawm daim ntawv no nrog lub mouse nas khawm, cov nplooj ntawv yuav raug muab hloov mus rau ib nplooj.
- Ib yam li ntawd, koj tuaj yeem pib mus rau qhov pib ntawm daim ntawv, tiamsis ua qhov no, yog rub tau qhov khawm nqes lossis nias ntawm lub cim nyob rau hauv daim ntawv ntawm ib daim duab peb sab taw, uas nyob rau saum lub bar.
- Tsis tas li ntawd, koj tuaj yeem mus rau nplooj ntawv ntawm cov ntaub ntawv hauv cheeb tsam saib ua ntej, siv cov keyboard navigation yuam sij:
- Pem xub - tsiv ib nplooj ntawv txog daim ntawv;
- Cia li xub - tshem cov nplooj ntawv hauv daim ntawv;
- Xaus - tsiv mus rau qhov kawg ntawm daim ntawv;
- Tsev - mus rau qhov pib ntawm daim ntawv.
Txhim kho phau ntawv
Yog hais tias thaum lub sij hawm tus txheej txheem saib ua ntej koj tau teev nyob rau hauv daim ntawv txhua yam tsis muaj tseeb, yuam kev lossis koj tsis txaus siab rau tus tsim, ces yuav tsum ua tus Excel workbook. Yog tias koj xav kom kho cov ntsiab lus ntawm daim ntawv nws tus kheej, uas yog, cov ntaub ntawv nws muaj, ces koj yuav tsum rov qab mus rau lub tab "Tsev" thiab ua qhov tsim nyog yuav tau kho.
Yog tias koj tsuas xav hloov cov ntaub ntawv ntawm daim ntawv luam tawm, ces qhov no tuaj yeem ua rau hauv lub block "Teeb" seem "Sau"uas yog nyob rau sab laug ntawm thaj chaw saib ua ntej. Ntawm no koj tuaj yeem hloov qhov kev qhia ntawm nplooj ntawv los yog kev nplua nuj, yog tias nws tsis haum rau ib daim ntawv luam, kho cov paj zoo, faib cov ntawv ntawm cov ntawv luam, xaiv cov ntawv loj thiab ua lwm yam yeeb yam. Tom qab tsim nyog kho cov kev tswj kev ua tiav, koj tuaj yeem xa daim ntawv tuaj luam tawm.
Tshooj: Yuav ua li cas luam ib daim ntawv hauv Excel
Raws li koj tau pom, nrog kev pab los ntawm cov cuab yeej saib ua ntej hauv Excel koj tuaj yeem pom tias nws yuav zoo li cas thaum luam tawm ua ntej luam cov ntaub ntawv mus rau lub tshuab luam ntawv. Yog tias qhov tshwm sim tau tsis sib thooj tag nrho tus neeg siv xav tau txais, nws tuaj yeem hloov phau ntawv thiab xa nws mus luam tawm. Yog li, lub sijhawm thiab khoom siv rau kev luam ntawv (toner, paper, thiab lwm yam) yuav raug muab los piv rau yog tias koj yuav tsum luam tawm tib daim ntawv ob peb zaug, yog tias koj tsis tuaj yeem pom nws ua li cas luam tawm ntawm saib kev tshuaj ntsuam.
