Ho Excel, meeli e mela e kenngoa metseng e ka thōko ea sele kapa sehlopha sa lisele.
Mekhoa ea line e ka sebelisetsoang meeli e kenyelletsa mela e le 'ngoe, e' meli, le ka linako tse ling e robehileng. Boima ba mela e ka fapana ho ea ka 'mala.
Lintlheng li etsa hore ho be le lisebelisoa tse sebelisetsoang ho ntlafatsa ponahalo ea mosebetsi oa hau. Ba ka nolofalletsa ho fumana le ho bala boitsebiso bo tobileng.
Li ka boela tsa sebelisoa ho lebisa tlhokomelo litabeng tsa bohlokoa tse kang liphello tsa litlhaloso .
Ho eketsa mela le meeli ke tsela e potlakileng ea ho ngolisa tlhahisoleseding ea bohlokoa ho Excel.
Litlhaloso tsa li- column , li- data tsa boitsebiso , kapa litlotla tsa bohlokoa le lihlooho li ka etsoa haholoanyane ka ho phaella ha mela le meeli.
Ho eketsa marang-rang Ho sebelisa Shortcut ea Keyboard
Tlhokomeliso: Nako e khutšoanyane e eketsa moeli ho ea ka thōko ho lisele tsa sele kapa tse ling tse khethiloeng tse sebelisang mobala o sa lekanyetsoang le botenya.
Motsoako oa bohlokoa oa ho eketsa meeli ke:
Ctrl + Shift + & (keypersand key)Mohlala oa Tsela ea ho eketsa marang-rang Ho sebelisa Shortcut ea Keyboard
- Totobatsa lisele tse ngata tse lakatsehang tse hlahang mosebetsing
- Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng.
- Tlanya le ho lokolla nomoro ea ampersand (&) - ka holim'a nomoro ea 7 ka lebokose-ntle le ho lokolla likheo tsa Ctrl le Shift .
- Lisele tse khethiloeng li lokela ho pota-potiloe ke moeli o motšo.
Ho eketsa Meeli ea Excel Ho Sebelisa Khetho ea Libon
Joalokaha ho bontšoa setšoantšong se ka holimo, khetho ea Borders e ka tlas'a t'hae ea lehae ea Ribbon .
- Totobatsa lisele tse ngata tse lakatsehang tse hlahang mosebetsing
- Tobetsa Tobeng ea Lehae ea Ribbon;
- Tobetsa ho letšoao la marang-rang ka lekarecheng ho bula menyetla ea ho theohela tlase joalokaha ho bontšoa setšoantšong se ka holimo;
- Tobetsa mofuta o lakatsehang oa moeli ho tloha menu;
- Moeli o khethiloeng o lokela ho hlaha ho potoloha lisele tse khethiloeng.
Khetho ea meeli
Ho na le mekhoa e mengata e mengata ha ho tluoa tabeng ea ho eketsa mela le meeli ea ho fapanya:
- meeli e ka kenngoa ho e 'ngoe kapa mahlakoreng' ohle a seleng kapa lebenkele la lisele;
- bophara bo fapaneng ba mela e ka sebelisoa;
- mefuta e fapa-fapaneng ea linepe e fumaneha;
- ho na le mebala e 'maloa eo u ka ikhethelang eona;
- Tsela ea Excel e fetela mofuteng e ka sebelisoa ho hula meeli e pota-potiloeng ka litsela tse sa tšoaneng tsa data, joalokaha ho bontšitsoe mohlaleng oa setšoantšo.
Drawing Borders
Joalokaha ho bontšoa setšoantšong, setšoantšo sa Drape ea Boraro se ka tlase ho menu ea theoha ea Borders joalokaha ho bontšoa setšoantšong se ka holimo.
Molemo o mong ho sebelisa meeli ea ho hula ke hore ha ho hlokahale ho khetha lisele pele. Ho e-na le hoo, hang ha moeli o khethoang o khethoa moeling o ka kenngoa ka ho toba leqepheng la lipampiri, joalokaha ho bontšitsoe karolong e nepahetseng ea setšoantšo.
Ho Fetola Linepe ea Mobala le Linea
Tlosa meeli e boetse e na le dikgetho tsa ho fetola mobala oa mobala le mokhoa oa line, e leng se etsang hore ho be bonolo haholo ho fapana le ponahalo ea meeli e sebelisetsoang ho totobatsa likheo tsa bohlokoa tsa data.
Litsela tsa mekhoa ea mebala li u lumella hore u bōpe meeli ka:
- mela ea boholo bo fapaneng
- mela e nang le mebala le e pshatlehileng
- mela e mabeli
Ho sebelisa Tsela ea Litšoantšo
- Tobetsa Tobeng ea Lehae ea Ribbon;
- Tlanya ka khetho ea Borders holim'a lehare ho bula menyetla e theoha;
- Fetola mobala oa line le / kapa mokhoa oa line ha ho hlokoa;
- Tobetsa ho Atamela Border ka tlaase ho menu e theoha;
- Pointer ea mouse e fetola pentšele - joalokaha ho bontšitsoe karolong e nepahetseng ea setšoantšo;
- Tobetsa moeli o mong le o mong oa grid ho kenya meeli e le 'ngoe libakeng tsena;
- Tlanya le ho hula ka pointer ho kenya meeli e ka ntle ho sele kapa lisele.
Atamela moeli oa moeli
Kgetho e 'ngoe ea Draw Border ke ho eketsa ka ntle ho meeli le ka hare ho meeli ho e le' ngoe kapa tse ling tse ngata ka nako e le 'ngoe.
E le ho etsa joalo, tobetsa le ho hula ka hohle ho lisele le ho "hula moeli oa moeli" ho theha meeli ho potoloha lisele tsohle tseo e leng karolo ea khetho.
Khaotsa ho taka meeli
Ho khaotsa ho hula meeli, feela tobetsa ka lekhetlo la bobeli setšoantšong sa moeli ka lebone.
Mofuta oa ho qetela oa moeli o sebelisoang o hopoloa ke lenaneo, leha ho le joalo, kahoo ho totobetsa letšoao la meeli ho boetse ho nolofalletsa mokhoa oo.
Meeli e fokolang
Khetho ena, kamoo lebitso le bontšang kateng, e etsa hore ho be bonolo ho tlosa meeli ho lisele tsa maqephe. Empa ho fapana le khetho ea No Border ho tloha lethathamong la meeli e tloaelehileng, meeli ea Erase e lumella hore u tlose mela ea moeli ka bomong - feela ka ho li tobetsa.
Meeli e mengata e ka boela ea tlosoa ka ho tobetsa le ho hula.