Qhov wikiHow no qhia koj li cas siv cov qauv kev cai los qhia txhua tus lej lossis tus lej sib txawv hauv Google Cov Ntawv Ntawv nthuav tawm nrog cov xim sau, siv lub desktop internet browser.
Cov kauj ruam
Kauj Ruam 1. Qhib Google Ntawv hauv koj lub browser internet
Ntaus sheet.google.com rau hauv qhov chaw nyob bar, thiab ntaus ↵ Enter lossis ⏎ Return ntawm koj cov keyboard.
Kauj ruam 2. Nyem rau cov ntawv koj xav kho
Nrhiav cov ntaub ntawv uas koj xav kom hais meej hauv cov npe ntawm koj cov ntaub ntawv khaws tseg, thiab qhib nws.
Kauj Ruam 3. Nyem rau Format tab
Lub pob no nyob ntawm kab tab hauv qab no lub npe cov ntaub ntawv nyob rau sab saud sab laug ntawm koj daim ntawv teev npe. Nws yuav qhib cov ntawv qhia zaub mov nco-down.
Kauj Ruam 4. Nyem qhov kev teeb tsa raws li txoj cai ntawm cov ntawv qhia zaub mov
Qhov no yuav qhib lub vaj huam sib luag ntawm sab xis ntawm koj daim ntawv nthuav qhia.
Kauj Ruam 5. Nyem rau kab ntawv hauv qab "Thov rau ntau yam" nqe lus
Daim teb no yog nyob rau sab saum toj ntawm lub vaj huam sib luag kev teeb tsa ntawm sab xis. Nws yuav tso cai rau koj xaiv thaj chaw uas koj xav kho thiab ua kom pom tseeb.
Kauj Ruam 6. Xaiv thaj chaw uas koj xav kho ntawm daim ntawv nthuav tawm
Nyem rau koj thawj lub xov tooj, thiab luag koj tus nas kom xaiv thaj chaw uas koj xav kho.
Thaum koj nyem lub xov tooj, lub qhov rai tshiab hu ua "Cov ntaub ntawv yog dab tsi?" yuav pop-up. Koj tuaj yeem pom koj cov xov tooj ntawm tes xaiv hauv lub qhov rai pop-up no
Kauj Ruam 7. Nyem OK hauv qhov pop-up
Qhov no yuav paub meej tias koj xaiv ntau yam.
Kauj Ruam 8. Nyem rau cov ntawv qhia zaub mov nco hauv qab "Format cells if" nqe lus
Qhov kev xaiv no yog nyob hauv nruab nrab ntawm cov vaj huam sib luag formatting ntawm sab xis. Nws yuav qhib ib daim ntawv teev cov xwm txheej uas muaj.
Kauj Ruam 9. Scroll cia thiab xaiv Cov mis tshwj xeeb nyob ntawm cov ntawv qhia zaub mov
Qhov no yuav tso cai rau koj ntaus ntawv hauv cov txheej txheem kev cai.
Kauj Ruam 10. Nyem rau Tus Nqis lossis tus lej hauv daim foos formatting
Koj tuaj yeem ntaus koj tus qauv kev cai ntawm no.
Kauj Ruam 11. Nkag mus = ISEVEN (ROW ()) rau hauv Tus Nqi lossis cov lej formula
Cov mis no yuav hais txog txhua tus lej uas nyob hauv kab uas tau xaiv.
- Yog tias cov qauv saum toj no hais txog qhov tsis raug ntawm kab, sim = ISODD (ROW ()). Qhov no yuav hais txog txhua qhov khib-tus lej suav hauv kab xaiv.
- Koj tuaj yeem pom txhua tus lej nyob ntawm sab laug ntawm koj daim ntawv nthuav qhia.
Kauj Ruam 12. Nyem rau cov ntawv qhia xim hauv qab "Cov Qauv Txheej Txheem" nqe lus
Cov ntawv qhia zaub mov nco-ntsuab yog lub neej ntawd. Qhov no yuav qhib lub qhov rai pop-up, thiab tso cai rau koj xaiv cov xim sib txawv.
Kauj Ruam 13. Xaiv cov xim tseem ceeb hauv lub qhov rai qhib
Nyem rau ib qho xim tshwj xeeb ntawm no yuav cia li siv nws rau koj daim ntawv teev npe.
Kauj Ruam 14. Nyem rau khawm Done xiav
Lub pob no yog nyob hauv qab ntawm lub vaj huam sib luag kev teeb tsa. Nws yuav txuag koj cov txheej txheem ua qauv tshiab.