Indlela yokwenza ilandelana Excel umugqa, uzihambise futhi ulungise ukuphakama?

isofthiwe ye-Microsoft Excel kuyinto zithandwa ngenxa ehlukile yayo. Lolu hlelo lokusebenza ingasetshenziswa kuyo yonke imikhakha yomsebenzi. Excel abakwazi kuphela sebenza ngeenomboro, kodwa futhi ukunikeza ulwazi ngesimo emagrafu nemashadi. Abamele ubuchwepheshe ezahlukene semali yomsebenzi owenziwe ngokunembile ngenxa lolu hlelo.

Cishe bonke abasebenzisi PC nazo isidingo ukusebenza e-Microsoft Excel. Izihloko ezifana umugqa ukuhlanganisa, izinombolo othomathikhi, noma indlela yokwenza ilandelana Excel umugqa, ngempela efanele.

Ukusebenza nge-Excel: inani lemigqa kanye nobude zabo

ngenguqulo ngayinye idinga inombolo ethile imigqa. Ngo-MS Excel 2003, ungasebenzisa imigqa 65.536, futhi MS Excel 2010 - kakade 1.048.576.

Igama elithi "ubude string" kuhlanganisa ezicashile ezimbili. Le nkomba lingalinganiswa e inani lamaseli bese inani lezinhlamvu angafakwa ngaphakathi esitokisini.

Ngo-MS Excel 2003, inani amakholomu kuyinto 256. I namathuba angcono ukuhlinzeka MS Excel 2010 - 16 384 cells.

Zombili izinguqulo babe inani elifanayo izinhlamvu kuseli, okuyinto izinhlamvu 32.767. Kuseli, zonke lezi zinhlamvu, yebo, ingabe isabonwa, kodwa kuyabonakala kubha ifomula.

Indlela ukufaka uphinde ususe imigqa Excel?

Ukuze kuxazululwe le nkinga ngezindlela ezimbili:

• Ukusebenzisa imenyu yengqikithi. Kuyadingeka ukugqamisa endaweni ethile lapho umugqa uzobe elise, bese usebenzisa inkinobho yegundane kwesokudla chofoza imenyu. Ngemva kokukhetha "Faka" "Umugqa" livela. Kuyadingeka ukuqinisekisa isenzo ngokuchofoza "OK".
• Through the control panel. Kufanele ukhethe indawo emgqeni futhi phezu control panel ukuthola "Okukhulu" ithebhu, chofoza "Faka" bese "Faka Umugqa".

Ukususa imigqa wenziwa ngendlela efanayo, kodwa kunalokho kwento "Faka" kubalulekile ukuba chofoza "Susa."

Ukuphakama irowu Excel

Lokhu ipharamitha kulawulwa ngezindlela eziningana. I elula kunazo futhi kulula - kuba ukushintsha ukuphakama ngokusebenzisa igundane. Isikhombisi kumele ibekwe umugqa izinombolo, bese ubamba inkinobho, welule noma cindezela phansi yobukhulu.

Futhi ungakwazi ukushintsha ukuphakama esebenzisa control panel. Esikhathini "Ekhaya" ukukhetha "Ifomethi" bese uchofoza ku- "Umugqa Ukuphakama". Ku-window ufuna ucacise value ofuna endabeni ethile.

Zombili izinguqulo zidinga Ukukhetha ngokuzenzekelayo ukuphakama ilandelana. Lokhu kuyadingeka uma ufuna ukushintsha izilungiselelo ngokuvumelana umbhalo okungukuthi lapho. Nokho, lapho usebenzisa lo msebenzi, udinga ukwazi ukuthi umyalo ngeke abulawe kuphela uma bhokisi ulithola "Goqa" ku "Ukuhambisana" ithebhu. Ukuphakama esiphezulu ukuthi kungenziwa isethwe - kuba amagugu 409.

Ukubuthelela imigqa Excel

Uma kudingekile, amaqembu imigqa kudingeka ukhethe kubo bese uya "Idatha" ithebhu. Kube kuyodingeka ukhethe "Ukwakheka" - "Iqembu".

imigqa Ungrouping by Isifaniso, vele uchofoze "Khipha ukubuthana".

Futhi uma udinga imigqa embalwa?

Abantu abaningi banesithakazelo indlela yokwenza ilandelana Excel umugqa. Kukhona into ebalulekile. Ukuze Excel imigqa embalwa ilandelana, udinga ukusebenzisa Alt sekhibhodi + Enter. Dlulisa luzoqala ngqo kuseli, kufakwa uyaqhubeka isigaba.

imigqa Hidden kanye nokuhlela yabo okwalandela

Ngezinye izikhathi lapho esebenza uhlelo Excel, kubalulekile ukuba ufihle imigqa. Lokhu kungenziwa ngokusebenzisa inkinobho yegundane kwesokudla. Ngemva kokubiza leli imenyu yengqikithi, khetha "Fihla" ngemuva kokukhetha izingcezwana ezithile.

Esimweni lapho ufuna ukubonisa esemigqeni efihliwe, isenzo kufanele kube ngale ndlela: ukhethe izingcezu ezidingekayo ukuze uthwebule ngisho lawo singaphezu noma ngaphansi uhla othize. Khona-ke, emva ngokuchofoza inkinobho yegundane kwesokudla, uzobona imenyu yokuqukethwe lapho kufanele ukhethe u "Bonisa".

Concatenation ne-Excel

Lapho edala amatafula yisici kubalulekile esikuvumela ukuhlanganisa amaseli. Kuze kube yimanje, amasayithi athile bese ukhetha ithebhu ufuna ukhethe "Ekhaya", ngakho-ke umsebenzi "Hlanganisa" futhi "Yisa phakathi nendawo." Uma kunesidingo, ungakhetha ezinye izindlela ukuze ujoyine. Manje ngoba sewuyazi ukuthi indlela yokwenza ilandelana Excel umugqa nokuthi ukuphatha kwabo. Phawula ukuthi lezi zinyathelo kubalulekile ekuxazululeni izinkinga ohlelweni inikezwe.

By endleleni, uma futhi benze izinyathelo, umyalo odlule izokhanselwa.

Uyini Macro futhi ziyini na?

Abasebenzisi abaningi baye nazo igama elithi "imakhro", kodwa hhayi wonke umuntu uyazi ukuthi. A Macro uhlelo equkethe iziyalezo eziqondile futhi izenzo - ngesicelo noma cha - ingaboniswa ngokuqondile noma ngokungaqondile.

Amamakhro eyabhalwa program noma abasebenzisi vumela kancane ngokuzenzakalelayo futhi sinciphise isikhathi kudingeka ukuqedela umsebenzi.

Lapho ukusebenza emikhulu kanye ivolumu idatha alunge, umuntu echitha isikhathi esiningi kwizenzo okuphindayo. Dala Macro ukuthi bazokwazi ukufeza imisebenzi efana bebodwa, Excel umsebenzisi uyosindisa sokusebenza. Ngaphezu kwalokho, kahle yakhelwe mini-hlelo uyakwazi ukuthola sonke isiphambeko mechanical, okwenza ukusebenza esikahle futhi kulula.

ingozi Macro

Ukusebenzisa ama-macros angaphansi izingozi ezithile. uMklami angathembekile ungakha igciwane, uletha njengoba Macro ukuthi aphange yonke idatha futhi kubangele ukungasebenzi. Ngaphezu kwalokho, lolu hlelo ingasebenza njengendlela hlola ngokufunda yonke imininingwane.

ukugoqa

Dlulisa Excel imigqa Kungafezani ngezindlela eziningana. Esimweni lapho kufanele ufake imali enkulu izinhlamvu, ungabeka "Umbhalo ogelezayo e amaseli aseduze." Uhlelo umsebenzi Khona-ke ulwazi azoboniswa kolayini abaningana.

umbhalo omude zingelashwa ukuze yafakwa ebhokisini. Ukuze wenze lokhu, ukhethe ithebhu "Faka" bese "Umbhalo" futhi "Igama-ncazo". Khona ungaqala ukuthayipha. Ebhokisini umbhalo, kungenzeka ukuba bafeze ukufometha impahla ebiyelwe ngaphandle kukhulunywa imingcele.

Indlela elula ukususa umugqa Excel, - kuyinto ukulihambisa igundane. Kuyadingeka ukuba hambisa isikhombisi iseli akhethiwe bese ubamba inkinobho yesinxele, hudula indawo Ukukhetha endaweni entsha. Vumela lesi sici, unga ku "Izinketho" - "Okuthuthukisiwe".

Ukwazi indlela yokwenza ngumugqa Excel ilandelana unezinye futhi ezisebenzisekayo, nakanjani wenze kube lula ukusebenza ohlelweni futhi ukwandisa umkhiqizo, londoloza umsebenzi isikhathi.