Li-shortcuts tsa Excel

Mekhoa e mokhutšoanyane ea khetho ea Excel ea Lihlahisoa tse tloaelehileng le Lits'ebeletso

Ithute tsohle ka lisebelisoa tsa mekhoa ea ho fokotsa, ho kopanyelletsa le lihlopha ho sebelisa monyetla oa Excel ho ea ka matla a eona a feletseng.

01 ea 27

Kenya New Worksheet ka Excel

Tlhahiso ena ea Excel e bontša kamoo u ka kenya leqephe le lecha kateng ho buka ea libuka u sebelisa seqhoqho sa keyboard. Kenya New Sheet Worksheet ka Sebeliso ea Keyboard Shortcut Press 'me u khomarele key SHIFT lebokoseng. Tlanya le ho lokolla senotlolo sa F11 lebokoseng. Letlapa le ncha le tla kenngoa bukeng ea hona joale ea buka. Ho eketsa lipampiri tse eketsehileng ho tsoela pele ho hatella le ho lokolla senotlolo sa F11 ha u ntse u boloka khetho ea SHIFT. Hape "

02 ho ea ho 27

Tlanya Mongolo Lintlheng Tse peli ho Excel

Ho kopa molaetsa ka seleng Haeba u batla hore mongolo o hlahe meleng e mengata ka seleng, u ka etsa mochine sele hore molaetsa o hlake ka ho toba, kapa u ka kenya molaetsa oa molaetsa. U batla ho etsa eng? Ho ngola mongolo ka botlalo Ho kenya khefu ea molaetsa Pela mongolo ka kotloloho Leqepheng la mosebetsi, khetha lisele tseo u batlang ho li etsa. Tabeng ea Lehae, ho sehlopha sa Kopano, tobetsa setšoantšo sa Butle-butle sa Phatlalatso. Litlaleho tsa Lintlha tsa Litšoantšo tsa Libone tsa cellphone tse ka seleng ea wraps ho lumellana le bophara bo boholo. Ha o fetola bophara ba molumo, ho kenyelletsa data ho fetola ka botlalo. Haeba mongolo o phuthetsoe o sa bonahale, e ka 'na ea e-ba hobane mobala o behiloe bophahamong bo itseng kapa hore temana e ka lisele tse ngata tse kopantsoeng. Ho etsa hore mongolo o koahetsoeng o hlahe, etsa lintlha tse latelang ho fetola bolelele ba mola: Khetha cell kapa lebotho leo u batlang ho fetola bolelele ba mola. Tabeng ea Lehae, ho sehlopha sa Lihlopha, tobetsa Format. Setšoantšo sa Lebone la Excel Tlas'a Cell Size, etsa e 'ngoe ea tse latelang: E ​​le hore u fetole bophahamo ba moeli ka ho toba, tobetsa Boipiletso ba Boima ba Boima. Ho totobatsa bolelele ba mola, tobetsa Row Height, ebe u thaepa bophahamo ba mola o lekanang le lebokoseng la Row. Tlhahiso U ka boela ua hula moeli o ka tlase oa mola ho isa bophahamong bo bontšang mongolo o phuthetsoe. Top of Page Haholo ea leqephe Etsa khetho ea moeli U ka qala molaetsa o mocha nthong leha e le efe e itseng ka sele. Penya kabili sele eo u batlang ho kena ho eona. Khetho ea Keyboard U ka boela ua khetha sele, ebe u hatella F2. Ka seleng, tobetsa sebaka seo u batlang ho senya mola, ebe o hatella ALT + ENTER.

Sehlooho sa mongolo oa sekoahelo sa Excel ke sesebelisoa sa mokhoa o amohelehang o lumellang hore u laole ponahalo ea maele le lihlooho tsa hau ea spreadsheet .

Mantsoe a ho phuthela a u lumella hore u behe litemana melaong e mengata ka har'a sele e le 'ngoe ho e -na le hore molaetsa o phatlalatsoe ho feta lisele tse ngata kahare .

Lentsoe "tekanyetso ea teketeki" bakeng sa tšobotsi ena ke ho koahela mongolo 'me motsoako oa sehlooho oa ho phuthela mongolo ke:

Alt + Kena

Mohlala: Sebelisa Litsela tsa Shortcut ho Tlanya Lengolo

Mohlala o sebelisa sekhetho se ngotsoeng ka mongolo oa Excel:

1. Ka seleng ea D1 ngola mofuta ona: Tlatsetso ea Khoeli le Khoeli 'me u tobetse ho kenya ho kopo lebokoseng.
2. Kaha taba e telele haholo bakeng sa sele, e lokela ho tšela ka seleng E1.
3. Ka cell E1 thaba taba: Litsenyehelo tsa Khoeli le Khoeli le ho kenya konopo ho lebokose.
4. Ka ho kenya data ho E1 letšoao ka cell D1 le lokela ho felisoa qetellong ea sele D1. Hape, temana e E1 e lokela ho tšela ka seleng ho ea ho le letona.
5. Ho lokisa mathata ka mabitso ana, totobatsa lisele tsa D1 le E1 leqepheng la mosebetsi.
6. Tlanya tabeng ea lapeng .
7. Tobetsa konopo ea Wopela Lengolo leboteng .
8. Mabitso a lisele tse D1 le E1 a lokela ho bonahala ka bobeli ka ho feletseng le temana e qhetsoeng ka mela e 'meli e se nang tšilafalo ho lisele tse haufi.

Sehlooho sa mongolo oa sekoahelo sa Excel ke sesebelisoa sa mokhoa o amohelehang o lumellang hore u laole ponahalo ea maele le lihlooho tsa hau ea spreadsheet. Ho e-na le ho atolosa lihlopha tsa maqephe ho etsa lihlooho tse telele li bonahale, ho phuthela mongolo ho u lumella hore u behe litemana meleng e mengata ka seleng e le 'ngoe. Sekapali sa Mongolo oa Excel Mohlala Bakeng sa thuso le mohlala ona, sheba setšoantšo se ka holimo. Ka seleng ea G1 ngola mofuta ona: Tlatsetso ea Khoeli le Khoeli mme u tobetse ENTER ea bohlokoa ka lebokose. Kaha Lekhetho la Khoeli le lelelele bakeng sa seleng ea lona, ​​le tla tšela seleng ea H1. Ka seleng ea H1 ngola mofuta ona: Litsenyehelo tsa Khoeli le Khoeli 'me u tobetse ENTER ka lebokose. Hang ha data e kenngoa ka seleng ea H1, chelete ea pele ea Lekhetho la Khoeli e lokela ho felisoa. Ho lokisa bothata, hula lisele tsa G1 le H1 ho spreadsheet ho li totobatsa. Tlanya tabeng ea lapeng. Tobetsa konopo ea Wopela Lengolo leboteng. Mabitso a lisele tse G1 le H1 joale a lokela ho bonahala ka ho feletseng le taba e senyehileng ka mela e 'meli e se nang tšelo ea lisele ho lisele tse haufi.

Thuto ena e akaretsa mokhoa oa ho thapa melaong e mengata ka har'a sele e le 'ngoe ea likarolo.

Lentsoe "tekanyetso ea teketeki" bakeng sa tšobotsi ena ke ho koahela mongolo 'me motsoako oa sehlooho oa ho phuthela mongolo ke:

Alt + Kena

Mohlala: Sebelisa Litsela tsa Shortcut ho Tlanya Lengolo

Ho sebelisa sesebelisoa sa mongolo sa Excel se sebedisang feela ka lebokose:

1. Tobetsa seleng eo u batlang hore temana e be teng
2. Ngola mola oa pele oa mongolo
3. Tlanya le ho thibela konopo ea Alt ka lebokose
4. Tlanya le ho lokolla konopo ea Kena ka lebokoseng ntle le ho lokolla konopo ea Alt
5. Laolla senotlolo sa Alt
6. Nete ​​ea ho kenya e lokela ho fallela molaong o ka tlaase ho temana e kenngoeng
7. Tlanya molaetsa oa bobeli
8. Haeba o lakatsa ho kenya mela e fetang e 'meli ea mongolo, tsoela pele ho hatisa Alt + Enter qetellong ea mola o mong le o mong
9. Ha temana eohle e kenngoa, tobetsa konopo ea ho kena ho lebokose kapa o tobetsa ka mouse ho ea seleng e 'ngoe

Hape "

03 ho ea ho 27

Kenya Letsatsi la Kajeno

Thupelo ena e akaretsa mokhoa oa ho eketsa ka potlako letsatsi la morao-rao ho ea leqepheng la ho sebelisa lekhotla feela.

Motsoako oa bohlokoa oa ho eketsa letsatsi ke:

Ctrl + ; (senotlolo sa bobeli)

Mohlala: Sebelisa Litsela tsa Shortcut ho Kenya Letsatsi la Kajeno

Ho eketsa letsatsi la morao-rao leqepheng la lipampiri u sebelisa lebokose feela:

1. Tobetsa seleng moo u batlang hore letsatsi le tsamaee.
2. Tlanya le ho thibela konopo ea Ctrl lebokoseng.
3. Tlanya le ho lokolla senotlolo sa mohala-oela ( ; ) holim'a lebokose ntle le ho lokolla senotlolo sa Ctrl.
4. Lokolla senotlolo sa Ctrl.
5. Letsatsi la morao-rao le lokela ho kenngoa ts'ebetsong ea sele ka sele e khethiloeng.

Tlhokomeliso: Leqhoqho lena la li-keyboard ha le sebelise mosebetsi oa TODAY kahoo letsatsi ha le fetohe nako le nako ha leqephe la lipampiri le buloa kapa le khutlisetsoa hape. Hape "

04 ea 27

Tlhaloso ea Sesebelisoa ho Excel Ho Sebelisa Litsela tsa Shortcut

Tlhaloso ea Sesebelisoa ho Excel Ho Sebelisa Litsela tsa Shortcut

Tlhaloso ena e fana ka mokhoa oa ho potlakela ho kenya mosebetsi oa SUM oa Excel ho eketsa lintlha ka ho sebelisa linotlolo tsa mekhoa ea khetho ho keyboard.

Motsoako o ka sehloohong oa ho kenya mosebetsi oa SUM ke:

" Alt " + " = "

Mohlala: Ho kenya Mosebetsi oa SUM o sebelisa Shortcut Keys

1. Kenya data e latelang ka lisele tsa D1 ho ea ho D3 tsa leqephe la Excel: 5, 6, 7
2. Haeba ho hlokahala, tobetsa seleng D4 ho e etsa sele e sebetsang
3. Tlanya le ho thibela konopo ea Alt ka lebokose
4. Tlanya le ho lokolla letšoao le lekanang ( = ) lebokoseng ntle le ho lokolla konopo ea Alt
5. Laolla senotlolo sa Alt
6. Mosebetsi oa SUM o lokela ho kenngoa ka seleng ea D4 ka tekanyo ea D1: D3 e totobatsoang e le khang ea mosebetsi
7. Tobetsa konopo ea Kena ho lebokose ho tlatsa mosebetsi
8. Karabo ea 18 e lokela ho hlaha seleng ea D4
9. Ha o tobetsa ka cell D4 mosebetsi o feletseng = SUM (D1: D3) e hlaha kahare ea foromo ka holim'a leqephe la mosebetsi.

Morero ona o ka sebelisoa ho bokella dintlha ka mela hammoho le mela.

Tlhokomeliso : SUM e etselitsoe ho kenngoa ka tlaase ho kholumo ea data kapa qetellong ea letoto la lintlha.

Haeba mosebetsi oa SUM o kenngoa sebakeng se seng ho tsena tse peli, lisele tsa sele tse khethiloeng e le lintlha tsa mosebetsi li ka 'na tsa fosahetse.

Ho fetola moeli o khethiloeng, sebelisa pointer ea mouse ho totobatsa marang-rang a nepahetseng pele o hatella ho kena ho kena ho tlatsa mosebetsi .

05 ea 27

Ho eketsa Nako ea Hona joale

Thupelo ena e akaretsa mokhoa oa ho potlakela ho eketsa nako ea hona joale ho ea leqepheng la ho sebelisa lebokose feela:

Motsoako oa bohlokoa oa ho eketsa nako ke:

Ctrl + Shift + : ((konopo ea khalone)

Mohlala: Sebelisa Litsela tsa Shortcut ho Eketsa Nako ea Hona Joale

Ho eketsa nako ea hona joale ho leqephe la lipampiri u sebelisa lebokose feela:

1. Tobetsa seleng eo u batlang nako ea ho ea ho eona.
   
   
2. Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng.
   
   
3. Tlanya le ho lokolla konopo ea colone (:) lebokoseng ntle le ho lokolla likheo tsa Ctrl le Shift .
   
   
4. Nako ea hona joale e tla ekeletsoa spreadsheet.
   
   

Tlhokomeliso: Tsamaiso ena ea keyboard ha e sebelise MOSEBETSI OA MOSEBETSI kahoo letsatsi ha le fetohe nako le nako ha leqephe la lipampiri le buloa kapa le khutlisetsoa hape.

Mesuoe e meng ea Shortcut Keys Tutorials

• E eketsa Letsatsi la Kajeno
• Khetha lisele tse sa tloaelehang ho Excel
• ALT - TAB Ho fetola Windows

Hape "

06 ea 27

Kenya Hyperlink

Kenya Hyperlink ho Excel Ho Sebelisa Litsela tsa Shortcut

Thuto e amanang : Kenya Li-Hyperlink le Bookmarks ho Excel

Tlhaloso ena ea Excel e akaretsa mokhoa oa ho potlakela ho kenya li-hyperlink bakeng sa mongolo o khethiloeng ka mefuta e fokolang ho Excel.

Motsoako o ka sehloohong o ka sebelisoang ho kenya hyperlink ke:

Ctrl + k

Mohlala: kenya Hyperlink ho sebelisa Shortcut Keys

Bakeng sa thuso ka litaelo tsena tobetsa setšoantšo se ka holimo

1. Lethathamong la lipampiri la Excel qaqanya seleng ea A1 ho e etsa sele e sebetsang
2. Tšoaea lentsoe ho sebetsa ka mokhoa o tšoanang le li- spreadsheets le ho kenya konopo ea ho kenya lebokoseng
3. Tobetsa seleng ea A1 ho boela u e etse sele e sebetsang
4. Tlanya le ho thibela konopo ea Ctrl lebokoseng
5. Tlanya le ho lokolla lengolo ( k ) senotlolo ho lebokose ho bula lebokose la boitsebiso la Insert Hyperlink
6. Ho Aterese: mola o ka tlaase oa mofuta oa lebokose la lebokose la URL e feletseng e kang:
   http://spreadsheets.about.com
   
7. Tobetsa Ok ho tlatsa li-hyperlink mme u koale lebokose la lebokose
8. Mantsoe a anchor ka seleng ea A1 e lokela ho ba 'mala o moputsoa' me a behiloe ka ho hlaka e bontšang hore o na le hyperlink

Ho leka Hyperlink

1. Beha pointer ea mouse holim'a li-hyperlink ka seleng ea A1
2. Pointer ea motsu e lokela ho fetoha letsohong la letsohong
3. Tobetsa tokomaneng ea anchor ea hyperlink
4. Sebaka sa hau sa marang-rang se lokela ho buleloa leqepheng le khethiloeng ke URL

Tlosa Hyperlink

1. Beha pointer ea mouse holim'a li-hyperlink ka seleng ea A1
2. Pointer ea motsu e lokela ho fetoha letsohong la letsohong
3. Tobetsa ka ho toba tokomaneng ea anchor ea hyperlink ho bula menu ea Context dropdown
4. Tobetsa ho Tlosa khetho ea Hyperlink ho menu
5. Mmala o moputsoa le molaetsa o ka tlaase o lokela ho tlosoa molaong oa anchor o bontšang hore hyperlink e tlosoa

Liqeto tse ling tsa Keyboard

Etsa tlhahlobo ea chelete

Ho Sebelisa Litlhaku ho Etsahala

Kenya mabanta a Excel

Hape "

07 ea 27

Bontša liforomo

Monyetla o ka sehloohong o ka sebelisoang ho bontša litlhahlobo ke: Ctrl + `(khalase ea molumo o ka sehloohong) Litsinakong tse ngata tse tloaelehileng, senotlolo sa molumo o moholo se teng haufi le senotlolo sa nomoro 1 karolong e ka holimo le letšehali ea lebokose mme e shebahala morao apostrophe. Bontša liforomo tse sebelisang Shortcut Keys Mohlala Tlosa 'me u tšoare konopo ea Ctrl lebokoseng Tlanya le ho lokolla konopo ea molumo (``) ea bohlokoa ka lebokoseng ntle le ho lokolla senotlolo sa Ctrl Lokolla khefu ea Ctrl Mabapi le bonts'oetso Bontša likhahla ha li fetole spreadsheet, feela tsela eo e bonts'itsoeng ka eona. Ho nolofalletsa ho fumana lisele tse nang le litompe Ho u lumella ho bala ka potlako mekhoa eohle ho hlahloba liphoso Ha u tobetsa foromo, Excel e kentse ka 'mala ka litlhaloso tsa sele tse sebelisoang ka mokhoa ona. Sena se u thusa hore u bone hore na data e sebelisitsoe joang. Hatisa liphatlalatso tse nang le liforomo tsa ho bonts'etsa. Ho etsa joalo, ho tla u lumella hore u batle spreadsheet ka thata ho fumana liphoso. Hape "

08 ea 27

Excel Shortcut Keys - Hlakola

Tlhahiso ena ea khetho ea bohlokoa ea Excel e bontša kamoo u ka "etsollang" liphetoho tse entsoeng tlhahiso ea Excel.

Tataiso e amanang: Sehlooho sa ho hlahisa Excel .

Tlhokomeliso: Ke habohlokoa ho hopola hore ha o sebelisa Tlosa, e "etsolla" liketso tsa hau ka tatellano e tobileng eo ue sebelisitseng.

Motsoako oa senotlolo oa khetho o sebelisetsoang ho "fetola" liphetoho ke:

• Ctrl + " Z "

Mohlala oa ho Fetola Liphetoho ho sebelisa Litsela tsa Shortcut

1. Tlanya boitsebiso bo itseng ka seleng , e kang A1 ka spreadsheet mme o tobetsa Enter key ho lebokose.
   
   
2. Tobetsa seleng eo ho e etsa hore e be sele e sebetsang .
   
   
3. Tobetsa Tabeng ea Lehae ea Ribbon .
   
   
4. Sebelisa dikgetho tse latelang tsa fomati ho data ya hau:
   • fetola 'mala oa mebala,
   • atolosa mohala,
   • ho totobatsa,
   • fetola mofuta oa fonte ho Arial Black,
   • bohareng ho lumellana le data
   
   
5. Tlanya le ho thibela konopo ea Ctrl lebokoseng.
   
   
6. Tlanya le ho lokolla lengolo " Z " lebokoseng.
   
   
7. Lintlha tse seleng li lokela ho fetohela ho khutlela ka letsohong le letšehali ha phetoho ea ho qetela (kopano e bohareng) e senoloa.
   
   
8. Tlanya le ho thibela konopo ea Ctrl hape ka lebokose.
   
   
9. Tlanya le ho lokolla lengolo " Z " lebokoseng ka makhetlo a mabeli ntle le ho lokolla senotlolo sa Ctrl .
   
   
10. Hase molaetsa o tla tlosoa feela empa fonte ha e sa tla hlola e e-ba Arial Black.
    
    
11. Sena se etsahala hobane, joalokaha ho boletsoe ka holimo, ketsahalo e hlalosang "e senya" liketso tsa hau ka tatellano e tobileng eo u e sebelisitseng.
    
    

Tse ling tsa Tutorials tsa Shortcut Keys Tutorials

• Ho eketsa Nako ea Hona joale
• Khetha lisele tse sa tloaelehang ho Excel
• ALT - TAB Fast Switching Windows

Hape "

09 ea 27

Ho Khetha Lisele tse sa Neng tse Ncha

Khetha lisele tse sa tloaelehang ho Excel

Tutorial e amanang: Khetha Lisele Tse sa Neng Tse Sebelisang Sebelisa Keyboard le Mouse

Ka ho khetha lisele tse ngata Excel u ka tlosa data, sebelisa mekhoa e kang meeli kapa shading, kapa u sebelise mekhoa e meng libakeng tse kholo tsa leqephe ka nako e le 'ngoe.

Ka linako tse ling lisele tsena ha li sebakeng se iketselitseng. Maemong ana ho khoneha ho khetha lisele tse seng tse haufi.

Sena se ka etsoa ho sebelisa lebokose le mouse hammoho kapa ho sebelisa lebokose feela.

Ho sebelisa Sebopeho ka Tsela e Eketsehileng

Ho khetha lisele tse seng haufi tse nang le lebokose feela ho hloka hore u sebelise lebokose ka Extended Mode .

Boemo bo fetisitsoeng bo nkiloe ka ho hatisa senotlolo sa F8 lebokoseng. U koala mokhoa o atolositsoeng ka ho hatisa lintlha tsa Shift le F8 lebokoseng hammoho.

Khetha lisele tse se nang moeli tse sa tloaelehang ka Excel U sebelisa lebokose

1. Tlosa selenete ho sele ea pele eo u batlang ho e khetha.
2. Tlanya le ho lokolla senotlolo sa F8 lebokoseng ho qala Mode e fetisitsoeng le ho totobatsa sele ea pele.
3. Ntle le ho sisinya sele, khetha 'me u lokolle linotlolo tsa Shift + F8 lebokoseng hammoho ho koala mokhoa o atolositsoeng.
4. Sebelisa linotlolo tsa motsu ka lebokose ho tlosa sele ea sele ho seleng e latelang eo u lakatsang ho e totobatsa.
5. Sese ea pele e lokela ho lula e totobetse.
6. Ka sele ea sele ho seleng e hlahlamang e lokelang ho totobatsoa, ​​pheta mehato ea 2 le ea 3 ka holimo.
7. Tsoela pele ho eketsa lisele ho lebalo le totobetseng ka ho sebelisa linotlolo tsa F8 le Shift + F8 ho qala le ho emisa mokhoa o atolositsoeng.

Ho khetha Lisele tse Ncha le Tse sa Neng ho Excel Ho Sebelisa Keyboard

Latela mehato e ka tlase haeba tekanyo eo u lakatsang ho e khetha e na le motsoako oa lisele tse haufi le tsa motho joalokaha li bontšitsoe setšoantšong se ka holimo.

1. Tlosa selenete ho sele ea pele sehlopheng sa lisele tseo u batlang ho li totobatsa.
2. Tlanya le ho lokolla senotlolo sa F8 ka lebokose ho qala Mode e fetisitsoeng .
3. Sebelisa lintlha tsa motsu ka lebokose ho atolosa marang-rang a totobetseng ho kenyelletsa lisele tsohle tsa sehlopha.
4. Le lisele tsohle tsa sehlopha se khethiloeng, tobetsa le ho lokolla linotlolo tsa Shift + F8 lebokoseng hammoho ho koala mokhoa o atolositsoeng.
5. Sebelisa linotlolo tsa motsu ka lebokose ho tlosa cell phone ho sehlopha sa sele tse khethiloeng.
6. Sehlopha sa pele sa lisele se lokela ho lula se totobatsoe.
7. Haeba ho na le lihlopha tse ngata tse arohaneng tseo u lakatsang ho li totobatsa, fallela seleng ea pele sehlopheng 'me u phete mehato ea 2 ho isa ho 4 ka holimo.
8. Haeba ho na le lisele tse ling tseo u lakatsang ho li eketsa lethathamong le hlalositsoeng, sebelisa litaelo tsa pele tsa litaelo tse ka holimo bakeng sa ho totobatsa lisele tse le 'ngoe.

Hape "

10 ho ea ho 27

Khetha lisele tse sa tloaelehang ka Excel le Keyboard le Mouse

Thuto e amanang le eona: Ho khetha lisele tse seng tse tloaelehileng ho sebelisa lebokose

Ka ho khetha lisele tse ngata Excel u ka tlosa data, sebelisa mekhoa e kang meeli kapa shading, kapa u sebelise mekhoa e meng libakeng tse kholo tsa leqephe ka nako e le 'ngoe.

Ha u ntse u sebelisa mokhoa oa ho hula u sebelisa mouse ho potlakela ho totobatsa lebenkele la lisele tse haufi le mohlomong e le tsela e tloaelehileng ka ho fetisisa ea ho khetha seleng e le 'ngoe, ho na le linako tseo lisele tseo u batlang ho li totobatsa li sa fumaneha ka thōko.

Ha sena se etsahala, hoa khoneha ho khetha lisele tse seng tse haufi. Le hoja ho khetha lisele tse seng tse haufi li ka etsoa feela ka keyboard , ho bonolo ho li sebelisa ka lebokose le mouse.

Ho khetha lisele tse sa tloaelehang ho Excel

Bakeng sa thuso ka mohlala ona, sheba setšoantšo se ka holimo.

1. Tobetsa seleng ea pele eo u batlang ho e khetha ka pointer ea mouse ho e etsa sele e sebetsang .
   
   
2. Lokolla konopo ea mouse.
   
   
3. Tlanya le ho thibela konopo ea Ctrl lebokoseng.
   
   
4. Tobetsa lisele tse ling tseo u batlang ho li khetha ntle le ho lokolla senotlolo sa Ctrl .
   
   
5. Hang ha lisele tsohle tse lakatsehang li khethoa, lokolla senotlolo sa Ctrl .
   
   
6. U se ke ua tobetsa kae kapa kae ka pointer ea mouse ha u se u lokolla senotlolo sa Ctrl kapa u tla hlakola lintlha tse hlakileng ho tloha lisele tse khethiloeng.
   
   
7. Haeba u lokolla senotlolo sa Ctrl haufinyane 'me u lakatsa ho totobatsa lisele tse ling, feela tobetsa le ho thibela lekhotla la Ctrl hape ebe o tobetsa lisele tse eketsehileng.
   
   

Mesuoe e meng ea Shortcut Keys Tutorials

• Ho eketsa Nako ea Hona joale
• E eketsa Letsatsi la Kajeno
• ALT - TAB Fast Switching Windows

Hape "

11 ho ea ho 27

ALT - TAB Ho fetola Windows

Hase feela khetho ea Excel, ALT - TAB Switching ke tsela e potlakileng ea ho falla pakeng tsa litokomane tsohle tse bulehileng ka Windows (Win key + Tab ka Windows vista).

Ho sebelisa keyboard ho phetha mosebetsi ka khomphuteng hangata ho atleha haholo ho feta ho sebelisa mouse kapa lisebelisoa tse ling tse hlalosang, 'me ALT-TAB Ho senya ke e' ngoe ea li-shortcuts tsena tse sebelisoang ka ho fetisisa.

Ho sebelisa ALT - TAB Ho tsuba

1. Bonyane bonyane lifaele tse peli ho Windows. Tsena li ka ba lifaele tse peli tsa Excel kapa File Excel le file Microsoft Word ka mohlala.
   
   
2. Tlanya le ho thibela konopo ea Alt ka lebokose.
   
   
3. Tlanya le ho lokolla konopo ea Thabiso ho lebokose ho sa lumelle ho ea ka senotlolo sa Alt .
   
   
4. Alt - TAB fensetere e potlakileng ea ho fetoha e lokela ho hlaha bohareng ba skrine ea hau ea khomphuta.
   
   
5. Fensetere ena e lokela ho ba le letšoao la tokomane e 'ngoe le e' ngoe e sebelisoang khomphuteng.
   
   
6. Letšoao la pele ka letsohong le letšehali le tla ba la tokomane ea hona joale - e bonahalang skrineng.
   
   
7. Setšoantšo sa bobeli ho tloha ka letsohong le letšehali se lokela ho totobatsoa ke lebokose.
   
   
8. Ka tlase litšoantšong e lokela ho ba lebitso la tokomane e bontšitsoeng lebokoseng.
   
   
9. Laolla senotlolo sa Alt mme lifensetere li u fetisetsa tokomaneng e totobetseng.
   
   
10. Ho fallela litokomaneng tse ling tse bontšitsoeng ka fensetere ea ALT - TAB Fast Switching, tsoela pele ho emisa Alt ha u ntse u tlanya konopo ea Taba . Tlou e 'ngoe le e' ngoe e lokela ho tsamaisa lebokose le tobileng le letšehali ho tloha ho tokomane e '
    
    
11. Laolla senotlolo sa Alt ha tokomane e lakatsehang e totobatsoa.
    
    
12. Hang ha ALT - TAB Fast Switching fensetere e bulehile, o ka fetola tsela ea lebokose le totobetseng - o e fetisetsa ho tloha ho le letona ho ea ka letsohong le letšehali - ka ho beha thepa ea Shift hammoho le Alt key ebe o tlanya konopo ea Tab .

Liqeto tse ling tsa Keyboard

• Ho eketsa Nako ea Hona joale
• E eketsa Letsatsi la Kajeno
• Pata Lipolomo ka Excel

Hape "

12 ho ea ho 27

Excel ea Go To Feature

Thuto e amanang: Excel Lebitso la Lebokose .

Go Go To feature in Excel e ka sebelisoa ho potlakela ho ea lisele tse fapaneng ka spreadsheet . Sehlooho sena se kenyelletsa mohlala oa kamoo u ka sebelisang Go to feature hore u fallele liseleng tse fapaneng u sebelisa khetho ea keyboard.

Le hoja ho sa hlokahale bakeng sa lipampiri tse sebelisang mela e seng mekae le mela e seng mekae feela, bakeng sa maqephe a maholoanyane a ho sebetsa ho ka ba molemo ho ba le litsela tse bonolo tsa ho theoha ho tloha sebakeng se itseng sa mosebetsi oa hau ho ea ho o mong.

Ho etsa hore Go e kenye letsoho ka keyboard, tobetsa konopo ea F5

Mohlala o sebelisang Excel's Go To feature for Navigation:

1. Tobetsa konopo ea F5 lebokoseng ho hlahisa lebokose la ho ea ho dialog.
2. Tšoaea ka selefouno ea sele ea sebaka seo u se batlang ho Reference line ea lebokoseng la lebokose. Tabeng ena: HQ567 .
3. Tobetsa konopo ea OK kapa tobetsa ENTER ka lebokose.
4. Lebokose le letšo le potolohileng sele e sebetsang le lokela ho qhomela seleng ea HQ567 ho e etsa sele e ncha e sebetsang.
5. Ho fallela seleng e 'ngoe, pheta mehato ea 1 ho ea ho ea 3.

Tutorials tse amanang

• Excel Lebitso la Lebokose
• Litlhaloso tsa Cell ka Litlhahlobo
• Ho eketsa Hyperlinks le Bookmarks ho Excel

Hape "

13 ho ea ho 27

Excel Tlatsa Tlaetso ea Tlase

Haeba o hloka ho kenya data e tšoanang - melaetsa kapa linomoro - ho lisele tse ngata tse haufi le molaleng , taelo ea Fill Down e ka potlakela ho u etsetsa eona ka ho sebelisa lebokose feela.

Tlhahiso ena ea Excel e bontša kamoo u ka sebelisang taelo ea tlatsa Fumaneha ho Excel spreadsheet u sebelisa leqhoa-le-leng la keyboard.

Motsoako o ka sehloohong o sebetsang ho tlatsa taelo ke:

• Ctrl + D

Mohlala: Sebelisa Tlatsa ka Shortcut Shortcut

Bakeng sa thuso ka mohlala ona, sheba setšoantšo se ka holimo.

1. Ngola nomoro, e kang 395.54 ka seleng ea D1 ho Excel.
   
   
2. Tšoaea ebe u tšoara konopo ea Shift lebokoseng
3. Tlanya le ho tiisa konotlolo ea Down Arrow ka lebokose ho atolosa lintlheng tsa sele ho tloha seleng D1 ho ea D7.
4. Lokolla lintlha tsa bobeli.
5. Tlanya le ho thibela konopo ea Ctrl lebokoseng.
6. Tlanya le ho lokolla senotlolo sa " D " lebokoseng.
7. Lisele tse D2 ho D7 li lokela ho tlala hona joale le data e tšoanang le ea cell D1.

Liqeto tse ling tsa Keyboard

• Excel Hlahisa
• E eketsa Letsatsi la Kajeno
• Ho fetola Letsatsi

Hape "

14 ho ea ho 27

Ho Sebelisa Litlhaku ho Etsahala

Tlhahiso ena ea Excel e bonts'a kamoo u ka sebelisang litlhaloso ka ho sebelisa mekhoa ea Shortcut lebokoseng.

Ho na le mekhoa e 'meli ea bohlokoa e ka sebelisoang ho eketsa kapa ho tlosa melaetsa ea litlama ho data:

• Linotlolo tsa " C " " Ke "
• Linotlolo tsa " Ctrl " " 3 "

Mohlala: Sebelisa Litsela tsa Shortcut ho Sebelisa Litlhaku

Bakeng sa thuso ka mohlala ona, sheba setšoantšo ka ho le letona.

1. Ngola boitsebiso bo itseng ka seleng , e kang E1 ka spreadsheet 'me u tobetse ho kenya konopo lebokoseng.
   
   
2. Tobetsa seleng eo ho e etsa hore e be sele e sebetsang .
   
   
3. Tlanya le ho thibela konopo ea Ctrl lebokoseng.
   
   
4. Tlanya le ho lokolla lengolo " I " lebokoseng.
   
   
5. Litlhaku tse entsoeng ka setlama li lokela ho sebelisoa ho data e seleng.
   
   
6. Tlanya le ho lokolla linotlolo tsa Ctrl + " I " hape ho tlosa mekhoa ea litlama.
   
   

Liqeto tse ling tsa Keyboard

• Kenya Nako ea Hona Joale
• Khetha lisele tse sa tloaelehang ho Excel
• ALT - TAB Fast Switching Windows

15 ho ea ho 27

Etsa kopo ea ho fomisa nomoro

Thupelo ena e akaretsa mokhoa oa ho sebelisa boitsebiso ba nomoro ho lisele tse khethiloeng tse sebelisang lebokose feela:

Mekhoa ea nomoro e sebelisitsoeng ho data e khethiloeng ke:

• libaka tse peli tsa decimal
• sekhetho se le sekhetho sa likete (,)
• letšoao le fokolang (-) bakeng sa litekanyetso tse fosahetseng

Motsoako o ka sehloohong o ka sebelisoang ho sebelisa mokhoa oa ho etsa lichelete ho data ke:

Ctrl + Shift + ! (tlhaloso ea ntlha)

Mohlala: Sebelisa Litsela tsa Shortcut ho Sebelisa Phatlalatso ea Numom

Mohlala ona o bontšoa setšoantšong se ka holimo

1. Kenya data e latelang ho lisele tse A1 ho A4:
   4578.25102 45782.5102 457825.102 4578251.02
2. Totobolla lisele tsa A1 ho A4 ho li khetha
3. Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng
4. Tlanya le ho lokolla senotlolo sa polelo ( ! ) Lebokoseng ntle le ho lokolla linotlolo tsa Ctrl le Shift
5. Lokolla likheo tsa Ctrl le Shift
6. Linomoro tsa lisele tse A1 ho ea ho A4 li lokela ho etsoa kaofela ho bonts'a libaka tse peli feela tsa maemo a mararo, le hoja lipalo tse ngata li na le tse fetang tse peli
7. Lisele li lokela ho ba le sekhetho se kenyelletsoeng e le sekhetho sa likete
8. Ho tobetsa ho lisele leha e le efe ho bonts'a nomoro ea pele e sa elelloang lebota la foromo ka holim'a leqephe la mosebetsi

Liqeto tse ling tsa Keyboard

• E eketsa Letsatsi la Kajeno
• Ho eketsa Nako ea Hona joale
• ALT - TAB Fast Switching Windows

Hape "

16 ho ea ho 27

Etsa tlhahlobo ea chelete

Thupelo ena e akaretsa kamoo ho ka sebelisoang ka potlako chelete ea ho etsa lichelete ho lisele tse khethiloeng ho sebelisa lebokose feela:

Motsoako o ka sehloohong o ka sebelisoang ho sebelisa mokhoa oa ho etsa lichelete ho data ke:

• Ctrl + Shift + 4

Mohlala: Sebelisa Litsela tsa Shortcut ho Sebelisa Tlhahiso ea Chelete

Bakeng sa thuso ka mohlala ona, sheba setšoantšo ka ho le letona.

1. Eketsa lintlha tse latelang ho lisele tsa A1 ho ea ho B2: 7.98, 5.67, 2.45, -3.92
   
   
2. Etsa likheo tsa A1 ho B2 ho li totobatsa.
   
   
3. Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng.
   
   
4. Tlanya le ho lokolla nomoro ea bone ( 4 ) lebokoseng ntle le ho lokolla linotlolo tsa Ctrl le Shift .
   
   
5. Lisele tse A1, A2, le B1 letšoao la dollar ( $ ) li lokela ho kenngoa boitsebiso.
   
   
6. Ka cell B2, hobane data ke nomoro e fosahetseng, e lokela ho ba khubelu le ho pota-potiloe ke li-brackets ho phaella ho ba le letšoao la dollar ( $ ) e kenyelitsoeng.
   
   

Liqeto tse ling tsa Keyboard

• E eketsa Letsatsi la Kajeno
• Ho eketsa Nako ea Hona joale
• ALT - TAB Fast Switching Windows

Hape "

17 ho ea ho 27

Etsa tlhahiso ea Percent

Tlhahiso ena ea Excel e akaretsa ho sebelisa mefuta e fapaneng ea lisebelisoa ho lisele tse khethiloeng ho Excel spreadsheet ho sebelisa lihlooho tse fokolang lebokoseng.

Motsoako o ka sehloohong o ka sebelisoang ho sebelisa mokhoa oa ho etsa lichelete ho data ke:

• Ctrl + Shift + 5

Mohlala oa Tlhahlobo ea Percent ka Sebeliso ea Metsotso

Bakeng sa thuso ka mohlala ona, sheba setšoantšo se ka holimo.

1. Kenya data e latelang ho lisele tse A1 ho ea ho B2: .98, -.34, 1.23, .03
   
   
2. Etsa likheo tsa A1 ho B2 ho li totobatsa.
   
   
3. Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng.
   
   
4. Tlanya le ho lokolla lenane la tse hlano ( 5 ) lebokoseng ntle le ho lokolla likheo tsa Ctrl le Shift .
   
   
5. Lisele tse A1 ho ea ho B2 data e lokela ho fetoloa ho karolo lekholong ka pontšo ea lekholong ( % ) e fetiselitsoeng ho data.

Mesuoe e meng ea Shortcut Keys Tutorials

• Etsa tlhahlobo ea chelete
• Ho Sebelisa Litlhaku ho Etsahala
• Kenya mabanta a Excel

Hape "

18 ho ea ho 27

Khetha Lisele tsohle ho Excel Data Data

Tlhaloso ena ea Excel e akaretsa mokhoa oa ho khetha lisele tsohle tsa tafoleng ea data ea Excel ho sebelisa tsela e khutšoanyane ea lebokose. Ho etsa joalo ho tla u lumella hore u sebelise liphetoho tse kang ho etsa li-formatting, bophara ba likarolo, joalo-joalo ho setsheeteng hang-hang.

Sehlooho se amanang: Ho theha Letlapa la Data ka Excel .

Tlhokomeliso: Bakeng sa thuso ka mohlala ona, sheba setšoantšo ka ho le letona.

Mohlala oa Tsela ea ho Khetha Lisele tsohle ho Letlapa la Ditaba

1. Bula sephetho sa lipampiri tsa Excel tse nang le tafole ea data kapa ho etsa tafole ea data .
   
   
2. Tobetsa seleng efe kapa efe tafoleng ea data.
   
   
3. Tlanya le ho thibela konopo ea Ctrl lebokoseng.
   
   
4. Tlanya le ho lokolla lengolo la " A " lekaleng ntle le ho lokolla senotlolo sa Ctrl .
   
   
5. Lisele tsohle tse tafoleng ea data li lokela ho totobatsoa.
   
   
6. Tlanya le ho lokolla lengolo " A " ka lekhetlo la bobeli.
   
   
7. Sehlooho sa sehlooho sa tafole ea data se lokela ho totobatsoa hammoho le tafoleng ea data.
   
   
8. Tlanya le ho lokolla lengolo " A " ka lekhetlo la boraro.
   
   
9. Lisele tsohle tse hlahang mosebetsing li lokela ho totobatsoa.

Liqeto tse ling tsa Keyboard

• Khetha lisele tse sa tloaelehang ho Excel
• Kenya mabanta a Excel
• Pata Lipolomo ka Excel

Hape "

19 ho ea ho 27

Khetha Tsela e Ntle ho Excel U Sebelisa Metsotso e Shortcut

Khetha Meeli Leqepheng la Mosebetsi

Tlhaloso ena ea Excel e akaretsa ho potlakela ho khetha kapa ho totobatsa mola o feletseng ka har'a leqephe ka lihlooho tsa mekhoa ea khetho ho keyboard.

Motsoako o ka sehloohong o sebelisetsoang ho khetha moeli ke:

BONTŠA + SPACEBAR

Mohlala: Ho Sebelisa Metsotso ea Shortcut ho Khetha Tsela e Ntle ea Mosebetsi

1. Bula Excel Worksheet - ha ho hlokahale hore ho be le data e teng hona joale
2. Tobetsa seleng kahare - e kang A9 - ho e etsa sele e sebetsang
3. Tlanya le ho thibela key SHIFT lebokoseng
4. Tlanya le ho lokolla senotlolo sa SPACEBAR lebokoseng ntle le ho lokolla senotlolo sa SHIFT
5. Lokolla key SHIFT
6. Lisele tsohle tse ka lethathamong le khethiloeng li lokela ho totobatsoa - ho akarelletsa le sehlooho sa mola

Hape "

20 ho ea ho 27

Boloka ho Excel

Excel Boloka Save Shortcut Keys

Tlhaloso ena ea Excel e akaretsa mokhoa oa ho boloka dintlha ka potlako ka mefuta e fokolang ho keyboard ho Excel.

Motsoako o ka sehloohong o ka sebelisoang ho boloka dintlha ke:

Ctrl + S

Mohlala: Sebelisa Litsela tsa Shortcut tsa ho Boloka Lethathamo la Mosebetsi

1. Tlanya le ho thibela konopo ea Ctrl lebokoseng
2. Tlanya le ho lokolla senotlolo ( S ) ka lebokoseng ntle le ho lokolla senotlolo sa Ctrl
3. Lokolla senotlolo sa Ctrl

Boloka nako ea pele

Haeba u kile ua boloka leqephe la lipampiri feela pontšo ea hore Excel e boloka faele ea hau e ka 'na ea e-ba pointer ea mouse e fetotsana hanyenyane ka letšoao la hourglass ebe joale o khutlela setšoantšong se tloaelehileng se tšoeu.

Nako ea nako ea letšoao la hourglass e lula e bonahala ho itšetlehile ka palo ea data Excel e lokela ho boloka. Ha boholo ba data bo bolokiloe, setšoantšo sa hourglass se tla bonahala nako e telele.

Haeba o boloka leqephe la pele ka lekhetlo la pele lebokose la lebokose la Save As le tla bula.

Ha faele e bolokiloe ka lekhetlo la pele likarolo tse peli tsa boitsebiso e tlameha ho boleloa lebokoseng la Save As dialog:

• lebitso la faele (ho fihlela ho litlhaku tse 255 tse kenyelletsang libaka)
• sebaka (fensetere) moo file e tla bolokoa teng

Boloka Hangata Hangata

Ho tloha ka ho sebelisa linotlolo tsa khethoa tsa Ctrl + S ke tsela e bonolo ea ho boloka data ke khopolo e ntle ea ho boloka hangata - bonyane metsotso e meng le e meng e mehlano - ho qoba ho lahleheloa ke data ha ketsahalo ea k'homphieutha e senyeha. Hape "

21 ho ea ho 27

Pata le ho kopanya li-columns le melapo ka Excel

22 ho ea 27

Ho fetola Letsatsi

Tlhahiso ena ea Excel e bontša kamoo u ka fomang letsatsi kateng (letsatsi, khoeli, mofuta oa selemo) ho Excel spreadsheet u sebelisa leqhoa-le-leng la keyboard.

Ho fetola Letsatsi ka ho sebelisa Keyboard Shortcut

1. Eketsa letsatsi le lakatsehang la seleng ho Excel spreadsheet.
   
   
2. Tobetsa seleng ho e etsa sele e sebetsang .
   
   
3. Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng.
   
   
4. Tlanya le ho lokolla senotlolo sa nomoro ( # ) lebokoseng ntle le ho lokolla linotlolo tsa Ctrl le Shift .
   
   
5. Letsatsi le sele e sebetsang le tla etsoa ka letsatsi, khoeling le selemo.
   
   

Liqeto tse ling tsa Keyboard

• E eketsa Letsatsi la Kajeno
• Ho eketsa Nako ea Hona joale
• ALT - TAB Fast Switching Windows

Hape "

23 ho ea ho 27

Ho theha Nako ea Hona Joale

Tlhahiso ena ea Excel e bontša kamoo u ka fomang nako ea hona joale (hora, metsotso, le AM ​​/ PM format) ho Excel spreadsheet u sebelisa leqhoa-le-leng la keyboard.

Ho fetola Nako ea Hona Joale ho sebelisa Keyboard Shortcut

1. Sebelisa mosebetsi oa NOW ho eketsa letsatsi la nako le nako ea seleng ea D1.
   
   
2. Tobetsa seleng D1 ho e etsa sele e sebetsang .
   
   
3. Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng.
   
   
4. Tlanya le ho lokolla palo e 'meli ( 2 ) lebokoseng ntle le ho lokolla linotlolo tsa Ctrl le Shift .
   
   
5. Mosebetsi o teng hona joale ka seleng ea D1 o tla hlophisoa hore o bontše nako ea hona joale ka hora, metsotso le AM ​​format ea PM.
   
   

Liqeto tse ling tsa Keyboard

• Excel Hlahisa
• E eketsa Letsatsi la Kajeno
• Ho fetola Letsatsi

Hape "

24 ho ea ho 27

Fetola lipakeng tsa lipampiri

E le mokhoa o mong oa ho sebelisa mouse, ho bonolo ho sebelisa leqhoa la keyboard ho fetola pakeng tsa lipampiri tsa Excel.

Litsinotlolo tse sebelisitsoeng ke sesebelisoa sa CTRL hammoho le PGUP (leqephe hodimo) kapa key PGDN (leqepheng le)

Mohlala - Fetola Pakeng tsa Li-Worksheet ka Excel

Ho ea ka ho le letona:

1. Tlanya le ho boloka konopo ea CTRL lebokoseng.
2. Tlanya le ho lokolla letšoao la PGDN (leqepheng la) ho lebokose.
3. Ho tsamaisa leqhekele le leng ho ea lethatong le nepahetseng le ho lokolla senotlolo sa PGDN ka lekhetlo la bobeli.

Ho ea ka ho le letšehali:

1. Tlanya le ho boloka konopo ea CTRL lebokoseng.
2. Tlanya le ho lokolla senotlolo sa PGUP (leqepheng la) ho lebokose.
3. Ho tsamaisa lekhasi le leng ho mochini o letšehali 'me u lokolle khefu ea PGUP ka lekhetlo la bobeli.

Liqeto tse ling tsa Keyboard

• Pata Lipolomo ka Excel
• Pata mela ho Excel
• E eketsa Letsatsi la Kajeno

Tlhokomeliso: Ho khetha lipampiri tse ngata tse sebelisang lebokose, tobetsa: Ctrl + Shift + PgUp ho khetha maqephe ka ho le letšehali Ctrl + Shift + PgDn ho khetha maqephe ka ho le letona More »

25 ho ea ho 27

Hlahisa Lisele tse nang le F2 Function Key

Excel Hlakola Lisele tsa Shortcut Key

Sehlooho sa tshebetso F2 se u lumella hore u fetole lintlha tsa cell ka potlako le habonolo ka ho kopa mokhoa oa ho fetolela oa Excel le ho beha ntlha ea ho kenya qetellong ea lisele tse sebetsang tse teng.

Mohlala: Ho sebelisa F2 Key ho Fetola Tse ka Hare

Mohlala ona o akaretsa mokhoa oa ho fetola foromo ho Excel

1. Kenya data e latelang ka lisele 1 ho D3: 4, 5, 6
2. Tobetsa ho cell E1 ho e etsa sele e sebetsang
3. Kenya mokhoa ona o latelang ka seleng ea E1:
   = D1 + D2
4. Tobetsa konopo ea Kena ho lebokose ho tlatsa foromo - karabo 9 e lokela ho hlaha seleng ea E1
5. Tobetsa ho cell E1 ho boela u e etse sele e sebetsang
6. Tobetsa konopo ea F2 lebokoseng
7. Excel e kene ka mokhoa oa ho fetola 'me ntlha e kenngoa e behoa qetellong ea foromo ea hona joale
8. Fetola foromo ka ho eketsa + D3 ho ea qetellong ea eona
9. Tobetsa konopo ea Kena ho lebokose ho tlatsa foromo le ho tlohela mochini oa ho fetola - palo e ncha ea foromo - 15 - e lokela ho hlaha ka seleng ea E1

Tlhokomeliso: Haeba kgetho ea ho lumella ho hlophisa ka ho toba liselefatsong e tima, ho hatella senotlolo sa F2 ho sa ntsane ho beha Excel ka mokhoa oa ho fetola, empa ntlha e kenngoa e tla isoa lebaleng la foromo holimo ho leqephe la mosebetsi e le hore o hlophise lintlha tsa sele. Hape "

26 ho ea ho 27

Khetha Lisele tsohle ho Excel Worksheet

27 ho ea ho 27

Kenya meeli

Tlhaloso ena ea Excel e akaretsa mokhoa oa ho eketsa moeli ho lisele tse khethiloeng ho Excel spreadsheet u sebelisa leqhoa-lekha la lebokose.

Thuto e amanang: Ho eketsa / Ho fetisa Meeli ea Excel .

Motsoako oa bohlokoa oa ho eketsa nako ke:

Ctrl + Shift + 7

Mohlala oa Tsela ea ho eketsa marang-rang ho sebelisa Keyboard Shortcut

Bakeng sa thuso ka mohlala ona, sheba setšoantšo ka ho le letona.

1. Kenya lipalo 1 ho isa ho 9 ka lisele tse D2 ho ea ho F4.
   
   
2. Etsa likheo tsa D2 ho F4 ho li totobatsa.
   
   
3. Tlanya le ho thibela linotlolo tsa Ctrl le Shift lebokoseng.
   
   
4. Tlanya le ho lokolla lenane la bosupa ( 7 ) lebokoseng ntle le ho lokolla likheo tsa Ctrl le Shift .
   
   
5. Lisele tse D2 ho F4 li lokela ho pota-potiloe ke moeli o mobu.
   
   

Liqeto tse ling tsa Keyboard

• E eketsa Letsatsi la Kajeno
• Khetha lisele tse sa tloaelehang ho Excel
• Ho eketsa Nako ea Hona joale

Hape "