Daim ntawv teev npe thiab cov lej hauv Excel li hauv Word

Microsoft Word muaj cov ntawv qhia zaub mov zoo Format – List (Hom ntawv - Bullets thiab Numbering), uas tso cai rau koj sai sai tig ib pawg kab lus mus rau hauv ib daim ntawv teev npe los yog cov lej. Ceev, yooj yim, pom, tsis tas yuav ua raws li tus lej. Tsis muaj kev ua haujlwm zoo li no hauv Excel, tab sis koj tuaj yeem sim xyaum nws siv cov qauv yooj yim thiab formatting.

Daim ntawv teev npe

Xaiv cov ntaub ntawv cell rau daim ntawv, right-click rau lawv thiab xaiv Cell format (Format Cells), tab Number (tooj), Ntxiv - Txhua hom ntawv (Kev Cai). Tom qab ntawd hauv teb Ib hom nkag mus rau hauv qab no kev cai hom daim npog qhov ncauj:

Daim ntawv teev npe thiab cov lej hauv Excel li hauv Word

Txhawm rau nkag mus rau qhov tseem ceeb, koj tuaj yeem siv cov keyboard shortcut Alt + 0149 (tuav Alt thiab ntaus 0149 ntawm tus lej keyboard).

Cov npe naj npawb

Xaiv ib lub xov tooj khoob rau sab laug ntawm qhov pib ntawm daim ntawv teev npe (hauv daim duab nws yog C1) thiab sau cov qauv hauv qab no rau hauv nws:

=IF(ISBLANK(D1),””; COUNT($D$1:D1))

=IF(ISBLANK(D1);»»; COUNTA($D$1:D1))

Tom qab ntawd luam cov qauv mus rau tag nrho cov kab. Koj yuav tsum xaus nrog qee yam zoo li no:

Qhov tseeb, cov mis hauv kem C xyuas cov ntsiab lus ntawm lub xov tooj ntawm sab xis ntawm sab xis (functions IF и ISBLANK). Yog hais tias lub xov tooj uas nyob ib sab yog khoob, ces peb tsis tso ib yam dab tsi (dab laug quotes). Yog tias tsis yog khoob, ces tso saib cov xov tooj ntawm cov hlwb uas tsis yog khoob (function COUNT) los ntawm qhov pib ntawm daim ntawv mus rau lub xovtooj ntawm tes tam sim no, uas yog, tus lej xov tooj.

 

Sau ntawv cia Ncua