Linotlolo tse chesang tsa Excel (li-keycut)

Li-key keys li thusa basebedisi ho nolofatsa mosebetsi le ho potlakisa, ho nkela liketso tse 'maloa sebaka. Sena ke sa bohlokoa le ho feta lenaneong la ofisi joaloka Microsoft Excel, e etselitsoeng ho etsa hore ho be bonolo hore motho a sebetse ka litlhaloso tsa data tsa mefuta e sa tšoaneng. Nahana ka mekhabiso e tloaelehileng ea li-keyboard e sebelisoang liphetolelong tse ngata tsa kopo ena (ho tloha Excel 2003 ho ea ho Excel 2013). 'Me ho Excel 2003 ha ho na mekhoa ea ho sebetsana le lithane - Sebapali sa Toolbar sa Quick Access, hobane ketsahalo ena e hlahile feela Excel 2007' me e fumaneha liphetolelong tsa morao-rao. Tse ling tsa tse kopanetsoeng tsena li ka 'na tsa se ke tsa sebetsa liphetolelong tsa sebaka sena sa kopo ka potso.

Li-hotkeys tse ratoang ka ho fetisisa Excel

Ka ho hatisa lintlha tsena tsa bohlokoa, mesebetsi e kholo ea lenaneo e etsoa. Tlhaloso ea linotlolo tse chesang, letšoao "+" le sebelisoa ho bontša khatiso ka nako e le 'ngoe ea linotlolo tse ka letsohong le letona le le letšehali la "" ". Lihlopha tsa linotlolo li bonts'oa ho li-parentheses, ka nako e le 'ngoe, lintlha tse le' ngoe, tse peli, tse tharo kapa tse 'nè ka lebokoseng li ka hatelloa. Hangata, tse peli kapa tse tharo tsa tsona ke lits'ebetso tsa tšebeletso - Ctrl, Shift kapa Alt. Ba hloka ho hatelloa pele 'me ha ba ntse ba tšoere, sutumelletsa e' ngoe (ea boraro kapa ea bone) ea motsoako oa hotkey.

Ho theha faele e ncha, tobetsa (Ctrl + N). Ho ea menyetla kapa ho bula file - (Ctrl + O), boloka file - (Ctrl + S), "Save As" - (F12), hatisa - (Ctrl + P). Koala file - (Ctrl + F4). Ketso ea ho qetela: etsolla - (Ctrl + Z), pheta - (Ctrl + Y). Qala ho bopa foromo - (=). Koala file - (Alt + F4). Kenya column - (Ctrl + Shift + key hape). Kenya lakane e ncha - (Shift + F11). Bitsa moqoqo oa ho hlahisa tafoleng - (Ctrl + L). Tlosa temana ka sele - (Alt + Enter).

Mesebetsi ea ho tsamaea

Li-shortcuts tse latelang tsa Excel li fanoa bakeng sa ho etsa lifofane. Bitsa fensetere "E-ea" - (Ctrl + G). E-ea seleng ka ho le letona - (Tab); Ho seleng ka letsohong le letšehali - (Shift + Tab); Hlakisa skrine e le 'ngoe - (PageUp); Tlase skrineng e le 'ngoe - (Data ea Leqephe); Leqepheng le latelang - (Ctrl + PageDown); Leqepheng le fetileng - (Ctrl + PageUp); Sebakeng sa dintlha: ho isa seleng e qalang - (Ctrl + Lehae); Ho sele e koalang - (Ctrl + End); Tseleng ea motsu ho ea seleng ea pele - (Ctrl + Arrow). Ho tsamaea pakeng tsa maqephe a buka e bulehileng - (Ctrl + F6).

Ho fetola mongolo le lisele

E le hore u itšoare ka selefouno (seleng), sebelisa mefuta ea khetho ea Excel e bontšitsoeng ka tlase. Ka likarolo tsena, sebelisa senotlolo sa Ctrl hammoho le linotlolo tse ling tse boletsoeng karolong ena ho li-parentheses.

Tlhahiso: Bold - (B), e hlalositsoeng - (U), italic - (3), ho betla - (5). Menyu: fetola fonte - (Shift + F), boholo ba font - (Shift + P). Sebelisa litemana tsa meeli - (Shift + 7). Tlosa meeli eohle - (Shift + Underline).

Bitsa menyetla: hlahisa lisele - (1), khetha font - (Shift + F), khetha boholo ba fonte - (Shift + P). Beha foromo: palo - (Shift + 5), linomoro - (Shift + 1), nako - (Alt + 2), matsatsi - (Alt + 3), chelete - (Alt + 4), chelete - (Shift + 4) , E tloaelehileng (ho tlosa mokhoa oa ho bopa) - (Shift + #).

Ho khetha le ho hlophisa mongolo

Khetha: letlapa lohle - (Ctrl + A), mola o feletseng - (Shift + Space), mohala o feletseng - (Ctrl + Space), lisele tsa lisele tse leboteng - (Shift + Arrow), lisele tse ngata, (Ctrl + Shift + 8).

Mongolo o inehetseng: khaola (ho ea ho buffer) - (Ctrl + X), kopi (ho buffer) - (Ctrl + C). Tšoaea ho tswa ho buffer - (Ctrl + V). Tlosa sebopeho se le seng ho tloha ho sekhukhu: ka ho le letona (Tlosa), ka letsohong le letšehali - (Backspace). Fetola sele e sebetsang - (F2). Tlosa boleng ba hona joale mme u fetole sele e sebetsang - (Sebaka).

Metsotso e meng ea Excel

Bitsa lebokose la lipatlisiso - (Ctrl + F), fetola temana - (Ctrl + H), khetha mokhoa - (Alt + '). Etsa ka botlalo sate pampiring e ncha (F11). Fetola maikutlo ho seleng - (Shift + F2). Fumana Motlakase oa lisele tse khethiloeng ka har'a mohala - (Alt + =); Bohloko ba tjhelete bo behoa ka seleng ea khoeli ena moleng o latelang tlas'a khetho. Ho kenya seleng e khethiloeng ka ho toba: letsatsi - (Ctrl + Shift +4), nako - (Ctrl + Shift +6). Spellcheck - (F7).

E latelang, a re bueng ka ho kopanya lisele tse Excel. The hotkey tabeng ena, ka bomalimabe, ha se mothusi. Leha ho le joalo, ho na le mekhoa e meng eo ka eona u ka fokolisang mosebetsi.

Algorithm ea liketso

Haeba o hloka ho kopanya lisele ho Excel, ho hlaha mathata a mang. Etsoe, opereishene ena e amahanngoa le tahlehelo ea data lisele tsohle tsa sebaka se kopantsoeng, ntle le ho ka holimo ka ho le letšehali. Pele u tlameha ho khetha sebaka sa lisele tse lokelang ho kopanngoa, tobetsa ka ho le letona sebakeng seo u khethiloeng ho sona, khetha "menu ea thelekere" "menu" e theoha. Fensetere "Format ea lisele" e hlahella, khetha tab ea "Khomeliso" ho eona ebe u tšoaea lebokose le reng "Kopanya lisele". Ho etsa ts'ebetso eo ho etsoang ka eona ka kakaretso, ha ho na hotkeys ho kopo ea Excel.

Ho bonolo ho kopanya lisele ka ho sebelisa letšoao le khethehileng la "Kopanya le ho kenya bohareng", e leng menu "Home". Haeba ha ho hlokahale hore u behe data bohareng, tobetsa lebokose ho le letona la konopo ena 'me u khethe ntho e loketseng ho tloha ho theolelo e tlaase ho tlase. Tseleng, haeba o atisa ho sebelisa opereishene ena, ho molemo ho beha konopo ena leboteng la mekhoa ea ho qetela. Ho boloka boitsebiso bo tsoang lisele tse ling sebakeng se kopantsoeng, ntle le ho ka holimo ka ho le letšehali, u lokela ho fetisetsa litaba tsa bona sebakeng se seng kapa u li kenye seleng ena u sebelisa kopi (kapa khaola) le mesebetsi ea ho pata.

Mekhoa e meng e ka khonehang ea ho kopanya lisele, ho felisa tahlehelo ea data, e amahanngoa le tšebeliso ea macros, e ka fumanoang, ka mohlala, libokeng tsa ho sebetsa Excel. Molao-motheo oa ho sebetsa le macros o tšoana le oa matsoho, empa o potlakile ebile o sa amohelehe ho motho ea sebelisang.

Kamoo o ka kenya mohala ka ho sebelisa linotlolo tse chesang

Hangata ho na le tlhokahalo ea leqephe la Excel bakeng sa ho kenya mola. Linotlolo tse chesang tse sebelisetsoang ts'ebetso ena ke Ctrl + plus sign. Tabeng ena, o lokela ho khetha moeli o ka hodimo oo u batlang ho o kenya o mocha. Khetho ena e ka etsoa ka motsoako oa lichelete tse chesang (Shift + Space) kapa ka ho tobetsa konopo ea letsohong le letšehali ho palo ea nomoro ka letsohong le letšehali la mola o lekanang ha sekhooa se nka mokhoa oa motsu. Haeba mohala o sa khethoa, joale motsoako oa linotlolo tse chesang (Ctrl + letšoao le leng) o lebisa ho menu ea "Add cells" e tsamaisanang le eona, e leng se etsang hore u ikhethele hore na o kenyeletsa: lisele tse nang le ho theohela kapa ho le letona, mola kapa molaleng.

Letšoao le chesang la Excel "Tlosa mola" - (Ctrl + minus sign). Ho tlosa mola, o tlameha ho o khetha ebe o hatella ena motsoako oa sehlooho.

Ha o hatisa konopo ea Alt ho bar ba menyetla ea kopo, lintlha tsa litsuoa tse chesang tsa likarolo tsa menyetla li hlaha. Sena se bontšoa ho setšoantšong. E fumaneha liphetolelong tsa lenaneo ho qala ka Excel 2007.

Kenyelletso e ikhethang ho Excel

Hangata, o hloka feela ho kenyelletsa boleng ka seleng kapa feela litlhahlobo. Ho etsa sena, ho na le khetho e joalo Excel - e kenyelletsoeng e khethehileng. Linotlolo tse chesang bakeng sa sena ke (Ctrl + Alt + V).

Ha o hatella linotlolo tsena, lebokose la lebokose le reng "Pata Khethehileng" le bula. E fumaneha hang-hang pele ho sena, ntho, lintho tse ka seleng, temana ea letlapa kapa lenaneong le leng li ngotsoe kapa li khaotsoe. Ka fensetere, o lokela ho khetha ntho eo u e thahasellang: litlhaloso, boleng, libopeho, tlaleho kapa e 'ngoe ea dikgetho tse hlahisitsoeng.

Kahoo, ha u se u tloaelane le lihlooho tsa sehlooho sena, u ithutile hore na li-shortcuts tsa Excel li teng le hore na u ka li sebelisa joang. Ka tlhaho, sehlooho sena ha se hlalose lintho tsohle tse teng. E le hore u ithute ka ho feletseng ka sehlooho, u lokela ho sebelisa lingoliloeng tse khethehileng.