Thaum Microsoft Excel Spreadsheet tau tsim, koj puas tau xav paub tias cov kab me me thiab kab rov tav hu ua dab tsi? Lawv hu ua gridlines, thiab cov kab no ua rau cov ntxhuav thiab cov hlwb. Lawv tsim ib feem tseem ceeb ntawm Excel cov haujlwm yooj yim los ntawm kev cia koj npaj koj cov ntaub ntawv rau hauv kab thiab kab. Gridlines kuj txuag koj los ntawm kev tsim cov ciam teb ntawm tes kom paub tseeb tias koj cov ntaub ntawv nyeem tau yooj yim. Yog vim li cas nws thiaj zoo kom paub ntxiv lossis tshem tawm Excel gridlines.
Dab tsi yog Gridlines thiab Lawv Ua Haujlwm Li Cas?
Feem ntau Excel cov ntawv nthuav qhia tuaj nrog cov kab sib chaws pom raws li qhov teeb tsa. Txawm li cas los xij, koj tuaj yeem tau txais daim ntawv nthuav qhia los ntawm tus neeg ua haujlwm ua haujlwm lossis phooj ywg uas tsis pom cov kab hluav taws xob. Koj tuaj yeem txiav txim siab koj cov ntaub ntawv yuav zoo dua yam tsis muaj kab sib chaws pom los ntawm lwm tus neeg siv. Txawm li cas los xij, ntxiv lossis tshem tawm cov kab hluav taws xob yog ncaj qha thiab tsis siv sijhawm ntau los ua.
Ntau txoj hauv kev sib txawv yuav tso cai rau koj los qhia lossis zais kab sib chaws hauv Excel 2019, Microsoft 365, thiab Excel 2016. Cov no suav nrog kev hloov xim ntawm cov kab sib chaws lawv tus kheej, hloov xim xim ntawm daim ntawv ua haujlwm, zais cov kab sib chaws tshwj xeeb. cov ntxhuav thiab cov hlwb, thiab qhia lossis zais cov kab sib chaws rau tag nrho daim ntawv ua haujlwm.
Hloov cov xim ntawm Excel Gridlines rau tag nrho Cov Ntawv Ua Haujlwm
Txawm hais tias koj xav tau koj cov kab hluav taws xob kom sawv tawm ntau dua lossis koj xav tshem lawv tawm ntawm qhov pom, koj tuaj yeem hloov cov xim kab sib chaws uas yooj yim.
Lub neej ntawd xim ntawm daim phiaj hauv cov ntawv ua haujlwm yog lub teeb grey, tab sis koj tuaj yeem hloov xim rau dawb kom tshem koj cov kab sib chaws. Yog tias koj xav kom lawv pom dua, tsuas yog rov qab mus rau cov ntawv qhia zaub mov thiab xaiv xim tshiab.
-
Nyob rau hauv daim ntawv uas koj xav hloov daim phiaj xim, mus rau File > Options.
Image -
Xaiv Advanced.
Image -
Raws li Display xaiv rau daim ntawv ua haujlwm no pab pawg, siv Gridline xim cov ntawv qhia zaub mov los xaiv cov xim uas xav tau.
Image Tom qab xaiv cov xim uas xav tau, Excel 2016 cov neeg siv yuav tsum xaiv OK kom paub meej tias lawv xaiv.
Hloov cov xim sau kom tshem tawm Excel Gridlines
-
Click Xaiv tag nrho (daim duab peb sab nyob rau sab saum toj sab laug ntawm daim ntawv ua haujlwm) lossis nias Ctrl+A.
Image -
Los ntawm Home tab, xaiv Fill color, ces xaiv qhov kev xaiv dawb. Tag nrho cov kab hluav taws xob yuav raug muab zais ntawm qhov pom.
Image Nyob hauv Microsoft Excel, cov ntawv qhia zaub mov puv xim yog sawv cev los ntawm lub thoob xim icon.
-
Yog tias koj xav rov qab cov kab sib chaws, xaiv tag nrho daim ntawv ua haujlwm thiab xaiv Tsis Saulos ntawm Fill Color menu kom tshem tawm cov sau thiab ua kom cov kab sib chaws pom dua.
Image
Yuav ua li cas nkaum Gridlines rau cov kab tshwj xeeb thiab kab
Tej zaum yuav muaj qee lub sijhawm koj tsuas yog xav kom muaj qee ntu ntawm cov kab hluav taws xob tshem tawm kom pom qhov pom tseeb rau cov neeg saib nws.
- Xaiv pab pawg ntawm cov hlwb uas koj xav tshem tawm cov kab hluav taws xob.
-
Right-click the highlighted cells and select Format Cells. Koj tuaj yeem nias Ctrl+1 kom mus rau cov ntawv qhia zaub mov.
Image -
In the Format Cells dialog box, xaiv lub Border tab.
Image -
Xaiv dawb los ntawm cov ntawv qhia zaub mov xim, tom qab ntawd xaiv Outside thiab Inside hauv Presets pab pawg.
Image - Xaiv OK kom paub meej tias koj xaiv.
Yuav ua li cas tig daim phiaj rau thiab tawm rau tag nrho daim ntawv ua haujlwm
Qee zaus, koj tuaj yeem tau txais daim ntawv nthuav qhia los ntawm ib tus phooj ywg lossis cov npoj yaig uas tau muab cov kab hluav taws xob tshem tawm lossis ua rau pom tsis pom. Muaj ob txoj kev xaiv kom sai thiab yooj yim kho kab sib chaws rau tag nrho daim ntawv nthuav dav.
-
Qhib daim ntawv nthuav qhia nrog cov kab sib faib tawm.
Yog tias koj xav xaiv ntau dua ib daim ntawv ua haujlwm, tuav Ctrlxaiv cov nplooj ntawv cuam tshuam hauv qab ntawm phau ntawv ua haujlwm.
-
Xaiv lub View tab, tom qab ntawd xaiv lub Gridline lub npov kom rov qab tag nrho cov kab sib chaws.
Image -
Xwb, koj tuaj yeem xaiv Page Layout, thiab tom qab ntawd, hauv qab Gridlines, xaiv View.
Image
