Indlela yokwenza umqolo e Excel line, ukuwasa uze ulungise ukuphakama?

Microsoft Excel software kakhulu zithandwa ngenxa ubunjalo yayo. Esi sicelo ingasetyenziswa kuwo onke amacandelo msebenzi. Excel angasebenza nje kuphela, kodwa kwakhona ukunika ingcaciso ngohlobo iigrafu neetshathi. Abameli imisebenzi ezahlukeneyo isixa esikhulu yomsebenzi owenziwe kanye ngenxa yale nkqubo.

Phantse bonke abasebenzisi PC ubuso imfuneko ukusebenza Microsoft Excel. Izihloko ezifana umgca ukudityaniswa, iinombolo oluzenzekelayo, okanye indlela yokwenza umqolo e Excel line, kakhulu efanelekileyo.

Ukusebenza Excel: inani kwimigca nobude lwabo

version nganye kufuna inani elithile lemiqolo. Ngo-MS Excel 2003, ungasebenzisa le migca 65.536, yaye ngo-MS Excel 2010 - esele 1.048.576.

Igama elithi 'ubude bomtya "liquka bokuqonda ezimbini. Esi salathisi lungabaleka inani leseli kunye inani loonobumba wangena kule seli.

Ngo-MS Excel-2003, inani lwemihlathi ngu 256. Amathuba omkhulu ngokulungiselela MS Excel 2010 - 16 384 iiseli.

Zombini iinguqulelo Sinenani elifanayo zabalinganiswa esiseleni, apho abalinganiswa 32.767. Esiseleni, zonke ezi abalinganiswa, Kakade ke, ingabonakali, kodwa bunokubonwa ibha yefomyula le.

Indlela ukufaka kwaye ukucima imiqolo e Excel?

Ukusombulula ingxaki ngeendlela ezimbini:

• Ukusebenzisa umxholo menu. Kuyimfuneko ukuba ukhanyise kwindawo ethile apho aya khona umgca, uze usebenzise i ekunene iqhosha lemouse ukunqakraza i menu. Emva kokukhetha "Faka" "Umgca" livela. Kuyimfuneko ukuqinisekisa isenzo ngokunqakraza "Kulungile".
• Esebenzisa panel yolawulo. Kufuneka ukhethe indawo komgca nakwiqela lenjongo yolawulo ukufumana i "Main" tab, cofa "Faka" emva koko "Faka Row".

Isusa imiqolo lwenziwa ngendlela efanayo, kodwa endaweni kwento "Faka" kuyimfuneko unqakraze ku "Cima."

Umqolo ukuphakama in Excel

Le parameter lilawulwa ngeendlela ezininzi. Eyona lula kwaye kulula - ngayo ukutshintsha ukuphakama ngokusebenzisa i mouse. Ikhesa kufuneka zibekwe kumgca inani, uze ubambe iqhosha, olule okanye compress phantsi ngokobungakanani.

Kwakhona Ungalutshintsha ukuphakama ngalo panel yolawulo. Xa "Ekhaya" ukukhetha "Format" kwaye ngoku nqakraza "Umqolo Height". Kwi window oyifunayo ukukhankanya ixabiso olifunayo indlela kwimeko ethile.

Zombini iinguqulelo ifuna ukhetho oluzenzekelayo le ukuphakama. Oku kuyimfuneko ukuba ufuna ukutshintsha isethingi yombhalo ukuba kukho. Noko ke, xa usebenzisa lo msebenzi, kufuneka wazi ukuba umyalelo uya kubulawa kuphela xa bhokisi ikhangelwe "Wrap" kwi "ulungelelwaniso" tab. Kumphakamo womlinganiselo anokuthi abekwe - yona yindlela amaxabiso 409.

Le kudweliswe imiqolo e Excel

Ukuba kuyimfuneko, amaqela imigca kufuneka bakhethe kwaye yiya kwi "Data 'tab. Kuya kufuneka ukuba ukhethe i "Ulwakhiwo" - "Group".

imiqolo Ungrouping ngu mfanekiso, nqakraza nje "ukubuthana".

Kwaye ukuba ufuna imigca embalwa?

Abantu abaninzi banomdla ukwenza indlela umqolo e-Excel emgceni. Kwakhona akukho nto ibitheni ngotywala. Ukuze wenze e-Excel imigca embalwa mkrozweni mnye, kufuneka usebenzise Alt emfutshane yezitshixo + Ngena. Transfer iya kuqaliswa ngqo esiseleni, ufakelo lweenkcukacha kuqhubeka nge umhlathi.

imigca Hidden nemephu agcina

Ngamanye amaxesha xa usebenza Iprogram i-Excel, kuyimfuneko ukufihla imiqolo. Oku kungenziwa ngokusebenzisa i ekunene iqhosha le mouse. Emva ebiza imenu yentsingiselo, khetha "Fihla" emva kokukhetha iziqwenga ethile.

Kwimeko apho ufuna ukubonisa imiqolo efihlakeleyo, isenzo kufuneka ngolu hlobo lulandelayo: khetha iziqwenga kuyimfuneko ukuba zifake kwanabo ukuba ngasentla okanye ngezantsi uluhlu ethile. Koko, emva kokunqakraza i ekunene iqhosha le mouse, uya kubona i menu kwimeko apho kufuneka ukhethe "Bonisa".

Concatenation ne Excel

Xa ukwenza iitafile yinto inkalo kubalulekile ukuba ekuvumela hlanganisa iiseli. Ukuze le njongo, amaziko athile kwaye khetha tab ufuna ukukhetha "Ekhaya", ngoko ke umsebenzi "Hlanganisa" kunye "Yisa embindini." Ukuba kuyimfuneko, uyakwazi ukukhetha ezinye iindlela ukuze bajoyine. Ngoku uyazi ukuba wenze njani umqolo e-Excel line nendlela yokulawula kubo. Qaphela ukuba la manyathelo zibalulekile ekusombululeni iingxaki kule program elinikiweyo.

Ngendlela, ukuba enze amanyathelo kwakhona, umyalelo yangaphambili luya kurhoxiswa.

Yintoni a macro yaye yintoni na ke ngenxa?

abasebenzisi abaninzi baye badibana apho elithi "macro", kodwa wonke umntu uyazi ukuba yintoni na. A macro yinkqubo equlathe imiyalelo ethile kunye nezenzo ukuba - xa isicelo okanye hayi - ingabonakaliswa ngqo okanye ngokungathanga ngqo.

Macro ezibhalwe badwelisi benkqubo okanye abasebenzisi avumela ngokuyinxenye imishini ukunciphisa ixesha elifunekayo ukugqibezela lo msebenzi.

Xa sisebenza kunye omkhulu kunye nomthamo data ukuba lumakishwe, umntu uchitha ixesha elininzi kwi izenzo phinda. Yenza macro eya kuba nako ukwenza imisebenzi enjalo ngokwazo, umsebenzisi-Excel iya kubasindisa iiyure zomsebenzi. Ukongeza, oluyilwe kakuhle mini-nkqubo unako we ubhaqa indlela yonke impazamo ngomatshini, nto leyo eyenza lo msebenzi lula kwaye kube lula ngakumbi.

ingozi macro

imacros zesikocan usebenzisa kuxhomekeke imingcipheko ethile. umdwelisi nkqubo kwezinto Ungayila yintsholongwane, uwusondeza njengokuba macro eza kuwabhuqa onke data kwaye ibangele ukungasebenzi. Ukongeza, le nkqubo inakho ukusebenza njenge hlola ngokufunda zonke iinkcukacha.

yokugoqa

Transfer imigca Excel kunokuphunyezwa ngeendlela ezininzi. Kwimeko apho kufuneka ufake isixa esikhulu zabalinganiswa, ungabeka "umbhalo Eliqukuqela kwizisele ezikufutshane." Inkqubo umsebenzi Ke ezi nkcukacha ziya kuboniswa kwi kwiilayini eziphanda-phindiweyo.

umbhalo Long zinokunyangwa ukuze yafakwa ebhokisini. Ukuze wenze oku, khetha i tab "Faka" emva koko "Okubhaliweyo" yaye "lesaziso". Ngoko ke ungaqala ukuchwetheza. Kwi bokisi yemiyalezo, unako ukwenza ufomato umbandela efakiweyo ngaphandle reference ngokwemida.

Indlela elula yokwenza umqolo e Excel, - kukuba wasishenxisa nge mouse. Kuyimfuneko ukuba ukuhambisa isalathisi ukuya iseli ezikhethiweyo kwaye bamba i ekhohlo iqhosha le mouse, tsala indawo yokhetho kwindawo entsha. Yenza lo msebenzi, ungakwazi kwi "Options" - "Advanced".

Ukwazi ukwenza indlela umqolo kwi Excel kumqolo nokuba nezinye izakhono ezisebenzisekayo, uya ngokuqinisekileyo kwenza kube lula ukusebenza kunye nenkqubo nokwandisa imveliso, ukonga ixesha emsebenzini.