Muaj ob peb txoj hauv kev nthuav dav kab hauv Excel thiab Google Sheets. Siv tus nas los hloov kab dav lossis kab qhov siab ib tus zuj zus lossis siv cov cuab yeej hauv ribbon (hauv Excel nkaus xwb) los hloov kab dav lossis kab qhov siab siv cov kev xaiv ribbon.
Kawm ob txoj hauv kev los txiav txim siab seb txoj kev twg zoo tshaj plaws rau koj cov kev xav tau.
Cov lus qhia hauv kab lus no siv rau Excel rau Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010, thiab Google Sheets.
Hloov kab dav thiab kab qhov siab nrog tus nas
Hloov tus kheej kab dav nrog tus nas
Cov kauj ruam hauv qab no npog yuav ua li cas hloov cov kab dav dav siv tus nas. Txhawm rau nthuav dav kab A piv txwv:
- Muab tus nas pointer rau ntawm txoj kab ciam teb ntawm kab A thiab B hauv kab ntawv kab ntawv
- Tus taw tes yuav hloov mus rau ob lub taub hau dub xub raws li pom hauv daim duab saum toj no
- Nias thiab tuav cia sab laug nas khawm thiab luag ob lub taub hau xub mus rau sab xis kom dav kab A lossis rau sab laug kom kab nqaim
- Tshiab tus nas khawm thaum qhov dav xav tau mus txog
AutoFit kab dav siv tus nas
Lwm txoj hauv kev kom nqaim lossis nthuav cov kab nrog tus nas yog cia Excel lossis Google Spreadsheets nws pib haum qhov dav ntawm kem mus rau qhov ntev tshaj plaws ntawm cov ntaub ntawv muaj nyob hauv kab.
Rau cov ntaub ntawv ntev, kab yuav nthuav dav, tab sis yog tias kem tsuas muaj cov ntaub ntawv luv xwb, kem yuav nqaim kom haum rau cov khoom no.
Piv txwv: Hloov qhov dav ntawm kab B Siv AutoFit
- Muab tus nas pointer rau ntawm kab ciam teb ntawm kab B thiab C hauv kab ntawv sau. Tus pointer yuav hloov mus rau ob lub taub hau xub.
- ob-nias kab. Kab yuav hloov kho nws qhov dav kom phim qhov ntev tshaj plaws nkag rau hauv kab ntawv
Hloov txhua kab dav hauv daim ntawv ua haujlwm siv tus nas
Kho tag nrho cov kab dav dav
- Xaiv tag nrho cov kab hauv daim ntawv ua haujlwm tam sim no.
- Muab tus nas pointer rau ntawm txoj kab ciam teb ntawm kab A thiab B hauv kab ntawv kab ntawv
- Tus pointer yuav hloov mus rau ob lub taub hau xub.
- Xaiv ob lub taub hau xub xub thiab luag mus rau sab xis kom nthuav dav txhua kab hauv daim ntawv ua haujlwm lossis sab laug kom tag nrho cov kab nqaim.
Hloov kab siab nrog tus nas
Cov kev xaiv thiab cov kauj ruam los hloov cov kab siab hauv Excel thiab Google Cov Ntawv nrog tus nas yog tib yam li hloov kab ntawv dav, tshwj tsis yog tias koj tso tus nas pointer rau ntawm kab ciam teb ntawm ob kab hauv kab header es tsis txhob lub taub hau kab.
Nws tsis tuaj yeem hloov qhov dav lossis qhov siab ntawm ib leeg. Qhov dav yuav tsum tau hloov rau tag nrho kem lossis qhov siab rau tag nrho kab.
Hloov kab dav siv Ribbon xaiv hauv Excel
Hloov kab dav siv cov kev xaiv Ribbon
Microsoft Excel muaj cov cuab yeej ntawm cov kab uas yuav hloov qhov dav ntawm kab rau txhua qhov xav tau.
- Xaiv ib lub xov tooj ntawm kab ntawv koj xav hloov. Txhawm rau nthuav dav ntau kab qhia ib lub xov tooj ntawm txhua kab. Txhawm rau hloov kab dav rau daim ntawv sau ua haujlwm, xaiv lub Xaiv Txhua khawm.
- Xaiv tus Home tab ntawm kab
- Xaiv tus Format icon los qhib cov ntawv qhia zaub mov ntawm kev xaiv
- To AutoFit lub kem, xaiv qhov kev xaiv ntawd hauv ntu Cell Loj ntawm cov ntawv qhia
- Txhawm rau nkag mus rau qhov loj me hauv cov cim qhov dav, xaiv qhov Kem Dav kev xaiv hauv cov ntawv qhia zaub mov kom coj mus rau Kab Dav dialog box
- Nyob rau hauv lub dialog box nkag mus rau qhov dav xav tau nyob rau hauv lub cim (default width: 8.11 cim)
- Xaiv OK txhawm rau hloov cov kab dav dav thiab kaw lub dialog box
Cov kev xaiv thiab cov kauj ruam los hloov cov kab siab hauv Excel siv cov kev xaiv hauv kab ntawv yog tib yam li hloov kab dav.
Resize kab thiab kab hauv Google Sheets Menu
Google Sheets nta txoj cai-nias cov ntawv qhia zaub mov hloov pauv kab dav.
- Xaiv kab (s) koj xav hloov loj.
- Right-click nyob qhov twg ntawm qhov xaiv.
- Choose Resize Kab. Lub qhov rais Resize Kem yuav qhib.
- Nkag mus rau qhov xav tau kab dav hauv pixels (qhov dav dav yog 100 pixels).
- Xwb, xaiv Fit rau Cov Ntaub Ntawv.
- Xaiv OK.
