Tse ka Hare
- Overview
- Likhaoletso tsa keyboard tse sebelisoang khafetsa
- Likhaoletso tsa Keyboard bakeng sa Ribone
- Ho Sebelisa Linotlolo tsa ho kena bakeng sa Li-tab tsa Ribone
- Ho sebetsa ka li-tab tsa ribone ho sebelisa keyboard
- Likhaoletso tsa keyboard bakeng sa ho fometa ha lisele
- Likhutšoane tsa keyboard ka har'a lebokose la puisano le Khethehileng ho Excel 2013
- Likhaoletso tsa keyboard bakeng sa liketso le likhetho
- Likhatiso tsa keyboard bakeng sa ho sebetsa ka data, mesebetsi, le foromo ea foromo
- Likhaoletso tsa keyboard ho Power Pivot
- Likhaoletso tsa keyboard ho li-add-ins tsa Office
- Linotlolo tsa mosebetsi
- Likhaoletso tse ling tse sebetsang tsa keyboard
- fihlela qeto e
Li-hotkeys ke karolo e ikhethang ea mohlophisi oa spreadsheet e u lumellang hore u fihle hang-hang mesebetsing e itseng. Sehloohong sena, re tla sebetsana ka ho qaqileng le seo processor ea spreadsheet e nang le linotlolo tse chesang, le hore na ke mekhoa efe e ka sebelisoang le bona.
Overview
Qalong, hlokomela hore letšoao la ho kopanya "+" le bolela motsoako oa likonopo. Tse peli tse joalo "++" ka tatellano li bolela hore "+" e tlameha ho hatelloa hammoho le senotlolo se seng ho keyboard. Linotlolo tsa tšebeletso ke likonopo tse tlamehang ho tobetsoa pele. Litšebeletso li kenyelletsa: Alt, Shift, le Ctrl.
Likhaoletso tsa keyboard tse sebelisoang khafetsa
Taba ea pele, a re hlahlobeng metsoako e tsebahalang:
| KHOTHATSO + TAB | Khutlela tšimong e fetileng kapa sebakeng sa ho qetela fensetereng. |
| ARROW ↑ | Tsamaea ka lehlakoreng le ka holimo ka lebala le le leng la lakane. |
| ARROW ↓ | Tsamaea ka lehlakoreng le ka tlase ka lebala le le leng la lakane. |
| ARROW ← | Tsamaea ka lehlakoreng le letšehali ka lebala le le leng la lakane. |
| ARROW → | Tsamaea ka lehlakoreng le letona ka lebala le 1 la lakane. |
| CTRL + konopo ea motsu | Suthela qetellong ea sebaka sa tlhahisoleseding leqepheng. |
| QETELA, konopo ea motsu | Ho fallela tshebetsong e bitswang “Qetello”. Ho thibela tshebetso. |
| CTRL+END | Tsamaea lebaleng le phethiloeng holim'a lakane. |
| CTRL+SHIFT+END | Atometsa sebakeng se tšoailoeng ho sele ea ho qetela e sebelisitsoeng. |
| LEHAE+MOQOLOTSOA | Suthela seleng e teng karolong e ka holimo le letšehali la sebaka seo. |
| LEQEPHE | Tsamaisa skrine e 1 tlase ho lakane. |
| CTRL+LEQEPHE FASE | Suthela lakane e 'ngoe. |
| ALT+LEQEPHE FASE | Tsamaisa skrine e 1 ho le letona lakane. |
| LEQEPHE LEHATA | Susumelletsa skrine e 1 holimo ho lakane. |
| ALT+LEQEPHE PHAHAMA | Tsamaisa skrine se le 1 ho ea ka letsohong le letšehali lakane. |
| CTRL+LEQEPHE PHAHAMA | Khutlela leqepheng le fetileng. |
| TAB | Suthela lebala le 1 ka ho le letona. |
| ALT+ARROW↓ | Dumella lenane la tlhahlobo bakeng sa sebaka. |
| CTRL+ALT+5 e lateloe ke likhatiso tse seng kae tsa TAB | Phetoho lipakeng tsa libopeho tse tsamaeang (mongolo, litšoantšo, joalo-joalo). |
| CTRL + SHIFT | Moqolo o otlolohileng. |
Likhaoletso tsa Keyboard bakeng sa Ribone
Ho tobetsa "ALT" ho bonts'a motsoako oa likonopo bareng ea lisebelisoa. Ena ke temoso bakeng sa basebelisi ba e-so tsebe li-hotkeys kaofela.
Ho Sebelisa Linotlolo tsa ho kena bakeng sa Li-tab tsa Ribone
| TSOHLE, F | Ho kena karolong ea "File" le ho sebelisa Backstage. |
| ALT, ke | Ho kena karolong ea "Home", ho fometa mongolo kapa lintlha tsa linomoro. |
| TSOHLE, С | Ho kena karolong ea "Insert" le ho kenya likarolo tse sa tšoaneng. |
| ALT+P | Kena karolong ea "Page Layout". |
| ALT, L | Kena karolong ea "Formula". |
| Setšoantšo sa ALT + | Ho kena karolong ea "Data". |
| ALT+R | Ho fihlella karolo ea "Reviewers". |
| ALT+O | Ho kena karolong ea "Sheba". |
Ho sebetsa ka li-tab tsa ribone ho sebelisa keyboard
| F10 kapa ALT | Khetha karolo e sebetsang ho toolbar 'me u nolofalletse li-buttons tsa ho kena. |
| KHOTHATSO + TAB | Tsamaea ho litaelo tsa ribone. |
| Likonopo tsa motsu | Movement ka litsela tse fapaneng pakeng tsa likarolo tsa theipi. |
| KENA kapa sebaka | Lumella konopo e khethiloeng. |
| ARROW ↓ | Tlhahiso ea lenane la sehlopha seo re se khethileng. |
| ALT+ARROW ↓ | Ho bula menu ea konopo eo re e khethileng. |
| ARROW ↓ | Fetolela ho taelo e latelang ka fensetere e atolositsoeng. |
| CTRL + F1 | Ho phutha kapa ho phutholla. |
| KHAHLISO + F10 | Ho bula menyu ea litaba. |
| ARROW ← | Fetohela ho li-submenu. |
Likhaoletso tsa keyboard bakeng sa ho fometa ha lisele
| Ctrl + B | Lumella mofuta o hlakileng oa lintlha. |
| Ctrl + I | Lumella mofuta o itseng oa litaba. |
| Ctrl + U | Dumella ho sehella. |
| Alt + H + H | Ho khetha tint ea mongolo. |
| Alt+H+B | Ts'ebetso ea foreimi. |
| Ctrl + Shift + & | Ts'ebetso ea karolo ea contour. |
| Ctrl + Shift + _ | Tima liforeimi. |
| Ctrl + 9 | Pata mela e khethiloeng. |
| Ctrl + 0 | Pata mela e khethiloeng. |
| Ctrl + 1 | E bula fensetere ea Format Cells. |
| Ctrl + 5 | Lumella ho otla. |
| Ctrl + Shift + $ | Tšebeliso ea chelete. |
| Ctrl + Shift +% | Ho sebelisa peresente. |
Likhutšoane tsa keyboard ka har'a lebokose la puisano le Khethehileng ho Excel 2013
Phetolelo ena ea mohlophisi oa spreadsheet e na le tšobotsi e khethehileng e bitsoang Paste Special.
Hotkeys tse latelang li sebelisoa fensetereng ena:
| A | Ho eketsa litaba tsohle. |
| F | Ho eketsa liforomo. |
| V | Ho eketsa litekanyetso. |
| T | Ho kenya feela fomete ea mantlha. |
| C | Ho eketsa lintlha le lintlha. |
| N | Ho eketsa likhetho tsa scan. |
| H | Ho eketsa lifomate. |
| X | Ho eketsa ntle le meeli. |
| W | Ho eketsa ka bophara ba pele. |
Likhaoletso tsa keyboard bakeng sa liketso le likhetho
| Shift + ARROW → / ← | Eketsa sebaka sa khetho ho ea ho le letona kapa le letšehali. |
| Shift + Sebaka | Ho khetha mohala oohle. |
| Ctrl+Sebaka | Ho khetha kholomo eohle. |
| Ctrl+Shift+Sebaka | Ho khetha letlapa lohle. |
Likhatiso tsa keyboard bakeng sa ho sebetsa ka data, mesebetsi, le foromo ea foromo
| F2 | Ho fetoha ha maemo. |
| Shift + F2 | Ho eketsa molaetsa. |
| Ctrl + X | Khaola lintlha tse tsoang tšimong. |
| Ctrl + C | Ho kopitsa lintlha tse tsoang tšimong. |
| Ctrl + V | Ho eketsa lintlha tse tsoang tšimong. |
| Ctrl + Alt + V | Ho bula fensetere ea "Special Attachment". |
| hlakola | Ho tlosa ho tlatsoa ha tšimo. |
| Kenya + Alt | Ho kenya poelo ka hare ho lebala. |
| F3 | E eketsa lebitso la sebaka. |
| Alt + H + D + C | Ho tlosa kholomo. |
| Esc | Hlakola ho kena tšimong. |
| kena | Ho tlatsa tlhahiso tšimong. |
Likhaoletso tsa keyboard ho Power Pivot
| PCM | Ho bula menyu ea litaba. |
| CTRL+A | Ho khetha tafole eohle. |
| CTRL+D | Ho tlosa boto kaofela. |
| CTRL+M | Ho tsamaisa poleiti. |
| CTRL+R | Ho reha tafole bocha. |
| CTRL+S | Boloka. |
| CTRL+Y | Ho pheta-pheta mokhoa o fetileng. |
| CTRL+Z | Ho khutla ha mokhoa o feteletseng. |
| F5 | Ho bula fensetere ea "Go". |
Likhaoletso tsa keyboard ho li-add-ins tsa Office
| CTRL+SHIFT+F10 | Ho bula lenane. |
| CTRL+SPACE | Phatlalatso ea sebaka sa mesebetsi. |
| CTRL+SPACE ebe o tobetsa ho Koala | Koala sebaka sa mosebetsi. |
Linotlolo tsa mosebetsi
| F1 | Dumella thuso. |
| F2 | Ho fetola sele e khethiloeng. |
| F3 | Suthela lebokoseng la "Lebitso qetellong". |
| F4 | Pheta ketso e fetileng. |
| F5 | Eya ho fensetere ea "Kena". |
| F6 | Phetoho lipakeng tsa likarolo tsa mohlophisi oa tafole. |
| F7 | Ho bula fensetere ea "Spelling". |
| F8 | Kenya ts'ebetsong khetho e atolositsoeng. |
| F9 | Ho bala maqephe. |
| F10 | Kenya malebela tšebetsong. |
| F11 | Ho eketsa chate. |
| F12 | Eya ho "Save As" fensetere. |
Likhaoletso tse ling tse sebetsang tsa keyboard
| Alt+' | E bula fensetere ea ho hlophisa mokhoa oa lisele. |
| PUSELETSOE
| Ho hlakola motho. |
| kena | Qetello ea sete ya data. |
| ESC | Hlakola sete. |
| HOME | Khutlela qalong ea lakane kapa mola. |
fihlela qeto e
Ehlile, ho na le linotlolo tse ling tse chesang ho mohlophisi oa spreadsheet. Re hlahlobile mefuta e tsebahalang haholo le e sebelisoang haholo. Tšebeliso ea linotlolo tsena e tla thusa basebedisi ho sebetsa ka potlako ho mohlophisi oa spreadsheet.