Fayil ɗin Tsara - Maɓallan zafi a cikin Excel

Microsoft Office Excel yana da aikin da ke saita tsari iri ɗaya don guntuwar tebur da yawa a lokaci guda. Wannan labarin zai bayyana ainihin fasalin zaɓin.

Yadda ake kunna Format Painter

Kuna iya kunna wannan yanayin kamar haka:

1. Bude Excel kuma zaɓi tantanin halitta wanda daga ciki kake son kwafi tsarin.
2. Je zuwa sashin "Gida" a saman babban menu kuma danna maɓallin "Format Painter". Yana kusa da kalmar "Saka".

3. Zaɓi kewayon sel a cikin tebur ɗin da kuke son aiwatar da tsari iri ɗaya da ainihin kashi. Lokacin da mai amfani ya saki maɓallin linzamin kwamfuta na hagu, an gama aikin.

Kula! Bayan kunna wannan aikin, alamar tsintsiya za ta bayyana kusa da daidaitaccen siginan kwamfuta a cikin Excel.

Siffofin Mai Zanen Tsarin

Don ƙarin fahimtar batun, ya zama dole a yi la'akari da dama da dama waɗanda irin wannan tsarin ke da shi. Akwai da dama daga cikinsu:

1. Ikon kwafin sigar tantanin halitta ɗaya. Adadin sel waɗanda zaku iya kwafi tsarin ba su iyakance ba.
2. Ayyukan ya shafi duka layuka da ginshiƙai na kowane tebur. Bugu da ƙari, kewayon abubuwan da aka zaɓa za su yi daidai da ainihin ɗaya.
3. Tare da taimakon wannan zaɓi, yana yiwuwa a cire tsarin da ba dole ba daga wasu sel na tsararrun tebur.
4. Idan ka danna maɓallin tsari sau biyu tare da LMB, za a gyara umarnin, kuma mai amfani zai iya kawo sel da yawa zuwa tsari guda har sai ya danna maɓallin Esc daga maballin.
5. Yiwuwar tsarawa bisa ga samfurin kowane abubuwa: hotuna, launi, zane-zane, zane-zane, da sauransu.

Maɓallai masu zafi don kunna Format Painter

A cikin Excel, kowane umarni, ana iya ƙaddamar da aiki ta hanyar haɗin maɓalli na musamman akan madannai na kwamfuta. Don kunna yanayin "Format Painter", kuna buƙatar aiwatar da manipulations masu zuwa:

1. Yi amfani da maɓallin linzamin kwamfuta na hagu don zaɓar kewayon sel ko nau'in nau'in nau'in wanda kuke son kwafi.
2. A lokaci guda ka riƙe maɓallan "Ctrl + C" daga maballin PC, canzawa zuwa shimfidar Turanci.
3. Matsar da siginan linzamin kwamfuta zuwa wani tantanin halitta kuma danna maɓallan "Ctrl + V". Bayan haka, wannan kashi zai ɗauki tsarin asalin tantanin halitta tare da abin da ke ciki.

Muhimmin! Hakanan zaka iya amfani da haɗin "Ctrl + Shift + V" don tsarawa bisa ga samfurin. Koyaya, don yin wannan, dole ne ku rubuta ƙaramin lamba kuma ku adana shi a cikin littafin macro.

Bayan an rubuta lambar, za a buƙaci ƙara hotkey zuwa jerin umarnin Excel. Don jimre wa aikin, kuna buƙatar aiwatar da matakai masu sauƙi bisa ga algorithm:

1. Shigar da shafin "View" a saman kayan aiki na shirin.
2. Fadada menu na "Macros" ta danna LMB akan kibiya kusa da shi.
3. A cikin mahallin mahallin, zaɓi abu mai suna iri ɗaya.
4. A cikin taga da ke buɗe, ƙarƙashin layin "Macro Name", za a rubuta sunan lambar da aka ƙara a baya. Dole ne a zaɓi shi tare da maɓallin linzamin kwamfuta na hagu kuma danna maɓallin "Parameters" a cikin kayan aiki a gefen dama na taga.

5. A cikin shafin da ya bayyana, a cikin filin "Gajeren Maɓallin Maɓalli", riƙe maɓallin "Ctrl + Shift + V" don ƙara maɓallin zafi, sannan danna "Ok" don amfani da canje-canje.

Yadda ake amfani da umarnin "Ctrl+Shift+V".

Bayan ƙirƙirar hotkey, kuna buƙatar fahimtar yadda ake amfani da wannan umarni. Ka'idar aiki na haɗin "Ctrl + Shift + V" na iya zama kamar haka:

1. Zaɓi kewayon abubuwan da kuke son kwafi tsarin.
2. Riƙe maɓallin “Ctrl + C” don ƙara abubuwan da ke cikin tantanin halitta zuwa allo.
3. Matsa zuwa kewayon da ake so na takardar aikin kuma ka riƙe haɗin "Ctrl + Shift + V".
4. Duba sakamakon.

Ƙarin Bayani! Bayan danna maɓallan "Ctrl + C", asalin tantanin halitta za a haskaka a cikin launi mai dacewa. Wannan yanayin yana nuna farkon aikin ƙungiyar.

Aikin Mai Zane-zane yana ba da sauƙin kwafin siffofi da hotuna daban-daban. Idan kawai kuna buƙatar kwafin abubuwan da ke cikin takamaiman tantanin halitta, to zaku iya amfani da haɗin “Ctrl + Shift + V”

Yadda ake kwafin abinda ke cikin tantanin halitta cikin sauri cikin tebur

Akwai hanyoyi da yawa na irin wannan kwafin. Koyaya, hanya mafi sauƙi kuma mafi inganci ta kasu zuwa matakai masu zuwa:

1. Zaɓi ɓangaren tsararrun tebur, abin da ke ciki dole ne a canza shi zuwa wani tantanin halitta.
2. Zaɓi tantanin halitta da ake so ta zaɓi shi tare da maɓallin linzamin kwamfuta na hagu.
3. Matsar da siginan linzamin kwamfuta zuwa layin don shigar da dabaru a saman layin babban menu na shirin.
4. Saka alamar "=" a cikin layi kuma nuna zuwa tantanin halitta.

5. Danna "Shigar" daga madannai don kammala aikin.

6. Duba sakamakon. Abubuwan da ke cikin asalin asalin yakamata su matsa zuwa wanda aka zaɓa.

Kula! Hakazalika, zaku iya cika kewayon sel da ake so a cikin farantin.

Kammalawa

Don haka, Microsoft Office Excel yana da ɗimbin fasalulluka masu amfani waɗanda ke ba ku damar sarrafa wani tsari. Tsarin pore tsari ɗaya ne irin wannan zaɓi. Duk hanyoyin kunnawa da amfani da su an tattauna su a sama.