Wojambula Wowonongeka wa Excel: Kupanga Kujambula Pakati pa Maselo

01 a 03

Excel ndi Google Spreadsheets Format Painter

Kukonza Mapepala Othandizira Pogwiritsa Ntchito Wopanga Maonekedwe

Chojambula chojambula chikupezeka mu b oth Excel ndi Google Spreadsheets amakulolani kuti musamangidwe mofulumira ndi mosavuta kupanga ma selo limodzi kapena gulu la maselo kupita kumalo ena a tsamba.

Mu mapulogalamu awiriwo, mbaliyi ndi yothandiza kwambiri popanga zolemba pamasamba kumalo omwe ali ndi deta yatsopano osati kuyesera kubwezeretsa maonekedwe omwe amapezeka pa deta yomwe ilipo,

Mu Excel, zokopera zojambulazo zimaphatikizapo kujambula zojambula zochokera kumodzi kapena nthawi zambiri ku malo amodzi kapena malo ena omwe amapezeka:

• Pa tsamba limodzi
• Pazigawo zosiyanasiyana zolembedwa m'buku lomwelo
• M'mabuku osiyana

02 a 03

Kujambula Kwambiri ndi Wojambula Wopangidwe

.Copy Kuyimira Zina Zowonjezereza Ma selo pa Excel

Zotsatira izi zidagwiritsidwa ntchito kugwiritsa ntchito njira zosiyanasiyana zojambula pazomwe zili mu chithunzi B mu chithunzi pamwambapa ku deta m'mizere C ndi D.

1. Onjezerani zosankha zonse zomwe mukufuna kuzigwiritsa ntchito ku selo yeniyeni.
2. Sungani maselo B4 ku B8 ndi pointer ya mouse.
3. Dinani pa tabu la Home la riboni .
4. Dinani pazithunzi zojambulajambula (bulashi ya penti) kumbali ya kumanzere kwa riboni-pamene phokoso la mbewa likukwera pamwamba pa pepala, pepala lojambula liwonetsedwera ndi pointer kuti asonyeze kuti wopanga zojambulazo wasinthidwa.
5. Sungani maselo C4 ku D8.
6. Zosankha zojambula zidzakopedwera kumalo atsopano ndipo zojambulajambula zimatsekedwa.

Kujambula kawiri Pawuni Yopanga Kujambula Kwambiri

Monga tafotokozera pamwambapa, njira yowonjezerapo yomwe ilipo mu Excel yokha ndiyokuphatikiza pawiri pajambula chojambula ndi mzere wa mbewa.

Kuchita zimenezi kumapangitsa kuti pepala lojambula zithunzi likhale lotsegulidwa ngakhale atagwiritsa ntchito maselo amodzi omwe akupita.

Kugwiritsa ntchito njirayi kumapangitsa kuti zikhale zovuta kufotokozera zojambula kumaselo angapo osakhala pafupi ndi omwe ali pamasamba ofanana kapena osiyana kapena mabuku ogwira ntchito.

Kuti mufanizire kupanga maonekedwe kwa magulu osakhala pafupi ndi maselo mu Google Spreadsheets, m'pofunika kubwereza masitepe pamwambapa kuti mufanizire kupanga mafomu ku gawo lachiwiri la tsamba.

Kutsegula Wofalitsa Pawonekedwe mu Excel

Njira ziwiri zowonetsera zojambulajambula pakakhala zojambula zambiri mu Excel ndi izi:

1. Lembani fungulo la ESC pa kambokosi.
2. Dinani kamodzi pa chithunzi chojambula pakhomo la Tsambali.

Chombo Chotsatira cha Keyboard cha Paintter Format Excel

Chophweka chophweka chachiwiri sichipezeka pa pepala lojambula la Excel.

Komabe, makonzedwe otsatirawa angagwiritsidwe ntchito kutsanzira wojambula zithunzi. Mafungulowa amagwiritsa ntchito mawonekedwe ophatikizira omwe ali nawo mu Paste Special dialog box .

1. Lembani Ctrl + C - kuti mufanizire zomwe zili mu khungu (s) -data ndi machitidwe-mawonekedwe -gululo (s) lanu lidzazunguliridwa ndi nyerere zoyendayenda.
2. Onetsani selo lopita kopita kapena maselo oyandikana nawo.
3. Lembani Ctr + Alt + V - kuti mutsegule Bokosi lapadera la bokosi.
4. Lembani T + Lowani kuti musamangidwe kumene mukugwiritsidwa ntchito ku selo kapena malo omwe mukupitawo.

Popeza kuti nyerere ziyenera kuyendayenda pamagulu (s), mawonekedwe a selo akhoza kudyedwa kangapo pobwereza masitepe 2 mpaka 4 pamwambapa.

Pangani Macro

Ngati mumagwiritsa ntchito zojambulajambula kawirikawiri, njira yosavuta yoigwiritsira ntchito pogwiritsa ntchito makiyiyi ingakhale yopanga macro pogwiritsa ntchito zikopa zapamwambazo ndikusakaniza makina osakaniza omwe angagwiritsidwe ntchito popanga macro.

03 a 03

Google Spreadsheets Paint Format

Lembani Kupangidwira kwa Maselo Amodzi Kapena Ambiri mu Google Spreadsheets

Mapulogalamu a mtundu wa Google Spreadsheets, monga amatchulidwa, sali woyenera monga mnzake wina wa Excel, popeza sangakwanitse kufotokozera zojambulazo kuchokera kumalo amodzi panthawi imodzi:

• Kumalo a tsamba limodzi
• Kuzilemba zosiyana pa fayilo lomwelo

Mapulogalamu a Google Spreadsheets sangathe kukopera kupanga pakati pa mafayilo.

Zitsulo zomwe zimagwiritsidwa ntchito kufotokoza zojambulazo kuchokera ku maselo B4: B8 kumaselo C4: D8 akuwonetsedwa mu chithunzi pamwambapa:

1. Onjezerani zosankha zonse zomwe mungapangire maselo.
2. Sungani maselo B4 ku B8 ndi pointer ya mouse.
3. Dinani pa chithunzi cha mtundu wa penti (chojambula chojambula) pa chida chopangira.
4. Onetsetsani maselo omwe akupita C4 kupita ku D8.
5. Zosankha zojambulidwa kuchokera m'maselo m'mbali B zidzakopilidwa ku maselo muzitsulo C ndi D ndipo mawonekedwe a mtundu wa utoto atsekedwa.

Kujambula Kwambiri ndi Zithunzi Zojambula

Monga tafotokozera pamwambapa, mtundu wa mapepala umangotenga zojambula zokhazokha panthawi imodzi

Kuti mufanizire kupanga maonekedwe kwa magulu osakhala pafupi ndi maselo mu Google Spreadsheets, m'pofunika kubwereza masitepe pamwambapa kuti mufanizire kupanga mafomu ku gawo lachiwiri la tsamba.