Sida loo dar string ah in Excel, talooyinka, tusaalooyinka

The "Excel" Xafiiska Microsoft - editor a isbiriidhshiit awood, kaas oo u ogolaanaya ma aha oo kaliya xogta dukaanka saf oo tiirar, laakiin sidoo kale in la xisaabiyo adag iyo in ay soo gudbiyaan natiijada qaab garaaf.

Maqaalkani waxa uu kala dhig si faahfaahsan sida ay ku shaqeeyaan khadadka ku yaalaa on sheet caadiga ah ee buugaagta gudaha saxan si gaar ah loogu talagalay, iyo waqti isku mid ah ay bartaan sida loo dhigo column ah ee Excel-xigta. Sida ku salaysan inaannu wax ka qaadannaa 2007 Xafiiska Microsoft in la sii daayo.

Noocyada hawlaha string ee "Excel"

The hawlaha la heli karo waa ay khuseyso inay khadadka waa halkii ku koobnayn (ma taabato format su'aalaha iyo nuqul):

• xulashada,
• paste;
• tirka;
• barakaca;
• transposition.

Ina keena aynu arki waxa siyaabo si ay u xaliyaan dhibaatada ee "Excel 2007", iyo in la bilaabo, sida highlight a in line Excel.

ee ka fujiyaan

Inta badan, dadka isticmaala barnaamijka 'Excel' qaldin erayga "muujiyo" ee doorashada ee gaar ah iyaga ayaa doonay inay kala duwan oo ka mid ah unugyada.

In the "Excel 2007" line la heli karo oo ka kooban 16.384 unugyada, iyo si loo muujiyo guud ahaanteed, riix badhanka bidix waa ku filan si ay u riix cinwaanka tiriyey, vertical diyaarin qarkiisa ka hadhay xaashida.

Haddii aad u baahan tahay in loo qoondeeyo oo kaliya dhowr saf oo unugyada, raac doorashada, haysta hoos badhanka mouse bidix. Ama waxaad ka heli kartaa oo ku saabsan wax kasta oo unug, saxaafadda iyo qaban Shift ah + muhiimka ah Ctrl iyo, iyada oo aan wax sii daayo, riix fallaadha "xaq" ama "tagay", iyada oo ku xidhan habka doono doorashada.

Digniin! Halkan waxaa ku qoran qaar ka mid ah Gudigga. Haddii dhammaan khadadka unugyada ee la doortay madhan ama data ka buuxiyey, ka dibna calaamadi line isla markiiba ka hor dhamaadka warqada, ie. E. Si gacanta lambarka 16, 384. Haddii ay jirto ahaa "hannaankii farqiga" (unugyada oo dhammu waxay ahaayeen madhan oo waxay buuxisay la kulmay, ama qeybsanaan ku xigeenka) , xulashada waddaa in gacanta in "Sharaf" oo iyana waxay, sidoo kale, tegi doonaa kala duwan oo la soo xulay. Sidaa darteed, la isku-dar ah furayaasha «Shift + Ctrl + Left / Right" u leeyihiin in ay taxaddar.

Waxaan hada u soo jeesataa sida loo dar isku xigta ee Excel.

Galinta xigta cusub

Good in aad ogaato! Line ee "Eksele" waxaa had iyo jeer ku daray at qaraabo sare in gacanta loo doortay (s), tiirarkii - bidixda.

Tallaabada One. Muujiyo cell ama kala duwan oo ka mid ah unugyada, ama xarig oo dhan on taas oo ay qorshaynayaan in ay ku darto line cusub.

Step Two. Ka faa'iidayso oo la doortay ka mid ah mid ka mid ah laba hawlgallada:

• By riixaya badhanka mouse xaq in la furo menu macnaha guud, kaas oo u tagi kartaa "Geli" ka dibna isticmaalaya badhamada radio in ay doortaan 'string'. Click "OK", iyo in ka badan gacanta loo doortay (s) uu noqon doono line cusub, si buuxda madhan.
• On the "Home" toobiye duudduuban xirmado u "Unugyada" group - "Insert" - ". Saf Insert on xaashida"

Sameeyey!

Sida aad arki karto, ka dib markii hirgelinta oo ka mid ah talooyin aad ka heli badan xogta aad line cusub maran.

Sidaas, sida loo dar string ah in Excel, waxaan u garan.

Takhalusid xigta

Like safka cusub la geliyo, ay ka saareen ku filan si ay u qabtaan falalka kaliya labo.

Tallaabada One. Waxaad muujiyo line aad rabto in aad uninstall, ama si fudud u dhigay aad dulqabo in gacanta kasta oo isku xigta in aad mar dambe ma u baahan tahay.

Aad muhiim u ah! Loo eegin in aad u qeexday cell ama kala duwan oo laga tirtirayaa line oo dhan kitaabka gebi - taas oo ah, in ay dhacdo ka mid ah "Excel 2007" waa unug la 1aad si 16384 th. Haddii aad rabto oo kaliya in ay nadiifiso xogta aad ka gacanta, waxa ku filan si ay u isticmaalaan ka dib xulashada badhanka Delete on keyboard ah.

Step Two. Si aad u doorato ka:

• Riixaya badhanka mouse xaq inay soo qaadaan menu macnaha ah, kuwaas oo u taga "Delete", ka dibna iyadoo la kaashanayo shido in ay doortaan "Line". Press "OK", oo xarig ah "curdle" sida haddii ay aan weligood ahaanin.
• On the toobiye "Home" in ay u guuraan cajalad kooxda "Unugyada" - "tirtirto" - ". Delete saf ka xaashida"

Guuritaanka khadka

By mar kale u dhaqaaqin khadka, ugu fahmo dhaqdhaqaaqa a kala duwan oo yar yar oo gaar ah unugyada. Laakiin kiiskan fursadaha sameeyaa mabda'a garoomada waa ka duwan yahay.

Dooro line oo dhan ama unugyada shaqsi ay. Markaas ka guurto dulqabo in ay doorashada interface ah, dulqabo waa in ay isbeddelaan oo qaadan foomka of fallaadho kooxa kala duwan. Qabo hoos button mouse bidix si ay "qabsadaan" unugyada, guurto meesha cusub la doonayo iyo in la sii daayo. Haddii meesha aad guurto, waxaa la horey u buuxiyey xog kasta, si toos ah aad u soo bandhigi doonaa si uu u bedelo ka kooban unugyada bartilmaameedka.

khadadka Transposing

dadka isticmaala badan yihiin "Excel" in si deg deg ah u fahmaan sida ay u dar string ah in Excel, sida ay u guurto ama nuqul, laakiin transposition weli qarsoon badan, iyo sidoo kale jiritaanka aad u of function ah ee barnaamijka sida.

line Transposition - geeddi-socodka ah ee diinta dadban ay u set toosan unugyada. Iyadoo la raacayo, transposition column ah - waa hab dambe.

Xulashada, sida diinta waxa lagu samayn karaa laba:

• Xulo kala duwan ee unugyada ka mid ah line iyo dabagal (adigoo riixaya badhanka midigta mouse ama isku-dar ah Ctrl + C). Next, taagan on unug meesha aad jeclaan lahayd in aad dib u bilowdo column cusub ee xogta, furi menu macnaha "dhaji Gaarka ah", halkaas oo checkbox ah "beddelo". Sameeyey! String galay column noqotay.

• Excel 2007 leeyahay feature gaar ah - ". Beddelo" Haddii aad si loogu badalo kala duwan oo ka mid ah shan unugyada waa ka baxsan kala duwan this sidoo kale muujiyo si sax ah shan unugyada, laakiin diyaarin khaanadda a. Riix calaamada "siman" oo waxaad ku qortaa "beddelo." qaws Open iyo muujiyo aad kala duwan, kuwaas oo la doonayo in loogu badalo. Xir ee qaybta iyo saxaafadda gala halkii kaliya Ctrl + Shift + gala. Sameeyey!

Waxaa la fahamsan yahay in muuqashadii ugu horeeyay (oo leh insert gaar ah) waa ka fiican tan ma aysan isticmaali caanaha. Haddii aad isticmaasho ikhtiyaarka labaad, ka dibna u tirtirto string asalka ah, waxaad ka heli oo dhan sddexda meel ka mid ah qiimaha ay.

Shaxan gudaha kitaabka iyo qaababka ay

Ka sokow sheet caadiga ah ee saf oo tiirar sidoo kale ka jira miiska Excel. Qor iyaga waa mid fudud - ". Table" kaliya dooro kala duwan ee saxda ah ee unugyada, ka dibna on tab ah "Geli" dooro Ka fikir farqiga u dhexeeya habka of saf hawlgalka ee kala sareynta horyaalka ka mid ah khadadka ka hawlgala kitaabkii caadiga ah sida.

Waxaa la fahamsan yahay in qoondaynta of unugyada isku. Si aad u geliso ama tirtirto saf ka menu macnaha guud ee alaabta la heli karo ee "Insert - saf Shaxda kor ku xusan" iyo "Delete - saf oo miiska." Intaa waxaa dheer, waxaad ku dari kartaa line cusub, si fudud u dhaqaajinaya dulqabo in ay gacanta hoose midig ee miiska iyo riix Tab.

Waxaa kaloo jira farqi yar oo dhaqdhaqaaqa, laakiinse iyagoo keliya ayaa codsan in madax. Haddii aad doorato mid ka mid ah ama ka badan unugyada ku jiraan madax miiska, waxayna raaceen dhaqdhaqaaqa, waxaad arki doontaa in xogta aad nuqul ka iyo koobab asalka ah ayaa ku hadhay meel. Haddii aan isku dayno in miiska oo dhan ka guurto, ka dibna waxaa jira dhegyadii lahayn, dhaqaaqay dhibaato la'aan.

Waxaan rajaynaynaa in laguu waxyooday oo dhan qarsoon ee ku saabsan sida loo dar string ah in Excel, sida in ay tirtirto, dhaqaaqo oo beddelo line.