Omnye wemibuzo abaninzi abazibuza yona xa besebenza neespredishithi ngu Uyilungisa njani ikholam ebalaseleyo. Ayisiyikholamu kuphela, kodwa ikwangumqolo kunye neeseli. Umbuzo uvela ngakumbi xa usebenza ngamanani amakhulu edatha kwaye kuya kufuneka ubuye umva kwakhona kwikholamu yesalathiso / kumqolo / kwiseli.
Ngokwesiqhelo ezo sifuna ukuba zibonakale ngawo onke amaxesha ziikholamu kunye nemiqolo equlathe izihloko okanye izihloko, nangona eli qhinga linokusetyenziswa kunye neminye imiqolo kunye neekholamu (akufuneki zibe zezokuqala).
Ngaphandle kokusebenzisa indlela yokulungisa ikholamu ye-Excel, ukusebenza ngeespredishithi kunokuhamba kancinci, kuyadinisa kwaye kucothe. Nokuba iyacaphukisa ngamanye amaxesha. Kunyanzelekile ukuba siqhubeke sisebenzisa i- umqulu, Ukuhambisa iblade phezulu nasezantsi okanye ecaleni, ukuchitha ixesha elininzi. Kwaye ixesha yinto ekungekho mntu uyisindisayo.
Ke siza kuchaza indlela yokwenza lo msebenzi ulula kunye namandla ngale ndlela sebenza kwi Excel ngendlela elula ngakumbi nesebenzayo.
Lungisa ikholamu kwi-Excel
Ukusebenza kokulungisa ikholamu ye-Excel kule nkqubo ukusukela kuguqulo lwayo lonyaka ka-2007. Ukungeniswa kwayo kwakuluncedo olukhulu kubasebenzisi abasebenza ngeespredishithi ezinkulu kwaye baphatha isixa esikhulu sedatha. Kwaye kusenjalo nanamhlanje. Icebo elonyusa imveliso yethu.
Ukuyenza isebenze ngokuchanekileyo, la manyathelo ekufuneka elandelwe:
Ukunqakraza kwi "Jonga" ukhetho kuvula iindlela ezintathu zokukhenkca iikholamu, imiqolo kunye neepaneli.
Okokuqala, nqakraza kwithebhu "Ukubona" ivela phezulu kwispredishithi, apho zonke izixhobo ziboniswa. Apho sinezinto ezintathu esinokukhetha kuzo:
-
- Friza umqolo ophezulu. Ngolu khetho, umqolo wokuqala wespredishithi "ngumkhenkce", oza kuhlala umile kwaye ubonakale ngelixa sihamba ngokuthe nkqo kwiphepha.
- Friza ikholamu yokuqala. Isebenza njengokhetho lwangaphambili, ukugcina ikholamu yokuqala yespredishithi esisigxina kunye nokujonga ngelixa siskrolela ngokuthe tye kuxwebhu.
- Umkhenkce panels. Olu khetho ludibaniso lwezi zimbini zangaphambili. Isinceda ukwenza ukwahlula ngokusekwe kwiseli ebesikhe sayikhetha ngaphambili. Yeyona ekufuneka siyikhethile ukuba sifuna ukukhenkceza okanye ukulungisa imiqolo kunye neekholamu ngaxeshanye. Kwimeko apho umqolo okanye ikholamu esizimisele ukuyicwangcisa ayisiyiyo eyokuqala.
Kuxhomekeke kumsebenzi oza kuwenza, kuya kufuneka ukhethe enye yezi zinto zintathu unokukhetha kuzo.
Imiqolo kunye neekholamu ezihleli zihleliwe zahlukile ngo lelona layini lishinyeneyo leseli elibaphawulayo. Kubalulekile ukuba wazi ukuba ukulungisa iikholamu ze-Excel (okanye imiqolo okanye iipaneli) sisixhobo sokubonisa. Ngamanye amazwi, imiqolo neekholamu azitshintshi indawo yoqobo kwispredishithi sethu, kubonakala ngathi kubonakala ngathi ukusinceda.
Xa umsebenzi ugqityiwe, sinokubuyela kuwo "Khupha" imiqolo eqingqiweyo neekholamu. Ukwenza oku, kuya kufuneka singene kwi «Jonga» iwindow kwakhona kwaye singasebenzi ukhetho ebesikade silikhethile.
Ukwahlula iwindow kwi-Excel
Njengoko sele sibonile, injongo yokulungisa ikholamu ye-Excel ayisiyiyo enye ngaphandle kokuququzelela umsebenzi kunye neespredishithi ngendlela ebonakalayo ecacileyo kunye nokukhululeka kolu xwebhu. Kodwa ayisiyiyo kuphela inkohliso eya kusinceda. Kuxhomekeka kuhlobo loxwebhu okanye umsebenzi, kunokuba luncedo ngakumbi ukhetho lokwahlula i-Excel.
Ingaba oku kusebenza kubandakanya ntoni? Ngokusisiseko imalunga nokwahlula iscreen sepredishithi ukuze Fumana iimbono ezahlukileyo kuxwebhu olunye. Umzekelo, kwiscreen esinye sinokubona ikholamu yokuqala nalo lonke ulwazi oluqulathiweyo, ngelixa kwiscreen sesibini sinokuskrolela lonke uxwebhu.
Iscreen se-Excel sahlulwe kubini
Masibone ukuba olu khetho lunokusetyenziswa njani kwiMicrosoft Excel:
- Into yokuqala yokwenza kukuya, njengokhetho lwangaphambili, kwithebhu "Ukubona".
- Apho kuya kufuneka ukhethe ukhetho "Yahlula". Isikrini siya kwahlulwa ngokuzenzekelayo sibe ngamacandelo amane.
Ngale ndlela siza kufumana izimvo ezine ezahlukeneyo zoxwebhu olunye, ukusebenza ngamnye kubo. Kwaye ngaphandle kokusebenzisa i umqulu kaninzi-ninzi ukujikeleza ngaphezulu kwayo.
Kwaye ukuba izikrini ezine zininzi kakhulu (ngamanye amaxesha ngokuzama ukwenza izinto zibe lula siphela sizenza nzima ngakumbi), zikho ezinye iindlela sebenza nje ngescreen esahlulwe kubini. Kule meko kufuneka siqhubeke ngoluhlobo:
- Masibuyele umva "Ukubona", nangona ngeli xesha sikhethe ukhetho lwe "Iwindow entsha".
- Okwangoku sinokukhetha iindlela ezimbini: "Imbono efanayo" okanye enye "Lungelelanisa konke«. Kuzo zombini, isikrini siza kubonakala sahlulwe kubini, nangona sikhethe ukhetho lwesibini esinokukhetha phakathi kweendlela ezininzi zokubonisa: tye, nkqo, mosaic okanye cascading. Ngokuthanda kwethu.