Qhov wikiHow no qhia koj li cas los hloov tus lej rau feem pua hauv Microsoft Excel. Koj tuaj yeem rov ua dua tshiab cov txiaj ntsig tam sim no rau feem pua, lossis koj tuaj yeem npaj ua ntej lub hlwb ua ntej ntxiv qhov tseem ceeb.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Kev Sau Cov Xov Tooj Ntawm Tes
Kauj Ruam 1. Xaiv cov xov tooj ntawm tes lossis cov cell uas koj xav hloov pauv mus rau feem pua
Tus nqi sau yuav tsum yog tus lej lossis tus lej.
-
Thaum hloov pauv mus rau ib feem pua, Excel yuav muab tus lej no los ntawm 100 thiab ntxiv ib feem cim cim (%). Piv txwv li:
- 1 yuav format rau 100%
- 10 yuav format rau 1000%
- .01 yuav format rau 1%
- 1/5 yuav tawm tswv yim txog 20%
Kauj ruam 2. Nyem rau Tsev tab
Qhov no yog nyob rau sab saum toj-sab laug ntawm daim ntawv thov.
Kauj Ruam 3. Nyem rau lub % feem pua khawm
Nov yog nyob hauv ntu toolbar sau lo lus "Tus lej".
- Xwb, tuav Ctrl + ⇧ Shift + % los hloov tus nqi.
- Tus lej yuav hloov pauv mus rau ib feem pua.
Txoj Kev 2 ntawm 2: Kev Hloov Pauv Ntawm Cell
Kauj Ruam 1. Xaiv cov cell uas tsis muaj dab tsi lossis cov cell uas koj xav hloov pauv mus rau feem pua
Feem pua yuav pib ua hom ntawv tom qab tus nqi nkag mus.
-
Thaum hloov pauv mus rau feem pua, cov lej me dua 1 yuav muab sib npaug 100; cov lej sib npaug thiab ntau dua 1 tau hloov pauv ncaj qha rau lawv feem pua.
- 1 thiab.01 yuav ob hom ntawv rau 1%
- 10 thiab.1 yuav ob hom ntawv rau 10%
- 100 yuav format rau 100%
- 1/5 yuav tawm tswv yim txog 20%
Kauj ruam 2. Nyem rau Tsev tab
Qhov no yog nyob rau sab saum toj sab laug.
Kauj Ruam 3. Nyem rau lub % feem pua khawm
Nov yog ntu toolbar sau lo lus "Tus lej".
Xwb, tuav Ctrl + ⇧ Shift + % los teeb tsa cov cell (s)
Kauj Ruam 4. Sau tus lej lossis tus lej rau hauv cell
Tus lej yuav hloov pauv mus rau ib feem pua.