Ho nolofatsa mosebetsi morerong, li-hotkeys tsa Excel li tla lula li thusa. Ha u li sebelisa khafetsa, ho tla ba bonolo hore u hlophise litafole leha e le life.
Likhatiso tsa Excel keyboard
Ha o sebetsa le Excel, ho bonolo ho sebelisa mekhoa e khuts'oane ea keyboard ho e-na le panya. Morero oa tafole ea lenaneo o kenyelletsa mesebetsi e mengata le bokhoni ba ho sebetsa le litafole le litokomane tse rarahaneng ka ho fetisisa. E 'ngoe ea linotlolo tsa mantlha e tla ba Ctrl, e etsa motsoako o motle le tse ling kaofela.
U sebelisa likhatiso tsa keyboard ho Excel, o ka bula, koala maqephe, o sheba tokomane, o etsa lipalo le tse ling tse ngata.
Haeba u sa sebetse Excel ka linako tsohle, ho ka ba molemo hore u se ke ua senya nako ea hao u ithuta le ho hopola linotlolo tse chesang.
Lethathamo: Motsoako o thusang ho Excel
Mokokotlo oa keyboard | Ke ketso efe e tla etsoa |
Ctrl + Tlosa | Mongolo o khethiloeng oa tlosoa. |
Ctrl + Alt + V | Ho kenngoa ho khethehileng hoa etsahala |
Ctrl + letšoao + | Ho eketsoa likholomo le mela tse boletsoeng. |
Ctrl + sign - | Likholomo tse khethiloeng kapa mela e tlositsoe. |
Ctrl + D | Karolo e tlase e tlatsitsoe ke data e tsoang seleng e khethiloeng |
Ctrl + R | Karolo e ka ho le letona e tlatsitsoe ke data e tsoang seleng e khethiloeng. |
Ctrl + H | Fesetara ea Search-Replace ea hlaha. |
Ctrl + Z | Ketso ea ho qetela e hlakotsoe. |
Ctrl + Y | Ketso ea ho qetela e phetoa |
Ctrl + 1 | Puisano ea mochini oa sebopeho ea sele e ea qala. |
Ctrl + B | Mongolo o sebete |
Ctrl + I | Seketso se hlophisitsoeng |
Ctrl + U | Sengoloa se ngotsoe ka tlase. |
Ctrl + 5 | Se ngotsoeng se totobalitsoe. |
Ctrl + Kena | Lisele tsohle lia khethoa. |
Ctrl +; | Letsatsi le bontšitsoe |
Ctrl + Shift +; | Nako e tiisitsoe |
Ctrl + Backspace | Sethala se khutlela seleng e fetileng. |
Ctrl + Sebaka | Kholomo e hlahella |
Ctrl + A | Lintho tse bonahaleng lia hlakisoa. |
Ctrl + Qetellong | Kotopo e behiloe seleng ea hoqetela. |
Ctrl + Shift + Qetellong | Ho hlahisoa sele ea ho qetela |
Ctrl + Arrows | Kotopo e tsamaea ka mathoko a kholomo ka lehlakoreng la metsu. |
Ctrl + N | Ho hlaha buka e ncha e se nang letho |
Ctrl + S | Tokomane e bolokiloe |
Ctrl + O | Lebokose la ho batla file le lakatsehang lea bula. |
Ctrl + L | Mokhoa oa tafole oa Smart o qala |
Ctrl + F2 | Preview e kenyelelitsoe |
Ctrl + K | Hyperlink e kentsoe |
Ctrl + F3 | Motsamaisi oa mabitso o qala |
Lethathamo la lintho tse kopantsoeng ntle le Ctrl tsa ho sebetsa Excel le tsona lia hlolla.
- F9 e tla qala ho pheta-pheta ha liforamo, 'me hammoho le Shift e tla etsa sena pampiring e hlahang;
- F2 e tla letsetsa mohlophisi bakeng sa sele e itseng, 'me e pentiloe ka Shift - lintlha tsa eona;
- foromo "F11 + Shift" e tla etsa leqephe le lecha le se nang letho;
- Alt hammoho le Shift le motsu o nepahetseng li tla hlophisa tsohle tse khethiloeng. Haeba motsu o supa ka letsohong le letšehali, joale ho se bulehe ho tla etsahala;
- Alt e nang le motsu o tlase e tla bula lenane la ho theoha la sele e boletsoeng;
- ho roala mohala ho tla etsoa ka ho tobetsa Alt + Enter;
- Shift e nang le sebaka e tla totobatsa mola oa tafole.
Mohlomong u ntse u ipotsa hore na u ka sebelisa likhechana tsa keyboard ho Photoshop: //pcpro100.info/goryachie-klavishi-fotoshop/.
Ha menoana e se e ithutile sebaka sa linotlolo tsa boselamose, e tla etsa hore mahlo a hao a tsebe ho sebetsa tokomaneng eo. Joale lebelo la mesebetsi ea komporo ea hau e tla potlaka haholo.