Yadda za a gyara yankin da ke Foreved

Lokacin aiki tare da mahimman adadin bayanai akan takardar maƙunsar, dole ne ku bincika wasu sigogi koyaushe. Kuma dã mutãne da yawa daga cikinsu, kuma samãwarsu sunã ƙetare haddisuwan allo, kuma ya fi ƙarfin iyalan. Excel Masu haɓakawa kawai sun kula da dacewa da masu amfani, gabatar da wannan shirin yiwuwar inganta yankuna. Bari mu gano yadda ake aiwatar da wannan fasalin da yadda ake amfani da shirin Microsoft Excel.

Da sauri yankin a fice

Za a nuna mafita game da aikinmu na yau game da tsarin Excelon shirin da yake ɓangare na Microsoft Office 365 (2019), matakan da suka wajaba don gyara yankin ana yin su a daidai hanya.

Zabi 1: Yankin Strings

Sau da yawa a cikin e-tebur Excel, ya zama dole don gyara yankin daga layi sama da yawa, waɗanda suke da kira da ake kira hula. Ana yin wannan kamar haka:

Mai da hankali kan layin layin a gefen (hagu), zaɓi maɓallin Hagu, zaɓi maɓallin hagu na hagu (lkm) gwargwadon layin da aka riga aka gyara. A cikin misalinmu, zamu ɗaure layin uku na farko, shine, ya zama dole a ware a wannan yanayin na huɗu.

Zabi layin ƙasa don tabbatar da yankin kirtani a cikin filin Microsoft Excel

Je zuwa shafin "Duba" Toolbar, Barcelon, fadada menu na "amintaccen yanki".

Canji zuwa Ingantaccen Yankin Yankin A kwance a cikin Tabirin Microsoft Excel

A cikin jerin zaɓuɓɓukan da aka nuna, zaɓi zaɓi zaɓi kawai ya dace da manufar mu - "a shigar da yankin".

Amintar da yankin daga layuka a cikin tebur mai dacewa na Microsoft

Wannan shine yadda sauƙin zai iya gyara yankin kwance wanda ya kunshi layin da yawa, a cikin teburin lantarki mai kyau.

Misalin aikin da ya samu na samun nasarar yankin layuka a teburin Microsoft Excel Teburin

Zabin 2: Yankin ginshiƙai

Hakanan yana faruwa cewa ya zama dole a ɗaure saman tebur, amma gefe, wato, ginshiƙan da ke gefen hagu. Algorithm na ayyuka a wannan yanayin iri ɗaya ne, amma tare da takaitaccen gyara.

Haskaka ginshiƙi bayan kewayon waɗanda ke shirin gyara. A cikin misalinmu, Cikakkin C Cankn shine, wato, za mu gyara kewayon A-B.

Zabi na shafi bayan kewayon don kiyaye a cikin filin Microsoft Excel

Bude shafin gani kuma yi amfani da "amintaccen yanki".

Je ka tabbatar da yankin daga ginshiƙai a Table Microsoft Excel

Zaɓi zaɓi na farko daga jeri wanda kwafin sunan babban abu kuma ya ambata mana a sashin da ya gabata.

Amintaccen yanki na yanki a cikin filin Microsoft Excel

Daga wannan lokacin, yankin da aka tsara yanki (hagu) za a gyara, kuma lokacin da aka gungura tebur a cikin madaidaiciyar shugabanci, zai zauna koyaushe a wurin sa.

Sakamakon nasarar samar da ginan a cikin filin Microsoft Excel

Zabin 3: Yankin Layuka da ginshiƙai

Dangane da gaskiyar cewa bayanan da ke cikin sel, wanda galibi ana buƙatar ci gaba a gaban idanun, ana iya kasancewa a cikin manyan kayan aikin Excel ya ba ku damar gyara duka biyu na farko da na biyu. Don wannan:

Haske ta latsa LCM cewa tantanin halitta wanda yake a ƙasa layuka da kuma haƙƙin ginanniyar da kake son gyara, sannan je zuwa shafin "Duba" shafin.

Misali: Domin gyara layin farko na farko (12) da kuma shafi (A, b) , zaɓi tantanin halitta tare da adireshin C3.
.
A cikin filin "taga" shafuka kayan aikin, yi amfani da abu "shigar da yankin"

Kuma a cikin jerin da ke buɗe, zaɓi zaɓi ɗaya.

Rarraba yankin layuka da ginshiƙai a cikin tebur mai kyau na Microsoft

Yanzu, tare da gungura a tsaye na tebur, tsayayyen layin zai kasance a wurin,

Kuma tare da madaidaitan ginshiƙai zai kasance.

Yankin ginshiƙai yana da sihrinari a cikin filin Microsoft Excel

Siffar aikin da aka yi la'akari dashi a cikin wannan bangare ita ce mafi fassarar ta zahiri "ta ƙarfafa yankin". Yi kewayon kewayon daga layuka da kuma ginshiƙai na iya buƙata lokacin da na sama ɓangaren falle shine hat, kuma gefe, lambobi, jerin lambobi da cikakken sunan ma'aikata.

Yankin na ginshiƙai da layuka suna kama da teburin Microsoft Excel

Zabi 4: shafi na daya ko layi daya

Idan a karkashin karfafa yankin, kuna nuna wani gyara na kashi ɗaya kawai na tebur, wato, shafi ko shafi ɗaya ko shafi ɗaya, ana yin komai sosai. Kuna kawai haskaka ɓangaren da ake so, sannan zaɓi kayan da suka dace da aikinku a maɓallin "amintaccen yanki". A madadin haka, ba za ku iya ware komai ba kwata-kwata, kuma kawai zaɓi nan nan da nan zaɓi na zaɓuɓɓuka "ko" ɗaure saman shafi na farko ", wanda ke ɗaure kan abin da aiki yake a gabanka. Wannan hanyar, kazalika da nuancesanda zasu iya aiwatar da aiwatarwarsa, an dauke mana da mu a cikin labarai daban, kuma muna bayar da shawarar sanin kansu.

Gyara layi ɗaya ko shafi guda ɗaya a cikin tebur na Microsoft Excel

Kara karantawa: Yadda ake kiyaye layi ɗaya ko shafi ɗaya

Zubar da yanki mai santsi

A cikin taron cewa bukatar karfafa yankin (kirtani, ginshiƙai ko kewayon hadari ba komai bane, kamar yadda ake ganin a sama. Bambancin kawai shine "Gyara yankin" menu na farko kuma mafi kyawun abu a cikin wannan mahallin don "cire yankuna masu kafa".

Cire saurin rows da ginshiƙai a cikin tebur mai inganci na Microsoft

Ƙarshe

Snap da igiyoyi, ginshiƙai ko fadakar da kewayonsu a cikin Microsoft Excelordet yana da sauƙi. Babban abu a wannan yanayin daidai fahimtar yadda kashi na tebur dole ne a kasafta shi, kuma mun fada dalla-dalla a cikin labarin yau.