Ukunciphisa okufakiwe kwe-Excel Okufakiwe kumathuluzi ajwayelekile kanye nezici
Funda konke mayelana nezinkinobho zokungena, kufaka phakathi inhlanganisela yokusebenzisa i-Excel ngokugcwele amandla.
01 ka-27
Faka i-Worksheet entsha ku-Excel
Leli phuzu le-Excel likukhombisa indlela yokufaka ishidi elisha lomsebenzi ebhokisini lokusebenzela usebenzisa isinqamuleli sekhibhodi. Faka i-New Excel Worksheet usebenzisa i-Shortcut Shortcut Press bese ubamba ukhiye we-SHIFT ekhibhodi. Cindezela bese ukhulula ukhiye we-F11 ekhibhodi. Iphepha lokusebenzela elisha lizofakwa ebhukwini lamanje. Ukwengeza amanye amashidi okusebenza aqhubeka nokucindezela nokukhipha ukhiye we-F11 ngenkathi ubamba ukhiye we-SHIFT. Okuningi "
02 kwezingu-27
Vula Umbhalo Emigqeni Ebili E-Excel
Ukugoqa umbhalo esitokisini Uma ufuna umbhalo ubonakale emigqeni eminingi esitokisini, ungafometha iseli ukuze umbhalo ufakwe ngokuzenzekelayo, noma ungangena ukuhlukana komugqa wombhalo. Ufuna ukwenzani? Ukugoqa umbhalo ngokuzenzekelayo Faka i-break line Ukugoqa umbhalo ngokuzenzekelayo Esikhathini samakhasi, khetha amangqamuzana ofuna ukuwafometha. Ethempelini laseKhaya, kuQembu Lokuqondisa, chofoza isithombe se-Wrap Text Button. Idatha ye-Ribbon Image Notes Notes in cell wraps ukuvumelanisa ububanzi bekholomu. Uma ushintsha ububanzi bekholomu, ukufaka idatha kulungisa ngokuzenzakalelayo. Uma wonke umbhalo ohlanganisiwe ungabonakali, kungenzeka ukuthi umugqa usethe ekuphakameni okuthile noma ukuthi umbhalo usezingeni lamaseli ahlanganisiwe. Ukuze wenze wonke umbhalo obhalwe ngophawu, yenza lokhu okulandelayo ukuze ulungise ukuphakama komugqa: Khetha iseli noma ibanga ofuna ukulungisa ukuphakama komugqa. Ethempelini laseKhaya, kumaqembu Amaseli, chofoza Ifomethi. Isithombe se-Excel Ribbon Ngaphansi Kamaselula, yenza okukodwa kokulandelayo: Ukuze ulungise ngokuzenzakalelayo ukuphakama komugqa, chofoza ukuphakama kwe-AutoFit Right. Ukuze ucacise ukuphakama komugqa, chofoza u-Row Height, bese uthayipha ukuphakama komugqa owudinga ebhokisini eliphakeme leRow. Ithiphu Ungadonsela umngcele ophansi wegqa kuze kube ukuphakama okubonisa wonke umbhalo ohlanganiswe. Phezulu kwekhasi Phezulu kwekhasi Faka ukuhlukana komugqa Ungaqala umugqa omusha wombhalo kunoma yiliphi iphuzu elithile esitokisini. Chofoza kabili iseli lapho ufuna ukungena khona. Isinqamuleli sekhibhodi Ungakhetha futhi iseli, bese ucindezela u-F2. Esitokisini, chofoza indawo lapho ufuna ukuphula khona umugqa, bese ucindezela i-ALT + ENTER.
Isici sombhalo we-Excel isici esenziwe kahle sokufometha esikuvumela ukuba ulawule ukubukeka kwamalebula nokufaka okufakwe kuspredishithi sakho.
Umbhalo wokunamathisela uvumela ukuthi ufake umbhalo emigqeni eminingi ngaphakathi kweseli elilodwa kunokuba ube nombhalo osabalalisa phezu kwamaseli amaningi ekhasini lokusebenzela .
Igama elithi "lobuchwepheshe" lesi sici ngumbhalo wokunamathisela futhi inhlanganisela eyinhloko yokubhala umbhalo:
I-Alt + FakaIsibonelo: Ukusebenzisa Izinkinobho Zesinqamuleli Ukumboza Umbhalo
Isibonelo usebenzisa isici sombhalo wokunamathisela i-Excel:
- Esitokisini D1 thayipha umbhalo: Ukuthola ngenyanga futhi ucindezela ukhiye we- Enter ekhibhodi.
- Njengoba umbhalo ude kakhulu esitokisini, kufanele uchithelele esitokisini E1.
- Esikhathini se-E1 thayipha umbhalo: Izindleko zenyanga futhi cindezela ukhiye we- Enter ekhibhodi.
- Ngokufaka idatha ku-E1 ilebula ku-cell D1 kufanele inqunywe ekugcineni kweseli D1. Futhi, umbhalo ku-E1 kufanele uchithelele esitokisini ngakwesokudla.
- Ukuze ulungise izinkinga ngala malebula, gqamisa amaseli D1 no-E1 ekhasini lokusebenzela.
- Chofoza kuthebhu yasekhaya .
- Chofoza inkinobho Yombhalo Wombhalo ku- Ribbon .
- Amalebula kumaseli D1 no-E1 kufanele manje bobabili babonakale ngokugcwele ngombhalo ophulwe emigqeni emibili ngaphandle kokuchithelwa kumaseli aseduze.
Isici sombhalo we-Excel isici esenziwe kahle sokufometha esikuvumela ukuba ulawule ukubukeka kwamalebula nokufaka okufakwe kuspredishithi sakho. Esikhundleni sokwandisa amakholomu wephepha lokusebenzela ukwenza izihloko ezinde zibonakale, ukugoqa umbhalo kukuvumela ukubeka umbhalo kumigqa eminingi ngaphakathi kweseli elilodwa. Isibonelo sombhalo wokuxubha we-Excel Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla. Esitokisini G1 thayipha umbhalo: Ukuthola ngenyanga futhi ucindezela inkinobho ENTER ekhibhodi. Njengoba Imali Yenyanga isinde kakhulu esitokisini sayo, izophonsela esitokisini H1. Esitokisini H1 thayipha umbhalo: Izindleko zenyanga futhi cindezela inkinobho ENTER ekhibhodi. Uma idatha ingene eseliweni H1, ilebula yokuqala yenyanga iyothola. Ukuze ulungise inkinga, donsela ukhethe amaseli G1 no-H1 kuspredishithi ukuze ugcizelele kubo. Chofoza kuthebhu yasekhaya. Chofoza inkinobho Yombhalo Wombhalo ku-Ribbon. Amalebula kumaseli G1 no-H1 kufanele manje bobabili abonakale ngokugcwele ngombhalo ophulwe emigqeni emibili ngaphandle kokugawula emangqamuzaneni aseduze.
Lesi sifundo sihlanganisa indlela yokuthayipha emigqeni eminingi ngaphakathi kweseli elilodwa lomsebenzi weshidi.
Igama elithi "lobuchwepheshe" lesi sici ngumbhalo wokunamathisela futhi inhlanganisela eyinhloko yokubhala umbhalo:
I-Alt + FakaIsibonelo: Ukusebenzisa Izinkinobho Zesinqamuleli Ukumboza Umbhalo
Ukusebenzisa isici sombhalo we-Excel sokusebenzisa i-keyboard kuphela:
- Chofoza kuseli lapho ufuna khona ukuthi umbhalo utholakale
- Thayipha umugqa wokuqala wombhalo
- Cindezela bese ubamba ikhi Alt ekhibhodi
- Cindezela bese ukhulula ukhiye wokungena kwikhibhodi ngaphandle kokukhipha ukhiye we-Alt
- Khipha ukhiye we-Alt
- Iphoyinti lokufaka kufanele lihambise emgqeni ngezansi umbhalo ovele wangena
- Thayipha umugqa wesibili wombhalo
- Uma ufisa ukungena imigqa engaphezu kwemibili yombhalo, qhubeka ucindezela i- Alt + Enter ekupheleni komugqa ngamunye
- Uma wonke umbhalo usungenwe, cindezela ukhiye we- Enter ekhibhodi noma uchofoze ngegundane ukuze uye kwenye iseli
03 ka-27
Engeza Usuku Lwanamuhla
Lesi sifundo sihlanganisa indlela yokwengeza ngokushesha usuku lwamanje kushidi lokusebenzela usebenzisa ikhibhodi kuphela.
Inhlanganisela ebalulekile yokwengeza usuku:
Isibonelo: Ukusebenzisa Amathanga Ashothikhathi Ukwengeza Usuku Lwanamuhla
Ukwengeza usuku lwamanje kushidi lokusebenzela usebenzisa ikhibhodi kuphela:
- Chofoza kuseli lapho ufuna khona usuku.
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Cindezela bese ukhulula ukhiye we-colon ( ; ) kukhibhodi ngaphandle kokukhipha ukhiye we-Ctrl.
- Khipha ukhiye we-Ctrl.
- Usuku lwamanje kufanele lufakwe kushidi lomsebenzi esitokisini esikhethiwe.
Qaphela: Lokhu kunqamuleli kwekhibhodi akusebenzi ukusetshenziswa kwe- TODAY umsebenzi ukuze usuku lungashintshi njalo uma ishidi lomsebenzi livuliwe noma lihlelwa kabusha. Okuningi "
04 ka-27
Idatha Yomumo ku-Excel Ukusebenzisa Izinqamuleli Zesikhashana
Idatha Yomumo ku-Excel Ukusebenzisa Izinqamuleli Zesikhashana
Leli phuzu lihlanganisa indlela yokufaka ngokushesha umsebenzi we-Excel we-SUM ukwengeza idatha usebenzisa izinkinobho zokunqamulela ekhibhodi.
Inhlanganisela eyinhloko yokufaka umsebenzi we-SUM yile:
" Alt " + " = "
Isibonelo: Ukufaka umsebenzi we-SUM usebenzisa izinqamuleli zezinqamuleli
- Faka idatha elandelayo kumaseli D1 kuya ku-D3 kwiphepha lokusebenzela le-Excel: 5, 6, 7
- Uma kunesidingo, chofoza ku-cell D4 ukuze wenze iseli esebenzayo
- Cindezela bese ubamba ikhi Alt ekhibhodi
- Cindezela bese ukhulula uphawu olulinganayo ( = ) kukhibhodi ngaphandle kokukhipha ukhiye we- Alt
- Khipha ukhiye we- Alt
- Umsebenzi we-SUM kufanele ufakwe esitokisini se-D4 ngobubanzi be- D1: D3 eqokonyiswe njengengxabano yomsebenzi
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela umsebenzi
- Impendulo 18 kufanele ivele esitokisini D4
- Uma uchofoza ku-cell D4 umsebenzi ophelele = I-SUM (D1: D3) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
Lesi sinqamuleli singasetshenziselwa ukuhlanganisa idatha emigqeni kanye namakholomu.
Qaphela : I-SUM yakhelwe ukuba ingeniswe phansi kwekholomu yedatha noma ekugcineni kwesigcawu sedatha.
Uma umsebenzi we-SUM ufakwe endaweni ngaphandle kwalaba ababili, ububanzi bamaseli akhethiwe njengengxabano yomsebenzi kungenzeka ukuthi akulungile.
Ukuze ushintshe ibanga elikhethiwe, sebenzisa i-pointer yegundane ukugqamisa uhla olufanele ngaphambi kokucindezela ukhiye we-Enter ukuqedela umsebenzi More »
05 ka-27
Ukungeza i-Current Time
Lokhu kufundisa kuhlanganisa indlela yokwengeza ngokushesha isikhathi samanje kushidi lokusebenzela usebenzisa ikhibhodi kuphela:
Inhlanganisela ebalulekile yokwengeza isikhathi yilezi:
Isibonelo: Ukusebenzisa Izinkinobho Zesinqamuleli Ukwengeza Isikhathi Sanje
Ukwengeza isikhathi samanje kushidi lokusebenzela usebenzisa nje ikhibhodi:
- Chofoza kuseli lapho ufuna khona isikhathi.
- Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
- Cindezela bese ukhulula ukhiye wekhaloni (:) ekhibhodi ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
- Isikhathi samanje sizofakwa kwipredishithi.
Qaphela: Lesi sinqamuleli sekhibhodi asisebenzisi umsebenzi we- MANJE ukuze usuku lungashintshi njalo uma ishidi lomsebenzi livuliwe noma lihlelwa kabusha.
Ezinye izinqamuleli zezinqamuleli zezifundo
- Ukwengeza Usuku Lwanamuhla
- Khetha Amaseli Angewona Akhona ku-Excel
- I-ALT - TAB Ishintshela ku-Windows
06 ka-27
Faka i-Hyperlink
Faka i-hyperlink ku-Excel usebenzisa ama-keycut Keys
Ukufundisa okuhlobene : Faka ama-hyperlink kanye namabhukhimakhi ku-Excel
Leli phuzu le-Excel lihlanganisa indlela yokufaka ngokushesha i-hyperlink kumbhalo okhethiwe usebenzisa izinkinobho zokunqamulela ku-Excel.
Inhlanganisela eyinhloko engasetshenziswa ukufaka i-hyperlink yile:
Ctrl + k
Isibonelo: Faka i-Hyperlink usebenzisa izinqamuleli zezinqamuleli
Ukuze uthole usizo ngalezi ziqondiso chofoza isithombe esingenhla
- Esikhathini sokusebenza se-Excel chofoza ku-cell A1 ukuze wenze iseli esebenzayo
- Thayipha igama ukuze usebenze njengombhalo we-anchor njengeSpredishithi bese ucindezela ukhiye we- Enter ekhibhodi
- Chofoza ku-cell A1 ukuze wenze futhi iseli elisebenzayo
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi
- Cindezela bese ukhulula incwadi ( k ) ukhiye ekhibhodi ukuvula ibhokisi lengxoxo ye- Hyperlink ibhokisi
- Kulo Kheli: umugqa phansi kwebhokisi lebhokisi lebhokisi lengxoxo i-URL egcwele njenge:
http://spreadsheets.about.com - Chofoza u-Ok ukuqedela i-hyperlink bese uvala ibhokisi lengxoxo
- Umbhalo wesikhonkwane esitokisini se-A1 kufanele ube nobuluhlaza okwesibhakabhaka futhi ugcizelelwe kubonisa ukuthi uqukethe hyperlink
Ukuhlola i-Hyperlink
- Beka isikhombisi segundane phezu kwe-hyperlink esitokisini A1
- I-pointer yomcibisholo kufanele ishintshe esandleni sophawu
- Chofoza kumbhalo we-anchor wokuxhuma
- Isiphequluli sakho sewebhu kufanele sivule ekhasini elibonwe yi-URL
Susa i-Hyperlink
- Beka isikhombisi segundane phezu kwe-hyperlink esitokisini A1
- I-pointer yomcibisholo kufanele ishintshe esandleni sophawu
- Chofoza ngakwesokudla umbhalo we-anchor wokuxhumanisa ukuze uvule imenyu yehla ye- Context
- Chofoza ku- Susa i-Hyperlink inketho kwimenyu
- Umbala okwesibhakabhaka nomgqa ophansi kufanele ususwe embhalweni we-anchor obonisa ukuthi hyperlink isusiwe
Ezinye izinqamuleli zekhibhodi
07 kwangu-27
Bonisa amafomula
Inhlanganisela eyinhloko engasetshenziselwa ukubonisa amafomula yi: Ctrl + `(ukhiye wamagama okushisa) Ekhibhodi ejwayelekile kakhulu, ukhiye we-accent we-grave ukhona eduze nenombolo 1 ekhoneni elingaphezulu kwesokunxele lekhibhodi futhi ubheka emuva apostrophe. Bonisa Amafomula usebenzisa Isihluthulelo Sokhiye Wezinkinobho Cindezela bese ubamba ukhiye we-Ctrl kwikhibhodi Cindezela bese ukhulula ukhiye we-accent key (``) ekhibhodi ngaphandle kokukhulula ukhiye we-Ctrl Khipha ukhiye we-Ctrl Mayelana ne-Show Fomula Bonisa amafomula ashintshi ispredishithi, kuphela indlela ekhonjiswa ngayo. Ukwenza kube lula ukuthola amangqamuzana aqukethe amafomula Akuvumela ukuba ufunde ngokushesha kuwo wonke amafomula ukuze uhlole amaphutha Uma uchofoza kwifomula, i-Excel ichaza ngombala izingqikithi zeseli ezisetshenziselwa ifomula. Lokhu kukusiza ukuba ulandele idatha esetshenziselwa ifomula. Phrinta amaspredishithi namafomu wokubukwa avuliwe. Ukwenza kanjalo, kuzokuvumela ukuthi useshe ispredishithi kanzima ukuthola amaphutha. Okuningi "08 ka-27
Izihluthulelo ze-Excel Shortcut - Hlehlisa
Lokhu kufundisa okuyisihluthulelo sokhiye we-Excel kubonisa indlela "yokulungisa" izinguquko ezenziwe efomini lokusebenzela le-Excel.
Isifundo esilandelayo: Isici sokususa i-Excel .
Qaphela: Kubalulekile ukukhumbula ukuthi uma usebenzisa Ukuhlehlisa, "kususa" izenzo zakho ngokulandelana okuqondile okuwafakile.
Inhlanganisela yokhiye wezinqamuleli ezisetshenziselwe "ukulungisa" izinguquko yilezi:
- Ctrl + " Z "
Isibonelo Sokuhlehlisa Izinguquko usebenzisa Izinqamuleli Zezinqamuleli
- Thayipha idatha ethile esitokisini , njenge-A1 kuspredishithi bese ucindezela ukhiye we- Enter ekhibhodi.
- Chofoza kulelo seli ukuze lenze iseli elisebenzayo .
- Chofoza kuthebhu yasekhaya ye- ribbon .
- Faka isicelo sezinketho ezilandelayo zokufometha idatha yakho:
- shintsha umbala wefonti,
- wandisa ikholomu,
- gcizelela,
- shintsha uhlobo lwefonti ku-Arial Black,
- phakamisa ukuvumelanisa idatha
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Cindezela bese ukhulula incwadi " Z " ekhibhodi.
- Idatha eselifini kufanele iguqule emuva ukulungiswa kwesokunxele njengoba ukuguqulwa kokugcina (ukuqondanisa phakathi) kuhlehlisiwe.
- Cindezela bese ubamba ukhiye we- Ctrl ekhibhodi futhi.
- Cindezela bese ukhulula incwadi " Z " ekhibhodi kabili ngaphandle kokukhulula ukhiye we- Ctrl .
- Ngeke nje ukususwa kwe-underline kodwa ifonti ngeke isaba yi-Arial Black.
- Lokhu kwenzeka ngoba, njengoba kushiwo ngenhla, isici sokuhlehlisa "senza" izenzo zakho ngokulandelana okuqondile okuwafakile.
Amanye ama-Tutorials we-Shortcut Keys Tutorials
- Ukungeza i-Current Time
- Khetha Amaseli Angewona Akhona ku-Excel
- ALT - TAB Ukushintsha Okusheshayo ku-Windows
09 ka-27
Ukukhetha Amaseli Angewona Amandla
Khetha Amaseli Angewona Akhona ku-Excel
Izifundo ezihlobene: Khetha Amaseli Angewona Amandla Asebenzisa Ikhibhodi Namouse
Ngokukhetha amangqamuzana amaningi ku-Excel ungasusa idatha, sebenzisa ukufometha njengemingcele noma ukufaka shading, noma ukusebenzisa ezinye izinketho ezindaweni ezinkulu zeshidi lokusebenza konke ngesikhathi esisodwa.
Ngezinye izikhathi lawa maseli akatholakali ebhodini elixubileyo. Kulezi zimo kungenzeka ukuthi ukhethe amaseli angasondelene nawo.
Lokhu kungenziwa ngokusebenzisa ikhibhodi negundane ndawonye noma kuphela usebenzisa ikhibhodi.
Ukusebenzisa ikhibhodi ngemodi eyandisiwe
Ukukhetha amangqamuzana angasondelene nekhibhodi kuphela kudinga ukuthi usebenzise ikhibhodi kumodi eyandisiwe .
Imodi enwetshiwe icushiwe ngokucindezela ukhiye we- F8 ekhibhodi. Uvala imodi enwetshiwe ngokucindezela okhiye be- Shift no- F8 ekhibhodi ndawonye.
Khetha Amaseli Angewona Awamakheli E-Excel Ukusebenzisa Ikhibhodi
- Hambisa isikhombisi seseli kwiseli yokuqala ofuna ukuyikhetha.
- Cindezela bese ukhulula ukhiye we- F8 ekhibhodi ukuze uqale i- Mode Extended futhi ugcizelele iseli lokuqala.
- Ngaphandle kokuhambisa isikhombisi se-cell, cindezela bese ukhulula okhiye be- Shift + F8 ekhibhodi ndawonye ukuvala imodi enwetshiwe.
- Sebenzisa izinkinobho zemicibisholo ekhibhodi ukuhambisa isilayidi yeseli esiteleni esilandelayo ufisa ukugqamisa.
- Iseli yokuqala kufanele ihlale iqokonyiswe.
- Ngesikhombisi seseli kuseli elilandelayo ukuze sigcizelelwe, phinda izinyathelo 2 no-3 ngenhla.
- Qhubeka ukwengeza amaseli ebangeni eligqamile ngokusebenzisa okhiye be- F8 ne- Shift + F8 ukuze uqale futhi umise imodi enwetshiwe.
Ukukhetha ama-Adjacent and Non-Adjentent Cells ku-Excel Ukusebenzisa ikhibhodi
Landela izinyathelo ezingezansi uma ububanzi obuthandayo ukukhetha luqukethe inhlanganisela yamaseli aseduze namanye njengoba kuboniswa esithombeni ngenhla.
- Hambisa isikhombisi seseli kwiseli lokuqala eqenjini lamaseli ofuna ukuligqamisa.
- Cindezela bese ukhulula ukhiye we- F8 ekhibhodi ukuze uqale imodi enwetshiwe .
- Sebenzisa okhiye bomcibisholo ekhibhodi ukwandisa ibanga eligqamile ukuze ufake wonke amaseli eqenjini.
- Ngayo wonke amaseli eqenjini akhethiwe, cindezela bese ukhulula okhiye be- Shift + F8 ekhibhodi ndawonye ukuvala imodi enwetshiwe.
- Sebenzisa izinkinobho zemicibisholo ekhibhodi ukuze uhambise isikhombisi seseli kude neqembu elikhethiwe lamaseli.
- Iqembu lokuqala lamaseli kufanele lihlale ligqanyisiwe.
- Uma kukhona amangqamuzana amaningi aqoqowe ufisa ukugqamisa, hamba esitokisini sokuqala eqenjini bese uphinda izinyathelo ezimbili kuya ku-4 ngenhla.
- Uma kunamaseli ngabanye ofisa ukungeza ebangeni eligqamile, sebenzisa isethi yokuqala yemiyalelo ngenhla ukugqamisa amangqamuzana angabodwa.
10 kwangu-27
Khetha Amaseli Angewona Akhona e-Excel ngekhibhodi ne-Mouse
Izifundo ezihlobene: Ukukhetha Amaseli Angewona Amandla Asebenzisa Ikhibhodi
Ngokukhetha amangqamuzana amaningi ku-Excel ungasusa idatha, sebenzisa ukufometha njengemingcele noma ukufaka shading, noma ukusebenzisa ezinye izinketho ezindaweni ezinkulu zeshidi lokusebenza konke ngesikhathi esisodwa.
Ngesikhathi usebenzisa udoti ukhethe indlela negundane ukuze ugcizelele ngokushesha i-block yamaseli asondelene cishe indlela ejwayelekile kunazo zonke yokukhetha amangqamuzana angaphezu kweyodwa, kunezikhathi lapho amaseli ofuna ukuwakhanyisa awakhiwe eduze komunye nomunye.
Uma lokhu kwenzeka, kungenzeka ukhethe amaseli angasondelene. Nakuba ukhetha amaseli angasondelene angenziwa kuphela ngekhibhodi , kulula ukukwenza ngokusebenzisa ikhibhodi negundane ndawonye.
Ukukhetha Amaseli Angewona Akhona ku-Excel
Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.
- Chofoza kuseli lokuqala ofuna ukulikhetha nge-pointer yegundane ukuze wenze iseli elisebenzayo .
- Khipha inkinobho yegundane.
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Chofoza kuwo wonke amaseli ofuna ukuwakhetha Ngaphandle kokukhipha ukhiye we- Ctrl .
- Uma wonke amaseli afunayo ekhethiwe, khipha ikhi Ctrl .
- Ungacindezi noma yikuphi nge-pointer yegundane uma ukhulula ukhiye we- Ctrl noma uzosusa okugqamile kumaseli akhethiwe.
- Uma ukhulula ikhi ye- Ctrl ngokushesha futhi ufisa ukugqamisa amaseli amaningi, mane ucindezele futhi ubambe ukhiye we- Ctrl futhi uchofoze kumaseli angeziwe.
Ezinye izinqamuleli zezinqamuleli zezifundo
11 kwangu-27
I-ALT - TAB Ishintshela ku-Windows
Akuyona nje isinqamuleli se-Excel, i-ALT-TAB Ishintsho yindlela esheshayo yokuhambisa phakathi kwayo yonke imibhalo evulekile ku-Windows (Win key + Tab ku-Windows vista).
Ukusebenzisa ikhibhodi ukuze ufeze umsebenzi kwikhompyutha ngokuvamile kusebenza kahle kakhulu kunokusebenzisa igundane noma enye idivayisi yokukhomba, futhi ukushintshwa kwe-ALT - TAB kungenye yezindlela ezisetshenziswe kakhulu kulezi izinqamuleli zekhibhodi.
Usebenzisa i-ALT - TAB Ukushintsha
- Vula okungenani amafayela amabili ku-Windows. Lezi zingaba amafayela amabili e-Excel noma i-Excel File nefayela le-Microsoft Word ngokwesibonelo.
- Cindezela bese ubamba ikhi Alt ekhibhodi.
- Cindezela bese ukhulula ukhiye weThabhi kukhibhodi ngaphandle kokuvumela ukuhamba kwekhi ye- Alt .
- I-ALT-TAB Fast Switching iwindi kufanele ivele phakathi kwesikrini sakho sekhompyutheni.
- Le iwindi kufanele ibe nesithonjana somqulu ngamunye okwamanje ovuliwe kukhompyutha yakho.
- Isithonjana sokuqala ngakwesokunxele sizoba ngedokhumenti yamanje - eyabonakala esibukweni.
- Isithonjana sesibili ukusuka kwesobunxele kufanele sigcizelelwe ibhokisi.
- Ngezansi kwezithonjana kufanele kube negama lwedokhumenti eligqanyiswe ibhokisi.
- Khipha ukhiye we- Alt namafasitela ashintshela idokhumenti eveziwe.
- Ukuze uthuthelele eminye imibhalo ekhonjisiwe e-ALT - TAB Fast Switching iwindi, qhubeka ugcina i- Alt ngenkathi uthayipha ukhiye weThabhu . Ikompo ngalinye kufanele lihambise ibhokisi eligqamile elisala kwesokudla kusukela kumqulu owodwa kuya kwesinye.
- Khipha ukhiye we- Alt uma idokhumenti oyifunayo icaciswa.
- Uma i-ALT - TAB Fast Switching iwindi ivuliwe, ungaphambukisa ukuqondisa kwebhokisi eligqamile - ukuyishukumisela ukusuka kwesokudla kuya kwesobunxele - ngokubamba phansi ikhi Shift kanye ne- Alt bese uthayipha ukhiye weThabhu .
Ezinye izinqamuleli zekhibhodi
12 kwangu-27
I-Excel iya ku-Isici
Isifundo esilandelayo: I- Excel Igama le-Box Navigation .
I- Go Yokufaka ku-Excel ingasetshenziselwa ukushesha ngokushesha kumaseli ahlukene kuspredishithi . Lesi sihloko sibandakanya isibonelo sendlela yokusebenzisa i- Go To feature ukuze uhambise kumaseli ahlukene usebenzisa isinqamuleli sekhibhodi.
Nakuba kungadingekile kumaphepha okusebenzela abasebenzisa amakholomu namarowu ambalwa kuphela, ukuze uthole ama-worksheets amakhulu angasiza ukuthi ube nezindlela ezilula zokugxuma kusuka endaweni eyodwa kweshidi lakho lomsebenzi ukuya kwelinye.
Ukucupha i- Go Ukufaka usebenzisa ikhibhodi, cindezela ukhiye we- F5
Isibonelo usebenzisa i-Excel iya ukufaka ukuhamba:
- Cindezela ukhiye we-F5 ekhibhodi ukuletha ibhokisi lokuya ku- Go .
- Thayipha ireferensi yeseli yendawo oyifunayo endaweni yokubhekisela ebhokisini lengxoxo. Kulokhu: HQ567 .
- Chofoza inkinobho OK noma ucindezela inkinobho ENTER ekhibhodi.
- Ibhokisi elimnyama elizungezile iseli esebenzayo kufanele lifinyelele esitokisini i- HQ567 ukwenza kube iseli elisha elisebenzayo.
- Ukuhambisa kwenye iseli, phinda izinyathelo 1 kuya ku-3.
Izifundiswa ezihlobene
- Igama le-Excel Igama lokuhamba
- Izinkomba zoMakhalekhukhwini emafomulini
- Ukungeza ama-Hyperlink nama-Bookmarks ku-Excel
13 kwangu-27
I-Excel Gcwalisa I-Down Command
Uma udinga ukufaka idatha efanayo - umbhalo noma izinombolo - zibe inombolo yamaseli athile ekholomu , umyalo ogcwalisa phansi ungakwenza lokhu ngokushesha ngokusebenzisa ikhibhodi.
Leli phuzu le-Excel likukhombisa indlela yokusebenzisa umyalo wokugcwalisa phansi ku- spreadsheet ye- Excel usebenzisa isinqamuleli sekhibhodi.
Inhlanganisela eyinhloko esebenzayo Umyalo wokugcwalisa phansi uwukuthi:
- Ctrl + D
Isibonelo: Ukusebenzisa Gcwalisa phansi ngesinqamuleli sekhibhodi
Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.
- Thayipha inombolo, efana no- 395.54 ibe yiseli D1 ku-Excel.
- Cindezela bese ubamba ukhiye we- Shift kukhibhodi
- Cindezela bese ubamba ukhiye we- Down Arrow ekhibhodi ukwandisa ukugqamisa kweseli kusuka kuseli D1 kuya ku-D7.
- Khipha kokubili okhiye.
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Cindezela bese ukhulula ukhiye " D " ekhibhodi.
- Amaseli D2 kuya ku-D7 kufanele manje agcwaliswe ngemininingwane efanayo njengeseli D1.
Ezinye izinqamuleli zekhibhodi
14 kwangu-27
Ukusebenzisa Ukumiswa kobuciko
Leli phuzu le-Excel likukhombisa ukuthi ungasebenzisa kanjani ukufometha kwethebulaki usebenzisa izinkinobho zokunqamulela ekhibhodi.
Kunezinhlanganisela ezimbili eziyinhloko ezingasetshenziswa ukwengeza noma ukususa ukufometha kwethebulayo kudatha:
- Izikhiye ze- Ctrl + " I "
- Ctrl + " 3 " okhiye
Isibonelo: Ukusebenzisa Izinqamuleli Zesihluthulelo Zokufaka I-Formatting Italics
Ukuze uthole usizo ngalesi sibonelo, bheka isithombe ngakwesokudla.
- Thayipha idatha ethile esitokisini , njenge-E1 kuspredishithi bese ucindezela ukhiye we- Enter ekhibhodi.
- Chofoza kulelo seli ukuze lenze iseli elisebenzayo .
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Cindezela bese ukhulula incwadi ethi " Mina " ekhibhodi.
- Ukufometha okwempawu kufanele kusetshenziswe kudatha esele.
- Cindezela futhi ukhulule izinkinobho ze- Ctrl + " I " futhi ukuze ususe ukufometha kwethebula.
Ezinye izinqamuleli zekhibhodi
- Engeza isikhathi samanje
- Khetha Amaseli Angewona Akhona ku-Excel
- ALT - TAB Ukushintsha Okusheshayo ku-Windows
15 kwangu-27
Faka isicelo sokufometha kwenombolo
Lokhu kufundisa kuhlanganisa indlela yokufometha kwenombolo kumaseli akhethiwe usebenzisa ikhibhodi kuphela:
Amafomethi ezinombolo asetshenziselwa idatha ekhethiwe yilezi:
- izindawo ezimbili zedesimali
- i-comma njenge-separator yezinkulungwane (,)
- uphawu lokunciphisa (-) lwamagugu angalungile
Inhlanganisela eyinhloko engasetshenziswa ukusebenzisa i-currency ukufometha kwedatha yile:
Ctrl + Shift + ! (iphuzu lokumemeza)
Isibonelo: Ukusebenzisa Izinkinobho Zesinqamuleli Ukufaka Ukufometha Kwezinombolo
Lesi sibonelo siboniswa esithombeni ngenhla
- Engeza idatha elandelayo kumaseli A1 kuya ku-A4:
4578.25102 45782.5102 457825.102 4578251.02 - Gqamisa amaseli A1 kuya ku-A4 ukuze ukhethe
- Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi
- Cindezela bese ukhulula ikhi yokumemeza ( ! ) Ekhibhodi ngaphandle kokukhipha okhiye be- Ctrl ne- Shift
- Khipha okhiye be- Ctrl ne- Shift
- Izinombolo kumaseli A1 kuya ku-A4 kufanele zonke zifomathiwe ukuze zibonise izindawo ezimbili zedesimali ngisho noma izinombolo eziningana zingaphezu kokubili
- Amaseli kufanele futhi abe ne-comma engeziwe njenge-separator yezinkulungwane
- Ukuchofoza kunoma yiliphi lamaseli ubonisa inombolo engafaniwe engafaniwe ebhakisini lefomula ngaphezulu kwephepha lokusebenzela
Ezinye izinqamuleli zekhibhodi
16 kwangu-27
Faka isicelo sokufometha kwemali
Lesi sifundo sihlanganisa indlela yokusebenzisa ngokushesha ukufometha kwemali kumaseli akhethiwe usebenzisa ikhibhodi kuphela:
Inhlanganisela eyinhloko engasetshenziswa ukusebenzisa i-currency ukufometha kwedatha yile:
- Ctrl + Shift + 4
Isibonelo: Ukusebenzisa Izinkinobho Zesinqamuleli Ukufaka Ukufometha Kwemali
Ukuze uthole usizo ngalesi sibonelo, bheka isithombe ngakwesokudla.
- Engeza idatha elandelayo kumaseli A1 kuya ku-B2: 7.98, 5.67, 2.45, -3.92
- Hudula ukhethe amaseli A1 kuya ku-B2 ukuze uwaqokomise.
- Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
- Cindezela bese ukhulula inombolo eyisihluthulelo ( 4 ) ekhibhodi ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
- Emaseleni angu-A1, A2, no-B1 isibonakaliso se-dollar ( $ ) kufanele sengezwe kudatha.
- Esitokisini B2, ngoba idatha iyinombolo engalungile, kufanele ibe ebomvu futhi ihaqwe ngamakaki okuzungeza ngaphezu kokufaka uphawu lwe-dollar ( $ ).
Ezinye izinqamuleli zekhibhodi
17 kwangu-27
Faka ukufometha kwama-Percent
Leli phuzu le-Excel lihlanganisa ukufaka ukufometha kwamaphesenti kumaseli akhethiwe ku- spreadsheet ye- Excel usebenzisa izinkinobho zokunqamulela ekhibhodi.
Inhlanganisela eyinhloko engasetshenziswa ukusebenzisa i-currency ukufometha kwedatha yile:
- I-Ctrl + Shift + 5
Isibonelo Sendlela Yokufaka Ukufometha Kwemaphesenti usebenzisa Izinqamuleli Zezinqamuleli
Ukuze uthole usizo ngalesi sibonelo, bheka isithombe esingenhla.
- Engeza idatha elandelayo kumaseli A1 kuya ku-B2: .98, -.34, 1.23, .03
- Hudula ukhethe amaseli A1 kuya ku-B2 ukuze uwaqokomise.
- Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
- Cindezela bese ukhulula inombolo yesihlanu ( 5 ) ekhibhodi ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
- Emangqamuzaneni A1 kuya ku-B2 idatha kufanele iguqulwe iphesenti ngesibonakaliso sephesenti ( % ) esongezwe kudatha.
Ezinye izinqamuleli zezinqamuleli zezifundo
- Faka isicelo sokufometha kwemali
- Ukusebenzisa Ukumiswa kobuciko
- Engeza ama-Borders ku-Excel
18 kwangu-27
Khetha Wonke Amaseli kuthebula le-Excel Data
Leli phuzu le-Excel lihlanganisa indlela yokukhetha wonke amaseli kuthebula lemininingwane ye-Excel usebenzisa isinqamuleli sekhibhodi. Ukwenza kanjalo kukuvumela ukuba usebenzise izinguquko ezifana nokufometha, ububanzi bekholomu, njll kushidi lokusebenzela konke ngesikhathi esisodwa.
I-athikili ehlobene: Ukwakha Ithebula Ledatha ku-Excel .
Qaphela: Ukuze uthole usizo ngalesi sibonelo, bheka isithombe ngakwesokudla.
Isibonelo Sendlela Yokukhetha Wonke Amaseli KuThebula Ledatha
- Vula ishidi lokusebenzela le-Excel equkethe ithebula yedatha noma udale ithebula lwedatha .
- Chofoza kunoma iyiphi iseli kudatha yedatha.
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
- Cindezela bese ukhulula inkinobho ethi " A " ekhibhodi ngaphandle kokukhipha ukhiye we- Ctrl .
- Wonke amaseli etafuleni yedatha kufanele aqokonyiswe.
- Cindezela bese ukhulula incwadi " A " okwesibili.
- Umugqa ohamba phambili wetafula yedatha kufanele ugcizelelwe kanye netafula yedata.
- Cindezela bese ukhulula incwadi " A " okwesithathu.
- Wonke amaseli okushicilela kufanele afakwa kabanzi.
Ezinye izinqamuleli zekhibhodi
19 kwangu-27
Khetha i-Row Rote ku-Excel usebenzisa ama-keycut Keys
Khetha Imigqa ekhasini lokusebenzela
Leli phuzu le-Excel lihlanganisa ukuthi ungakhetha kanjani ngokushesha noma ugcizelele umugqa ophelele kushidi lokusebenzisa usebenzisa izinkinobho zokunqamulela ekhibhodi ku-Excel.
Inhlanganisela eyinhloko esetshenziselwa ukukhetha umugqa uwu:
SHIFT + SPACEBAR
Isibonelo: Ukusebenzisa Izinkinobho Zokunqamulela Ukukhetha I-Rout Worksheet Row
- Vula i-Excel Worksheet - akudingeki ukuba kube khona nanoma iyiphi idatha
- Chofoza esitokisini ekhasini lokusebenzela - njenge-A9 - ukwenza kube iseli elisebenzayo
- Cindezela bese ubamba ukhiye we- SHIFT ekhibhodi
- Cindezela bese ukhulula ukhiye we- SPACEBAR ekhibhodi ngaphandle kokukhulula ukhiye we- SHIFT
- Khipha ukhiye we- SHIFT
- Wonke amaseli emgqeni okhethiwe kufanele agcizelelwe - kufaka phakathi isihloko segqa
20 kwangu-27
Londoloza ku-Excel
I-Excel Londoloza izinkinobho ezifushane
Leli phuzu le-Excel lihlanganisa ukuthi ungasindisa kanjani idatha ngokushesha usebenzisa izinkinobho zokunqamulela ekhibhodi ku-Excel.
Inhlanganisela eyinhloko engasetshenziswa ukulondoloza idatha yile:
I-Ctrl + S
Isibonelo: Ukusebenzisa izinkinobho zokunqamulela ukugcina ishidi lokusebenzela
- Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi
- Cindezela bese ukhulula ukhiye ( S ) ekhibhodi ngaphandle kokukhipha ukhiye we- Ctrl
- Khipha ukhiye we- Ctrl
Isikhathi sokugcina Sindisa
Uma ngabe usilondoloze ngaphambilini ishidi lokusebenzela isici kuphela sokuthi i-Excel isindisa ifayela lakho kungenzeka ukuthi i-pointer yegundane ishintsha kancane kwisithonjana se-hourglass bese ubuyela esimweni esivamile esimhlophe esimhlophe.
Ubude besikhathi isithonjana se-hourglass sihlala sibonakala sincike ekutheni inani le-Excel yedatha kumele lilondoloze. Okukhulu kakhulu kwedatha yokulondoloza, isikhathi eside isithonjana se-hourglass sizobonakala.
Uma ulondoloza ishidi lokusebenzela okokuqala okokuqala ibhokisi lebhokisi lokugcina lizovuleka.
Uma ifayela ligcinwa okokuqala okokuqala izingcezu ezimbili zolwazi kumele zichazwe ebhokisini lokugcina le- Save njenge :
- igama lefayela (kuze kube yizinhlamvu ezingu-255 ezifaka izikhala)
- indawo (ifolda) lapho ifayela lizogcinwa khona
Londoloza Ngokuvamile
Kusukela usebenzisa izinkinobho zokunqamulela ze - Ctrl + S yindlela elula yokugcina idatha kuwumqondo omuhle ukusindisa njalo - okungenani njalo ngemizuzu emihlanu - ukugwema ukulahlekelwa kwedatha uma kwenzeka ukuphahlazeka kwekhompyutha. Okuningi "
21 kwangu-27
Fihla futhi uhlanganise ama Columns kanye nemizila e-Excel
22 kwangu-27
Ukufometha Usuku
Leli phuzu le-Excel likukhombisa ukuthi ungayifaka kanjani usuku (usuku, inyanga, ifomethi yonyaka) kusipredishithi se-Excel usebenzisa isinqamuleli sekhibhodi.
Ukufometha Usuku usebenzisa isinqamuleli sekhibhodi
- Engeza idethi oyifunayo kwiseli ku-spreadsheet ye-Excel.
- Chofoza kuseli ukuze wenze iseli esebenzayo .
- Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
- Cindezela bese ukhulula ukhiye wezinombolo ( # ) kukhibhodi ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
- Idethi esakhiweni esebenzayo izofomatha ngosuku, inyanga, ifomethi yonyaka.
Ezinye izinqamuleli zekhibhodi
23 kwangu-27
Ukufometha Isikhathi Sanje
Leli phuzu le-Excel likukhombisa indlela yokufometha isikhathi samanje (ihora, iminithi, ne-AM / PM ifomathi) ku- spreadsheet ye- Excel usebenzisa isinqamuleli sekhibhodi.
Ukufometha Isikhathi Sanje usebenzisa i-Shortcut Shortcut
- Sebenzisa umsebenzi we- MANJE ukwengeza usuku nesikhathi samanje kweseli D1.
- Chofoza kuseli D1 ukuze wenze iseli esebenzayo .
- Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
- Cindezela bese ukhulula inombolo emibili ( 2 ) ekhibhodi ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
- Umsebenzi we-MAN ku-cell D1 uzofomathwa ukuze ubonise isikhathi samanje ngehora, emaminithi, ne-AM / PM ifomathi.
Ezinye izinqamuleli zekhibhodi
24 kwangu-27
Shintsha Phakathi Kwama-Worksheets
Njengenye indlela yokusebenzisa igundane, kulula ukusebenzisa isinqamuleli sekhibhodi ukushintsha phakathi kwamashidi e-Excel.
Izihluthulelo ezisetshenziselwa ukhiye we- CTRL noma i- PGUP (ikhasi phezulu) noma ukhiye we- PGDN (ikhasi phansi)
Isibonelo - Shintsha Phakathi Kwama-Worksheets ku-Excel
Ukuya ngakwesokudla:
- Cindezela bese ubamba ukhiye we- CTRL kukhibhodi.
- Cindezela bese ukhulula ukhiye we- PGDN (ikhasi phansi) kukhibhodi.
- Ukuhambisa elinye ishidi ngakwesokudla bese ukhulula ukhiye we- PGDN okwesibili.
Ukuhambisa ngakwesokunxele:
- Cindezela bese ubamba ukhiye we- CTRL kukhibhodi.
- Cindezela bese ukhulula ukhiye we- PGUP (ikhasi phezulu) kukhibhodi.
- Ukuhambisa elinye ishidi kumshini wesokunxele bese ukhulula ukhiye we- PGUP okwesibili.
Ezinye izinqamuleli zekhibhodi
25 kwangu-27
Hlela Amaseli nge-F2 Function Key
I-Excel Hlela Amaseli Ukhiye Wokunqamulela
Isihluthulelo somsebenzi F2 ikuvumela ukuba uhlele ngokushesha futhi kalula idatha yeseli ngokusebenzisa imodi yokuhlela ye-Excel bese ufaka iphuzu lokufaka ekupheleni kokuqukethwe kwe-cell esebenzayo okukhona.
Isibonelo: Ukusebenzisa i-F2 Key ukuhlela okuqukethwe kocingo
Lesi sibonelo sihlanganisa indlela yokuhlela ifomula ku-Excel
- Faka idatha elandelayo kumaseli 1 kuya ku-D3: 4, 5, 6
- Chofoza kuseli E1 ukuze wenze iseli esebenzayo
- Faka ifomula elandelayo kwiselula E1:
= D1 + D2 - Cindezela ukhiye we- Enter ekhibhodi ukuqedela ifomula - impendulo 9 kufanele ivele esitokisini E1
- Chofoza ku-cell E1 ukuze wenze futhi iseli esebenzayo
- Cindezela ukhiye we- F2 ekhibhodi
- I-Excel ingena kumodi yokuhlela futhi iphuzu lokufaka lifakwa ekupheleni kwendlela yokusebenza yamanje
- Shintsha ifomula ngokungeza + i-D3 ekupheleni kwayo
- Cindezela ukhiye we- Enter ekhibhodi ukuqedela ifomu bese ushiya imodi yokuhlela - inani elisha lefomula - 15 - kufanele livele kuseli E1
Qaphela: Uma inketho yokuvumela ukuhlelwa ngqo kumaseli ivaliwe, ucindezela ukhiye we-F2 uzobe usubeka i-Excel kumodi yokuhlela, kodwa iphuzu lokufaka lizohanjiswa ebhasini lefomula ngaphezulu kwephepha lokusebenzela ukuze uhlele okuqukethwe kweseli. Okuningi "
26 kwangu-27
Khetha Wonke Amaseli ku-Work Excel Excel
27 kwangu-27
Engeza ama-Borders
Leli phuzu le-Excel lihlanganisa indlela yokwengeza umngcele kumaseli akhethiwe ku- spreadsheet ye- Excel usebenzisa isinqamuleli sekhibhodi.
Ukufundisa okuhlobene: Ukungeza / Ukufometha Imingcele e-Excel .
Inhlanganisela ebalulekile yokwengeza isikhathi yilezi:
Isibonelo Sendlela Yokufaka Imingcele usebenzisa isinqamuleli sekhibhodi
Ukuze uthole usizo ngalesi sibonelo, bheka isithombe ngakwesokudla.
- Faka izinombolo 1 kuya ku 9 kumaseli D2 kuya ku-F4.
- Hudula ukhethe amaseli D2 kuya ku-F4 ukuze uwaqokomise.
- Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
- Cindezela bese ukhulula ukhiye wesikhombisa ( 7 ) ekhibhodi ngaphandle kokukhipha okhiye be- Ctrl ne- Shift .
- Amaseli D2 kuya kuF4 kufanele azungezwe umngcele omnyama.
Ezinye izinqamuleli zekhibhodi