Canja wurin tebur a cikin Excel

Tabbas kowane mai amfani da ke aiki a cikin Excel ya gamu da yanayin da ake buƙatar musanya layuka da ginshiƙan tebur. Idan muna magana game da ƙaramin adadin bayanai, to ana iya aiwatar da hanyar da hannu, kuma a wasu lokuta, lokacin da akwai bayanai da yawa, kayan aikin musamman zasu zama masu amfani sosai ko ma ba makawa, waɗanda zaku iya kunna tebur ta atomatik. . Bari mu ga yadda aka yi.

Taswirar tebur

Juyawa - wannan shine "canja wuri" na layuka da ginshiƙan tebur a wurare. Ana iya yin wannan aikin ta hanyoyi daban-daban.

Hanyar 1: Yi amfani da Manna Musamman

Ana amfani da wannan hanyar sau da yawa, kuma ga abin da ta kunsa:

1. Zaɓi tebur ta kowace hanya mai dacewa (misali, ta hanyar riƙe maɓallin linzamin kwamfuta na hagu daga saman tantanin hagu zuwa ƙasa dama).
2. Yanzu danna dama akan yankin da aka zaɓa kuma zaɓi umarni daga menu na mahallin da ke buɗewa. “Kwafa” (ko a maimakon haka kawai danna haɗin Ctrl + C).
3. A kan wannan ko a kan wani takarda, mun tsaya a cikin tantanin halitta, wanda zai zama babban tantanin halitta na hagu na tebur da aka juye. Muna danna-dama akansa, kuma wannan lokacin muna buƙatar umarni a cikin menu na mahallin "Manna Na Musamman".
4. A cikin taga da yake buɗewa, duba akwatin da ke kusa "Mai fassara" kuma danna OK.
5. Kamar yadda muke iya gani, tebur mai jujjuyawa ta atomatik ya bayyana a wurin da aka zaɓa, inda ginshiƙan tebur na asali suka zama layuka kuma akasin haka. Yanzu za mu iya fara keɓanta bayyanar bayanan zuwa yadda muke so. Idan ba a ƙara buƙatar tebur na asali, ana iya share shi.

Hanyar 2: Aiwatar da aikin "TRANSPOSE".

Don jujjuya tebur a cikin Excel, zaku iya amfani da aiki na musamman "TRANSP".

1. A kan takardar, zaɓi kewayon sel waɗanda ke ƙunshe da layuka da yawa kamar yadda akwai ginshiƙai a cikin tebur na asali, kuma akan haka, iri ɗaya ya shafi ginshiƙan. Sannan danna maballin "Saka aikin" zuwa hagu na mashayin dabara.
2. A cikin bude Mayen Aiki zabi nau'i "Cikakken jerin haruffa", mun sami mai aiki "TRANSP", yi alama kuma danna OK.
3. Tagar muhawarar aikin za ta bayyana akan allon, inda kake buƙatar tantance daidaitawar tebur, akan abin da za a yi jujjuyawar. Kuna iya yin wannan da hannu (shigar allo) ko ta zaɓin kewayon sel akan takarda. Lokacin da komai ya shirya, danna OK.
4. Muna samun wannan sakamakon akan takardar, amma wannan ba duka ba.
5. Yanzu, domin tebur ɗin da aka canjawa ya bayyana maimakon kuskuren, danna maballin dabara don fara gyara abubuwan da ke cikinsa, sanya siginan kwamfuta a ƙarshensa, sannan danna haɗin maɓallin. Ctrl + Shigar + Shigar.
6. Don haka, mun sami damar yin nasarar sauya tebur na asali. A cikin mashaya dabara, mun ga cewa yanzu an tsara furcin da takalmin gyaran kafa.lura: Ba kamar hanyar farko ba, ba a adana tsarin farko a nan ba, wanda a wasu lokuta yana da kyau, tun da za mu iya saita komai daga karce yadda muke so. Har ila yau, a nan ba mu da damar da za mu share asali tebur, tun da aikin "jawo" da bayanai daga gare ta. Amma fa'idar da babu shakka ita ce, an haɗa allunan, watau duk wani canje-canje ga ainihin bayanan za a bayyana nan da nan a cikin waɗanda aka canza.

Kammalawa

Don haka, akwai hanyoyi guda biyu da zaku iya amfani da su don canza tebur a cikin Excel. Dukansu biyu suna da sauƙin aiwatarwa, kuma zaɓi na ɗaya ko wani zaɓi ya dogara da ƙarin tsare-tsaren don aiki tare da bayanan farko da aka karɓa.