Indlela ukudibanisa umtya Excel: iingcebiso, imizekelo

I 'Excel "kwi Microsoft Office - umhleli spreadsheet enamandla, evumela nje ukulondoloza idatha lwemiqolo nemihlathi, kodwa ukwenza izibalo entsonkothileyo yaye zingenise iziphumo ngendlela lomzobo.

Eli nqaku uhlaziye ngokweenkcukacha indlela yokuqhuba imigca ibekwe kwiphepha eliqhelekileyo iincwadi ngaphakathi ipleyiti eyenzelwe ngokukhethekileyo, yaye kwangaxeshanye bafunde ukubeka indlela umqolo kwindlela Excel-mqolo. Njengesiseko sithatha 2007 ukukhululwa Microsoft Office.

Iintlobo imisebenzi umtya kwi "Excel"

Umsebenzi ezifumanekayo ezisebenzayo imigca oku kunokuba umda (nti imibuzo ifomathi kunye nekopi):

• Ukukhetha;
• cola;
• isusa;
• ukufuduka;
• transposition.

Makhe sibone oko iindlela zokusombulula ezi ngxaki kwi "Excel 2007", yaye ukuba siqale, njengokuba iyimbalasane kwi Excel emgceni.

yokukhuhla

Amaxesha amaninzi, abasebenzisi inkqubo 'Excel' zabhidaniseka elithi "Phawula" ukhetho a esithile babacela ukuba ezahlukeneyo iiseli.

Xa "Excel 2007" umgca ezikhoyo eziquka 16.384 iiseli, kwaye ukuqaqambisa kwaso, cofa iqhosha ekhohlo kwanele nqakraza kwi izihloko ababalwayo, amalungiselelo nkqo ekupheleni iseleyo sheet.

Ukuba ufuna ukwaba imiqolo nje ezimbalwa iiseli, landela ukhetho, ngokubamba phantsi i ekhohlo iqhosha le mouse. Okanye ungafumana kuyo nayiphi iseli, cofa uze ubambe Shift + isitshixo Ctrl yaye, ngaphandle ukukhulula khona, cofa itolo "ekunene" okanye "ekhohlo", ngokuxhomekeke kuzakwenza ukhetho indlela.

Isilumkiso! Nazi ezinye bokuqonda. Ukuba yonke imigca iseli ezikhethiweyo ayinanto okanye izele data, uze uphawule kumgca phambi kokuphela kwimakhishithi, oko kukuthi ngoko nangoko. E. esiseleni nombolo 16, 384. Ukuba kwakukho "ipatheni isikhewu" (zonke iiseli zazingenanto yawuzalisa wadibana, okanye vice versa) , ukukhethwa ubaleka iseli ukuba "ukwahlula" kwaye yena, naye, uya kungena kuluhlu ekhethiweyo. Ngoko ke, nge indibanisela yezitshixo «Shift + Ctrl + Ekhohlo / Ekunene" kufuneka silumke.

Ngoku vula ku ukudibanisa indlela umqolo e-Excel.

Ngokufaka umqolo entsha

Good ukwazi! Line ngo "Eksele" isoloko wongezelela kwi isizalwane phezulu ukuya iseli ezikhethiweyo (s), iintsika - ekhohlo.

Inyathelo One. Ukuphawula iseli okanye uluhlu iiseli, okanye umtya yonke apho uceba ukongeza umgca omtsha.

Inyathelo lesibini. Wasebenzise ukhethe enye sineendlela ezimbini:

• Ngokucinezela i ekunene iqhosha lemouse ukuvula imenu yentsingiselo, leyo Ungaya "Faka" uze usebenzisa amaqhosha sikanomathotholo ukhethe 'umtya'. Nqakraza "OK", naphezu iseli yakho ekhethiweyo (s) iya kuba umgca entsha, engenanto ngokupheleleyo.
• Kwi le "Ekhaya" indlela emfutshane iribhoni mqulu iqela "Iiseli" - "Faka" - ". Imiqolo Faka kwimakhishithi"

Kwenziwe!

Njengoko ubona, emva ukuphunyezwa kwezi ngcebiso ufumana phezu data yakho umgca entsha ngokupheleleyo ungenanto.

Ngoko ke, ukuba ukongeza indlela umtya Excel, siyaqonda.

Ukususa emgceni

Kanye umqolo elitsha lifakwa, ekususweni ngokwaneleyo ukwenza iintshukumo nje emibini.

Inyathelo One. Wena ukuphawula umgca ofuna ukuyisusa, okanye ubeke nje ikhesa yakho kule nayiphi iseli kumqolo ukuba akuseyomfuneko.

kubaluleke kakhulu! Kungakhathaliseki nokuba sele umfumene iseli okanye kwalomqolo izakucinywa yonke umgca le ncwadi ngokupheleleyo - oko kukuthi, kwimeko i "Excel 2007" iseli kunye 1 ukuya th 16384. Ukuba ufuna kuphela ukucima data yakho evela iseli, kwanele ukuba usebenzise emva kokukhetha i Cima iqhosha kwi yezitshixo.

Inyathelo lesibini. Ukuba ukhethe kusuka:

• Ukucofa iqhosha lemouse ekunene ukuzisa imenu yentsingiselo, leyo yiya kwi "Delete", uze ngoncedo itshintshela ukhethe "Umgca". Cinezela "OK", yaye string "curdle" ngokungathi njengabangabangakho.
• Kwi le "Ekhaya" imfutshane ukususa tape kwiqela "Iiseli" - "cima" - ". Cima imiqolo ukusuka kuxwebhu"

Ukuhambisa line

Ngokushukumisa umgca kwakhona, abaninzi baqonde intshukumo uluhlu ethile encinane iiseli. Kodwa ke kule meko ezi iinketho Umgaqo amanyathelo ezahlukeneyo.

Khetha umgca lulonke okanye iiseli ngalinye. Ngoku yisa isalathisi kujongano ukhetho, isalathisi kufuneka ukutshintsha uthabathe ngohlobo iintolo ezahlukeneyo. Bamba phantsi i ekhohlo iqhosha le mouse kwi "ukufaka" iiseli zakho, yiya kwindawo entsha ezinqwenelekayo nokukhululwa. Ukuba indawo apho uthuthe, ukuba sele ezaliswe naziphi data, uya ngokuzenzekelayo kwenziwa endaweni imixholo iiseli ekujoliswe kulo.

imigca sokuguqulela

Abasebenzisi abaninzi "Excel" ukuqonda ngokukhawuleza ukudibanisa njani umtya Excel, ukuhamba okanye ikopi ngayo, kodwa transposition uhlala imfihlelo kwabaninzi, kwakunye kakhulu ubukho umsebenzi onjalo kule program.

umgca Transposition - inkqubo yokuguqulwa tye ukuya iseti nkqo ye iiseli. Ngako oko, le transposition ikholam - yinkqubo umva.

Option, njengoko uguqulo unako kwenziwa ezimbini:

• Khetha uluhlu iiseli umgca enye kwaye silandele up (ngokucinezela i ekunene iqhosha le mouse okanye indibanisela Ctrl + C). Okulandelayo, yima phezu kwiseli apho ongathanda ukuba uqale umhlathi yakho entsha ye data, vula i imenu yentsingiselo "Cola Special", apho ibhokisi "transpose". Kwenziwe! Umtya yaba column.

• Excel 2007 inomsebenzisi okhethekileyo - ". Transpose" Ukuba uza ukuguqula uluhlu leeseli emihlanu ngaphandle kwalomqolo Kwakhona bonisa kanye ezintlanu iiseli, kodwa zicwangciswe bomhlathi. Cofa uphawu "zilingana" kwaye ubhale "Transpose." parenthesis Vula and bonisa uluhlu yakho, nto leyo eza ukuguqula. Vala isibiyeli kwaye cinezela Ngena endaweni Shift nje Ctrl + + Ngena. Kwenziwe!

Kufuneka kuqondwe ukuba ngobuwena lokuqala (kunye faka ezizodwa) Kukhethwa ekubeni ngaba ukusebenzisa ifomula. Ukuba usebenzisa i yesibini khetho, uze ucime umtya wokuqala, ufumana zonke zero endaweni kumaxabiso azo.

Iitafile ngaphakathi incwadi kunye neempawu zazo

Ngaphandle unekhasi elisezantsi lwemiqolo nemihlathi zikhona kwakhona kuluhlu Excel. Bhala kubo ilula - ". Itheyibhile" ukhethe nje uluhlu oluchanekileyo iiseli, uze emva koko kwi tab "Faka" khetha Cinga umahluko phakathi iinkqubo lemiqolo yokusebenza okunjalo itafile imigca ezisebenza kwincwadi eqhelekileyo.

Kuyaqondakala ukuba ukwabiwa iiseli efanayo. Ukufaka okanye ukucima imiqolo ukusuka kwimeko menu kwezinto ezikhoyo "Faka - imiqolo Uluhlu phezulu" yaye "Cima - imiqolo ze itafile." Ukongeza, ungenza dibanisa ilayini entsha, nje ngokushukumisa isalathisi yeseli esezantsi ekunene etafileni kwaye cinezela Tab.

Kukho umahluko engephi kwintshukumo, kodwa zisebenza kuphela okuphezulu. Ukuba ukhethe iiseli enye okanye ngaphezulu equlathe i header itafile, kwaye landela intshukumo babo, uya kubona ukuba idatha ukhuphela nje kunye namagama original lema endaweni. Ukuba sizama ukususa etafileni lonke, ngoko akukho awohluke, bafudukela ngaphandle iingxaki.

Sinethemba lokuba phendla kuwe zonke iimfihlelo kwi ukudibanisa njani umtya Excel, ukucima indlela, siyashukuma yaye transpose umgca.