Linotlolo tse chesang ke ts'ebetso eo, ka ho thaepa motsoako o itseng oa likonopo ho keyboard, e fanang ka phihlello ea kapele ho likarolo tse ling tsa sistimi e sebetsang, kapa lenaneo le arohaneng. Microsoft Excel le eona e na le sesebelisoa sena. A re boneng hore na ke li-cookkeys life tse tsoang ho Excel le hore na u ka etsa eng ka tsona.
Tlhahisoleseling ka kakaretso
Pele ho tsohle, ho lokela ho hlokomeloe hore lenaneng la linotlolo tse chesang ka tlase, lets'oao le le leng la "+" le tla sebetsa e le lets'oao le bolelang moqomo oa keyboard. Haeba ho bontšitsoe letšoao la "++, sena se bolela hore o hloka ho tobetsa konopo ea "+" ho konopo hammoho le konopo e 'ngoe e boletsoeng. Mabitso a linotlolo tsa ts'ebetso a bontšoa joalo ka ha a rehiloe ka konopo: F1, F2, F3, jj.
Hape, ho lokela ho boleloa hore ea pele e tobetsa likonopo tsa ts'ebeletso. Tsena li kenyelletsa Shift, Ctrl le Alt. Mme kamora moo, ho ts'oere linotlolo tsena, tobetsa linotlolo tsa ts'ebetso, li-button tse nang le litlhaku, linomoro le matšoao a mang.
Litlhophiso tse akaretsang
Lisebelisoa tsa Microsoft tsa tsamaiso ka kakaretso li kenyelletsa likarolo tsa mantlha tsa lenaneo: ho bula, ho boloka, ho theha file, jj. Lits'oaetso tse khutšoane tse fanang ka phihlello ea lits'ebetso tsena ke tse latelang:
- Ctrl + N - theha faele;
- Ctrl + S - boloka buka;
- F12 - khetha sebopeho le sebaka sa buka eo o tla e boloka;
- Ctrl + O - bula buka e ncha;
- Ctrl + F4 - koala buka;
- Ctrl + P - ponelopele ea khatiso;
- Ctrl + A - khetha leqephe lohle.
Linotlolo tsa Navigation
Ho tsamaea ka pampiri kapa buka, ho boetse ho na le likotlolo tsa bona tse chesang.
- Ctrl + F6 - motsamao lipakeng tsa libuka tse 'maloa tse bulehileng;
- Tab - fetela seleng e latelang;
- Shift + Tab - fetela seleng e fetileng;
- Leqephe la Up - ho hlohlelletsa boholo ba sebali;
- Leqephe tlase - ho theola tlase sa boholo ba moitlami;
- Ctrl + Page Up - fetela ho leqephe le fetileng;
- Ctrl + Leqephe la tlase - fetela leqephe le latelang;
- Ctrl + End - fetela seleng ea ho qetela;
- Ctrl + Lehae - fetela seleng ea pele.
Meqomo ea likonopo
Microsoft Excel ha e sebelisoe feela bakeng sa kaho e bonolo ea litafole, empa le bakeng sa liketso tsa computational ho tsona ka ho kenya liforomo. Bakeng sa ho fihlella ka potlako liketsong tsena, ho na le linotlolo tse chesang tse tsamaeang.
- Alt + = - ts'ebetso ea palo ea likoloi;
- Ctrl + ~ - bonts'a lipalo ho lisele;
- F9 - ho bala mefuta eohle ea faele;
- Shift + F9 - ho pheta-pheta ha lifomate letlapeng le mafolofolo;
- Shift + F3 - bitsa Wizard ea Ts'ebetso.
Ho hlophisoa ha data
Linotlolo tse chesang tsa data ea editing li u lumella ho tlatsa tafole kapele ka tlhaiso-leseling.
- F2 - mokhoa oa ho hlophisa oa sele e tšoailoeng;
- Ctrl ++ - eketsa likholomo kapa mela;
- Ctrl + - - hlakola likholomo kapa mela e khethiloeng pampiring ea Microsoft Excel spreadsheet;
- Ctrl + Tlosa - hlakola mongolo o khethiloeng;
- Ctrl + H - fensetere "Batla / Pheta";
- Ctrl + Z - hlakola ketso ea ho qetela;
- Ctrl + Alt + V - sephutheloana se khethehileng.
Fomate
E 'ngoe ea likarolo tsa bohlokoa tsa moralo oa litafole le mekhahlelo ea lisele ke ho fomata. Ntle le moo, fomate e boetse e ama lits'ebetso tsa khomphutha ho Excel.
- Ctrl + Shift +% - etsa sebopeho sa liperesente;
- Ctrl + Shift + $ - mofuta oa polelo ea chelete;
- Ctrl + Shift + # - sebopeho sa letsatsi;
- Ctrl + Shift +! - fomate ea linomoro;
- Ctrl + Shift + ~ - sebopeho se akaretsang;
- Ctrl + 1 - ts'ebetso ea fensetere ea sebopeho sa sele.
Likarolo tse ling tsa keyboard
Ntle le linotlolo tse chesang tse neng li hlalositsoe ka lihlopheng tse kaholimo, Excel e na le likheo tsa bohlokoa joalo ka konopo bakeng sa mesebetsi ea ho letsetsa:
- Alt + '- khetho ea setaele;
- F11 - theha chate pampiring e ncha;
- Shift + F2 - fetola maikutlo seleng;
- F7 - hlahloba sengoloa bakeng sa liphoso.
Ho joalo, ha se likhetho tsohle tsa ho sebelisa linotlolo tse chesang mananeo a Microsoft Excel a hlahisitsoeng ka holimo. Leha ho le joalo, re ile ra ela hloko tse tummeng, tse bohlokoa, 'me re li batlile. Ho joalo, tšebeliso ea linotlolo tse chesang e ka nolofatsa haholo le ho potlakisa mosebetsi ho Microsoft Excel.
