txheem
Qee cov neeg siv Excel muaj teeb meem tias daim phiaj ntawm daim ntawv tam sim ntawd ploj mus. Qhov no tsawg kawg zoo li dab tuag, thiab tseem ntxiv ntau qhov tsis yooj yim. Tom qab tag nrho, cov kab no pab txhawm rau txheeb xyuas cov ntsiab lus ntawm lub rooj. Tau kawg, hauv qee qhov xwm txheej nws ua rau kev txiav txim siab tso daim phiaj. Tab sis qhov no tsuas yog pab tau thaum tus neeg siv nws tus kheej xav tau. Tam sim no koj tsis tas yuav kawm tshwj xeeb e-phau ntawv yuav ua li cas los daws qhov teeb meem no. Nyeem rau thiab koj yuav pom tias txhua yam yooj yim dua li qhov zoo li.
Yuav Ua Li Cas Nkaum thiab Restore Daim phiaj ntawm Daim Ntawv Excel Tag Nrho
Cov kev ua ntu zus los ntawm tus neeg siv yuav txawv nyob ntawm qhov version ntawm chav ua haujlwm suite. Ib qho lus piav qhia tseem ceeb: qhov no tsis yog hais txog ciam teb ntawm cov hlwb, tab sis hais txog cov kab siv uas cais cov hlwb thoob plaws hauv daim ntawv.
Excel version 2007-2016
Ua ntej peb nkag siab yuav ua li cas los kho cov kab sib chaws rau tag nrho cov ntawv, peb yuav tsum xub xyuas seb nws tshwm sim li cas nws ploj mus. Ib qho kev xaiv tshwj xeeb ntawm "Saib" tab, uas yog hu ua "Grid", yog lub luag haujlwm rau qhov no. Yog tias koj uncheck cov khoom no, daim phiaj yuav raug muab tshem tawm. Raws li, txhawm rau rov kho cov kab sib chaws, koj yuav tsum kos lub thawv no.
Muaj lwm txoj kev. Koj yuav tsum mus rau Excel chaw. Lawv nyob hauv "Cov Ntaub Ntawv" ntawv qhia zaub mov hauv "Kev xaiv" thaiv. Tom ntej no, qhib "Advanced" ntawv qhia zaub mov, thiab uncheck lub "Show grid" checkbox yog hais tias peb xav mus tua cov zaub ntawm daim phiaj los yog kos nws yog hais tias peb xav rov qab.
Muaj lwm txoj hauv kev los nkaum daim phiaj. Ua li no, koj yuav tsum ua kom nws cov xim dawb los yog tib yam li cov xim ntawm cov hlwb. Tsis yog txoj hauv kev zoo tshaj los ua qhov no, tab sis nws yuav ua haujlwm. Nyob rau hauv lem, yog hais tias cov xim ntawm cov kab twb dawb, ces nws yog tsim nyog los kho nws rau lwm yam uas yuav pom meej meej.
Los ntawm txoj kev, ua tib zoo saib. Nws yog qhov ua tau tias muaj xim sib txawv rau cov ciam teb ntawm kab sib chaws, tsuas yog nws tsis tshua pom zoo vim tias muaj ntau qhov ntxoov ntxoo dawb.
Excel version 2000-2003
Hauv cov laus versions ntawm Excel, zais thiab qhia cov kab sib chaws yog qhov nyuaj dua li cov tshiab versions. Txhawm rau ua qhov no, ua raws cov kauj ruam no:
- Qhib "Kev Pabcuam" zaub mov.
- Mus rau "Chaw".
- Lub qhov rais yuav tshwm nyob rau hauv uas peb yuav tsum qhib lub "Saib" tab.
- Tom ntej no, peb nrhiav ib seem nrog qhov rais tsis, qhov twg peb uncheck lub thawv nyob ib sab ntawm cov khoom "Grid".
Tsis tas li ntawd, ib yam li cov versions tshiab ntawm Excel, tus neeg siv tuaj yeem xaiv dawb los nkaum daim phiaj, lossis dub (lossis txhua yam uas zoo sib xws nrog keeb kwm yav dhau) los qhia nws.
Excel muab lub peev xwm, ntawm lwm yam, los nkaum daim phiaj ntawm ob peb nplooj ntawv lossis hauv tag nrho cov ntaub ntawv. Txhawm rau ua qhov no, koj yuav tsum xub xaiv cov nplooj ntawv tsim nyog, thiab tom qab ntawd ua cov haujlwm tau piav qhia saum toj no. Koj tuaj yeem teeb tsa kab xim rau "Auto" los tso saib daim phiaj.
Yuav ua li cas nkaum thiab rov ua kom pom cov kab sib chaws ntawm tes
Daim phiaj kab yog siv tsis tau tsuas yog los kos cov ciam teb ntawm cov hlwb, tab sis kuj los ua kom cov khoom sib txawv. Piv txwv li, kom nws yooj yim rau txoj hauj lwm daim duab txheeb ze rau lub rooj. Yog li koj tuaj yeem ua tiav cov txiaj ntsig zoo nkauj dua. Hauv Excel, tsis zoo li lwm cov haujlwm hauv chaw ua haujlwm, nws muaj peev xwm luam tawm kab sib chaws. Yog li, koj tuaj yeem hloov kho lawv cov zaub tsis yog ntawm qhov screen nkaus xwb, tab sis kuj tseem luam tawm.
Raws li peb twb paub lawm, kom tso saib kab sib chaws ntawm qhov screen, koj tsuas yog yuav tsum mus rau "Saib" tab thiab kos lub thawv sib txuas.
Raws li, txhawm rau nkaum cov kab no, tsuas yog uncheck lub thawv sib txuas.
Daim phiaj tso saib ntawm qhov ua kom puv
Koj tuaj yeem qhia lossis zais daim phiaj los ntawm kev hloov kho tus nqi Sau Xim. Los ntawm lub neej ntawd, yog tias nws tsis tau teeb tsa, daim phiaj yuav tshwm sim. Tab sis sai li sai tau thaum nws hloov mus rau dawb, daim phiaj ciam teb tau cia li muab zais. Thiab koj tuaj yeem xa lawv rov qab los ntawm kev xaiv cov khoom "Tsis muaj sau".
Daim phiaj luam ntawv
Tab sis koj yuav tsum ua dab tsi los luam cov kab no rau ntawm daim ntawv? Hauv qhov no, koj yuav tsum qhib qhov "Print" xaiv. Txhawm rau ua qhov no, koj yuav tsum ua raws li cov lus qhia hauv qab no:
- Ua ntej, xaiv cov nplooj ntawv uas yuav cuam tshuam los ntawm kev hloov pauv. Koj tuaj yeem pom tias ob peb nplooj ntawv raug xaiv ib zaug los ntawm [Group] cim, uas yuav tshwm sim ntawm nplooj ntawv header. Yog tias mam li nco dheev cov nplooj ntawv raug xaiv tsis raug, koj tuaj yeem thim qhov kev xaiv los ntawm sab laug-nias ntawm ib qho ntawm cov nplooj ntawv uas twb muaj lawm.
- Qhib "Page Layout", uas peb tab tom nrhiav rau pawg "Sheet Options" pawg. Yuav muaj kev sib raug zoo. Nrhiav cov pab pawg "Grid" thiab khij lub npov nyob ib sab ntawm cov khoom "Print".
Feem ntau cov neeg siv ntsib qhov teeb meem no: lawv qhib nplooj ntawv Layout ntawv qhia zaub mov, tab sis cov checkboxes uas yuav tsum tau qhib tsis ua hauj lwm. Hauv cov lus yooj yooj yim, nws tsis tuaj yeem qhib lossis deactivate cov haujlwm sib xws.
Txhawm rau daws qhov no, koj yuav tsum hloov qhov tsom mus rau lwm yam khoom. Yog vim li cas rau qhov teeb meem no yog qhov kev xaiv tam sim no tsis yog ib daim ntawv, tab sis daim duab lossis duab. Tsis tas li ntawd, cov checkboxes tsim nyog tshwm sim yog tias koj tsis xaiv cov khoom no. Tom qab ntawd, peb muab cov ntaub ntawv luam tawm thiab kos. Qhov no tuaj yeem ua tiav siv qhov tseem ceeb ua ke Ctrl + P lossis siv cov khoom noj khoom haus sib thooj "File".
Koj tseem tuaj yeem qhib qhov saib ua ntej thiab saib seb cov kab sib chaws yuav raug luam tawm ua ntej lawv tshwm rau ntawm daim ntawv. Txhawm rau ua qhov no, nias qhov sib xyaw ua ke Ctrl + F2. Nyob ntawd koj tuaj yeem hloov cov hlwb uas yuav luam tawm. Piv txwv li, ib tug neeg yuav xav luam daim phiaj nyob ib ncig ntawm cov hlwb uas tsis muaj qhov tseem ceeb. Hauv qhov xwm txheej zoo li no, qhov chaw nyob tsim nyog yuav tsum tau muab ntxiv rau qhov ntau kom luam tawm.
Tab sis rau qee tus neeg siv, tom qab ua cov kauj ruam no, cov kab sib chaws tseem tsis tshwm sim. Qhov no yog vim hais tias lub hom phiaj yog enabled. Koj yuav tsum qhib lub qhov rais "Page Setup" thiab tshem tawm cov khoom sib txuas ntawm lub tab "Sheet". Yog tias cov kauj ruam no tsis pab, ces qhov laj thawj yuav nyob rau hauv lub tshuab luam ntawv tsav tsheb. Tom qab ntawd txoj kev daws teeb meem zoo yuav yog rau nruab lub Hoobkas tsav tsheb, uas tuaj yeem rub tawm los ntawm lub vev xaib raug cai ntawm cov chaw tsim khoom ntawm cov cuab yeej no. Qhov tseeb yog tias cov tsav tsheb uas lub operating system nruab cia li tsis tas yuav ua haujlwm zoo.