Hotkeys ke mosebetsi oa hore, ka ho thapa motsoako o khethehileng oa lebokose, o fana ka phihlelo kapele ea likarolo tse ling tsa tsamaiso ea ts'ebetso, kapa lenaneo le le leng. Sesebelisoa sena se boetse se fumaneha bakeng sa Microsoft Excel. A re batliseng hore na li-hotkeys li hokae Excel, le seo u ka se etsang le bona.
Boitsebiso bo tloaelehileng
Ntlha ea pele, ho lokela ho hlokomeloa hore lenaneng la linotlolo tse chesang tse hlahisoang ka tlase, letšoao le le leng "+" le tla sebetsa e le letšoao le bontšang motsoako oa sehlooho. Haeba letšoao la "++" le bonts'oa - sena se bolela hore ka lebokoseng u lokela ho hatella "key" ho kenyeletsa le senotlolo se seng se bontšitsoeng. Lebitso la linotlolo tsa tshebetso le bonts'oa ha li bitsoa lebokoseng: F1, F2, F3, joalo-joalo.
Hape, ho ka boleloa hore tlhoko ea pele ea ho hatella lintlha tsa tšebeletso. Tsena li kenyelletsa Shift, Ctrl le Alt. 'Me ka mor'a moo, ha u ntse u tšoere linotlolo tsena, tobetsa konopo ea mesebetsi, likonopo tse nang le mangolo, lipalo le matšoao a mang.
Lisebelisoa tsa Kakaretso
Lisebelisoa tse tloaelehileng tsa tsamaiso tsa Microsoft li kenyelletsa likarolo tsa motheo tsa lenaneo: ho bula, ho boloka, ho theha faele, joalo-joalo. Linotlolo tse hotang tse fanang ka phihlelo ea mesebetsi ena ke tse latelang:
- Ctrl + N - bopa faele;
- Ctrl + S - pholosa buka;
- F12 - khetha mofuta le sebaka sa buka ho boloka;
- Ctrl + O - ho bula buka e ncha;
- Ctrl + F4 - koala buka;
- Ctrl + P - tlhahlobo ea ho hatisa;
- Ctrl + A - khetha letlapa kaofela.
Linotlolo tsa ho tsamaea
Ho tsamaea le lakane kapa buka, le bona, ba na le linotlolo tsa bona tse chesang.
- Ctrl + F6 - ho falla pakeng tsa libuka tse 'maloa tse bulehileng;
- Tab - fallela seleng e latelang;
- Shift + Tab - fallela seleng e fetileng;
- Ho nyoloha ha leqephe - fetisetsa boholo ba mochine;
- Leqephe le theoha - theohela fatše ho lekola boholo;
- Leqephe la Ctrl Tsamaea - fallela lethathamong la pele;
- Leqephe la Ctrl + le theoha - fallela lethathamong le hlahlamang;
- Qetello ea Ctrl + - fallela seleng ea ho qetela;
- Lehae la Ctrl + - fallela seleng ea pele.
Hotkeys bakeng sa ho sebetsana le mesebetsi
Microsoft Excel ha e sebetse feela bakeng sa kaho e bonolo ea litafole, empa hape e sebelisetsoa liketso tsa boithuto ho tsona, ka ho kenya litlhaloso. Bakeng sa khato e potlakileng ea liketso tsena, ho na le linotlolo tse chesang tse tšoanang.
- Alt + = - activation avtosummy;
- Ctrl + ~ - ho bonts'a lipalo ho hlahisa lisele;
- F9 - ho ts'oaroa ha litlhaloso tsohle lefapheng;
- Shift + F9 - recalculation of formula ka leqephe le sebetsang;
- Shift + F3 - letsetsa mosebetsing oa wizard.
Phetoho ea data
Hotkeys bakeng sa ho hlophisa lintlha li u lumella ho tlatsa kapele tafole ka boitsebiso.
- F2 - fetola mokhoa oa sele e khethiloeng;
- Ctrl ++ - eketsa mela kapa mela;
- Ctrl + - - e tlosa mela e khethiloeng kapa mela e hlahang tafoleng ea Microsoft Excel;
- Ctrl + Tlosa - tlosa mongolo o khethiloeng;
- Ctrl + H - Batla fensetere;
- Ctrl + Z - tlosa ketso e entseng ho qetela;
- Ctrl + Alt + V - kenyelletso e khethehileng.
Ho fetolela
E 'ngoe ea likarolo tsa bohlokoa tsa moralo oa litafole le mebala ea lisele ke ea ho finyella. Ho phaella moo, ho etsa setšoantšo ho boetse ho ama mekhoa ea computational ho Excel.
- Ctrl + Shift +% - ho kenyeletsa fomati ea peresente;
- Ctrl + Shift + $ - mofuta oa chelete ea bohlokoa;
- Ctrl + Shift + # - mokhoa oa letsatsi;
- Ctrl + Shift +! - mofuta oa lipalo;
- Ctrl + Shift + ~ - mokhoa o tloaelehileng;
- Ctrl + 1 - e etsa hore fensetere e sebetsang ka seleng e sebetse.
Li-hotkeys tse ling
Ho phaella ho li-hotkeys tse neng li thathamisitsoe lihlopheng tse ka holimo, Excel e na le lihlopha tse latelang tsa bohlokoa ho lebokose bakeng sa mesebetsi ea ho bitsa:
- Alt + '- khetho ea mokhoa;
- F11 - ho theha chate ka lakane e ncha;
- Shift + F2 - fetola maikutlo ho seleng;
- F7 - ho hlahloba melaetsa bakeng sa liphoso.
Ha e le hantle, hase mekhoa eohle ea ho sebelisa linotlolo tse chesang ho Microsoft Excel e hlahisitsoeng ka holimo. Leha ho le joalo, re ne re ela hloko batho ba ratoang haholo, ba sebetsang, le ba bo hlokang. Ha e le hantle, tšebeliso ea linotlolo tse chesang e ka nolofatsa le ho potlakisa mosebetsi ho Microsoft Excel.
