USU  ››  Mapulogalamu opangira mabizinesi  ››  Pulogalamu yogulitsira maluwa  ››  Malangizo a pulogalamu yogulitsira maluwa  ›› 

Kuwunikira zowunikira ndi maziko a gradient

Izi zimapezeka kokha pamakonzedwe a Standard ndi Professional program.

Apa taphunzira kale momwe tingagwiritsire ntchito kusanjidwa koyenera ndi zithunzi.

Gradient pogwiritsa ntchito mitundu iwiri

Ndipo tsopano tiyeni mu module "Zogulitsa" onetsani madongosolo ofunikira kwambiri pogwiritsa ntchito gradient. Kuti tichite izi, timagwiritsa ntchito lamulo lodziwika kale "Conditional Formating" .

Chonde werengani chifukwa chake simungathe kuwerenga malangizowo mofanana ndikugwira ntchito pawindo lomwe likuwonekera.

Pazenera lomwe likuwoneka, chikhalidwe cham'mbuyo cha masanjidwe a data chikhoza kuwonjezedwa. Ngati ndi choncho, dinani batani la ' Sintha '. Ndipo ngati palibe zikhalidwe, ndiye dinani ' Chatsopano ' batani.

Kenako, pamndandanda wazotsatira zapadera, sankhani kaye mtengo ' Sinthani ma cell onse kutengera milingo yawo kudzera mumitundu iwiri yamitundu '. Kenako sankhani mitundu ya mtengo wocheperako komanso waukulu kwambiri.

Mtundu ukhoza kusankhidwa onse pamndandanda ndikugwiritsa ntchito mulingo wosankha mtundu.

Izi ndi momwe chosankha mitundu chimawonekera.

Pambuyo pake, mudzabwerera ku zenera lapitalo, lomwe muyenera kuonetsetsa kuti zotsatira zapadera zidzagwiritsidwa ntchito mwachindunji kumunda wa ' Payable '.

Izi ndi zomwe zotsatira zake zidzawoneka. Dongosolo lofunikira kwambiri, maziko a cell amakhala obiriwira. Mosiyana ndi kugwiritsa ntchito zithunzi zokhala ndi zosankha zotere, pali mithunzi yambiri yamakhalidwe apakatikati.

Gradient pogwiritsa ntchito mitundu itatu

Koma mutha kupanga gradient pogwiritsa ntchito mitundu itatu. Pazotsatira zamtundu uwu, sankhani 'Sankhani ma cell onse kutengera milingo yawo pamitundu itatu yamitundu '.

Momwemonso, sankhani mitundu ndikusintha mawonekedwe apadera ngati kuli kofunikira.

Pankhaniyi, zotsatira zidzawoneka kale chonchi. Mutha kuwona kuti phale lamtundu ndi lolemera kwambiri.

Sinthani Mafonti

Mutha kusintha osati mtundu wakumbuyo, komanso fonti .

Onani pansipa mitu ina yothandiza:

• Kuwunikira zamtengo wapatali ndi gulu la zithunzi
• Conditional Formating
• Pachiyambi

• Tsitsani pulogalamuyo ndi maphunziro ochezera