Qhov wikiHow no qhia koj yuav ua li cas rov kho txhua lub cell hauv kab ntawv raws li cov ntaub ntawv lej thiab lej hauv Google Sheets, siv lub desktop internet browser.
Kauj ruam
Kauj Ruam 1. Qhib Google Sheets hauv internet browser
Ntaus sheet.google.com rau hauv koj tus browser qhov chaw nyob bar, thiab nias Enter lossis Rov qab los ntawm koj cov keyboard.
Kauj Ruam 2. Nyem rau daim ntawv spreadsheet koj xav kho
Nrhiav cov ntawv koj xav kho hauv daim ntawv teev cov ntawv koj tau khaws tseg, tom qab ntawd qhib nws.
Kauj Ruam 3. Xaiv kab ntawv uas koj xav txheeb
Saib rau kab ntawv kab ntawv kab ntawv nyob rau sab saud ntawm daim ntawv, ces nyem rau nws. Cov kauj ruam no yuav xaiv thiab hais meej rau txhua kab lus.
Kauj Ruam 4. Nyem rau Cov Ntaub Ntawv tab
Nws nyob hauv tab tab hauv qab lub npe cov ntaub ntawv, nyob rau sab saud-sab laug ntawm qhov screen. Qhov no yuav qhib cov ntawv qhia zaub mov nco-down.
Kauj Ruam 5. Nyem Qhov ntau ntawm cov ntawv qhia zaub mov Cov ntaub ntawv.
Qhov kev xaiv no yuav qhib lub qhov rai tshiab uas koj tuaj yeem hloov kho qhov chaw teeb tsa.
- Qhov kev xaiv no yuav txheeb kab ntawv xaiv thiab yuav tsis cuam tshuam rau lwm cov ntaub ntawv.
- Yog tias koj xav txheeb txhua kab hauv kab ntawv raws li cov kab ntawv xaiv, nyem Txheeb daim ntawv los ntawm kab ntawm cov ntawv qhia zaub mov Cov ntaub ntawv.
Kauj Ruam 6. Xaiv txoj kev txheeb cais
Ntawm no koj tuaj yeem xaiv A rau Z (A rau Z) lossis Z to AW (Z rau A).
- Yog koj xaiv A rau Z, cov cell uas muaj cov ntaub ntawv qis dua raug txav mus rau sab saum toj ntawm kab, thiab cov lej siab dua tau txav mus rau hauv qab.
- Yog koj xaiv Z to AW, cov lej ntau dua yuav txav mus thiab cov lej qis yuav txav mus.
- Yog tias muaj kab lus header nyob rau sab saum toj ntawm daim ntawv teev npe, khij lub npov Cov ntaub ntawv muaj kab ntawv header (cov ntaub ntawv muaj kab ntawv header) ntawm no. Qhov no yuav tiv thaiv kab sab saum toj los ntawm kev txheeb xyuas.
Kauj Ruam 7. Nyem rau khawm Sort xiav
Cov kauj ruam no yuav siv cov lim lim thiab rov kho dua txhua lub cell hauv kab ntawv xaiv raws li cov ntaub ntawv tus lej hauv txhua lub cell.
