Contents
Microsoft Word yana da babban umarnin menu Tsarin - Jerin (Format - Harsasai da Lambobi), wanda ke ba ka damar saurin jujjuya saitin sakin layi zuwa jerin harsashi ko ƙididdiga. Mai sauri, dacewa, gani, babu buƙatar bin lamba. Babu irin wannan aikin a cikin Excel, amma kuna iya ƙoƙarin yin koyi da shi ta amfani da tsari mai sauƙi da tsarawa.
Jerin harsashi
Zaɓi sel bayanan don lissafin, danna-dama akan su kuma zaɓi Tsarin salula (Tsarin Kwayoyin), tab Number (lamba), Gaba - Duk tsari (Na al'ada). Sai a filin Wani nau'in shigar da abin rufe fuska na al'ada mai zuwa:
Don shigar da ɗigo mai ƙarfi, zaku iya amfani da gajeriyar hanyar keyboard Alt + 0149 (riƙe Alt kuma buga 0149 akan faifan maɓalli).
Jerin lambobi
Zaɓi tantanin halitta mara komai a gefen hagu na farkon jerin (a cikin adadi C1) kuma shigar da dabara mai zuwa a ciki:
=IF(ISBLANK(D1),””;COUNT($D$1:D1)))
=IF(ISBLANK(D1);»»;COUNTA($D$1:D1))
Sa'an nan kuma kwafi dabarar zuwa dukan ginshiƙi. Ya kamata ku ƙare da wani abu kamar haka:
A zahiri, dabarar da ke shafi C tana bincika abubuwan da ke cikin tantanin halitta kusa da dama (ayyukan IF и ISBLANK). Idan tantanin da ke kusa da shi ya zama fanko, to ba ma nuna komai (farin magana). Idan ba komai ba, to nuna adadin sel marasa komai (aiki COUNT) daga farkon lissafin zuwa tantanin halitta na yanzu, wato, lambar ma'ana.