tirotiro
He nui te whakahau tahua a Microsoft Word Hōputu – Rārangi (Hōputu — Matā me te Tatautanga), e taea ai e koe te huri tere i te huinga kowae hei rarangi mapere, rarangi nama ranei. He tere, he watea, he tirohanga, kaore he take ki te whai i te tatau. Karekau he mahi pera i roto i te Excel, engari ka taea e koe te ngana ki te peehi ma te whakamahi i nga tauira ngawari me te whakahōputu.
Rārangi matā
Tīpakohia ngā pūtau raraunga mō te rārangi, pāwhiri-matau ki runga ka kōwhiri Hōputu pūtau (Whakahōputu Pūtau), ripa tau (tau), I tua atu - Hōputu katoa (Ritenga). Na i te mara He momo tāuruhia te kanohi whakahōputu ritenga e whai ake nei:
Hei whakauru i te ira maia, ka taea e koe te whakamahi i te pokatata papapātuhi Alt + 0149 (pupuri Alt ka patohia te 0149 ki te papapātuhi tau).
Rarangi tau
Tīpakohia he pūtau putua ki te taha maui o te timatanga o te rarangi (kei te ahua ko C1) ka whakauru i te tauira e whai ake nei ki roto:
=IF(ISBLANK(D1),””;TITI($D$1:D1))
=IF(ISBLANK(D1);»»; tatau ($D$1:D1))
Kātahi ka tārua i te tātai ki te tīwae katoa. Me mutu koe ki tetahi mea penei:
Otirā, ko te tātai i te tīwae C ka taki i ngā ihirangi o te pūtau i te taha ki te taha matau (mahi IF и ISLANK). Mēnā he putua te pūtau e pātata ana, karekau mātou e whakaatu i tētahi mea (kōrero kau). Ki te kore e putua, ka whakaatu i te maha o nga pūtau kore-putea (mahi COUNT) mai i te timatanga o te rarangi ki te pūtau o nāianei, arā, te tau ordinal.