Kev txhais ntawm kab thiab kab hauv Excel thiab Google spreadsheets
Txhua kab thiab kab yog ib qho tseem ceeb ntawm cov kev tshaj tawm cov ntaub ntawv xws li Excel thiab Google Spreadsheets. Rau cov kev pabcuam zoo li no, txhua daim ntawv ua haujlwm raug muab tso rau hauv ib qho qauv sibluag nrog:
- kab khiav vertically;
- kab khiav horizontally.
Daim ntawv khomob hauv txhua tsab ntawv luam ntawm Excel muaj:
- 16,384 kab;
- 1.048,576 natwm.
Hauv Google Spreadsheets qhov loj me me ntawm cov ntawv ua haujlwm yog:
- 26 kab ntawv;
- 100 kab.
Txhua kab thiab kab yuav ntxiv rau hauv Google Spreadsheets tsuav yog tag nrho cov hlwb ntawm ib daim ntawv ua haujlwm tsis pub tshaj 400,000;
Li ntawd, muaj peev xwm ua tau ntau yam ntawm txhua kab thiab kab, xws li:
- 50 txhua kab thiab 8,000 leej kab;
- 100 kab thiab 4,000 kab;
Kem thiab kab npe
Hauv Excel thiab Google Spreadsheets,
- txhua kem yog txheeb los ntawm ib tsab ntawv nyob rau hauv sab header pib nrog sab A thiab, nyob rau hauv rooj plaub ntawm Excel, khiav mus rau sab XFD.
- txhua tus kab yog qhia los ntawm ib tug xov tooj ntawm cov kab pib, pib ntawm ib qho.
Kem thiab cov npe thiab cov xov tooj ntawm tes
Cov kev sib tshuam ntawm ib kem thiab kab yog ib lub xovtooj ntawm - txhua yam ntawm cov thawv me pom nyob hauv daim ntawv ua haujlwm.
Tawm ua ke, cov ntawv sau qhia kab ntawv thiab kab zauv nyob hauv ob lub hau lus tsim cov xov tooj ntawm tes , uas taw cov tib neeg ntawm cov chaw nyob hauv daim ntawv.
Xov tooj ntawm tes - xws li A1, F56, lossis AC498 - yog siv ntau hauv cov ntawv xov xwm spreadsheet xws li cov qauv thiab thaum tsim cov kab kos .
Highlighting Tag Nrho Txhua Yam thiab Cov Npe hauv Excel
Yuav kom pom tseeb tag nrho cov sab hauv Excel,
- nias rau sab header;
- nias lub Ctrl + Spacebar yawm sij ntawm cov keyboard.
Yuav kom pom tseeb tag nrho nyob hauv Excel,
- nias rau ntawm kab hau;
- nias lub Shift + Spacebar yawm sij.
Highlighting Tag Nrho Txhua Yam thiab Cov Ntaus Hauv Google Tshaj Tawm
Rau cov kab uas tsis muaj cov ntaub ntawv,
- nias lub Ctrl + Spacebar yauv ib zaug xaiv lub tag nrho kab.
Rau cov kab uas muaj cov ntaub ntawv,
- nias lub Ctrl + Spacebar yauv xaiv ib feem ntawm cov kem uas muaj cov ntaub ntawv;
- nias lub Ctrl + Spacebar yawm sij hawm xaiv thib ob.
Rau cov kab uas tsis muaj cov ntaub ntawv,
- nias tus ua haujlwm + Spacebar yauv ib zaug xaiv lub kab tag nrho.
Rau cov kab uas muaj cov ntaub ntawv,
- nias tus ua haujlwm + Spacebar yauv xaiv ib ntu ntawm kab uas muaj cov ntaub ntawv;
- nias lub khawm + Spacebar yawm sij hawm xaiv thib ob.
Navigating Kab thiab Txhua
Txawm hais tias siv tus pointer nas mus nias ntawm lub hlwb los yog siv cov kev tuav cov ntawv yoojyim, nws yeej yog ib qho kev xaiv tsiv ib daim ntawv khom nqi, rau cov ntawv ua haujlwm loj nws tuaj yeem cuam sai siv cov keyboard. Qee feem ntau siv cov ntsiab lus tseem ceeb xws li:
- Ctrl + Cia li xub -Khiav kom dhau kab ntawm daim ntawv ua haujlwm
- Ctrl + Paw xub - dhia mus rau thawj kab ntawm daim ntawv ua haujlwm
- Ctrl + Txoj xub - dhia mus rau sab kawg ntawm daim ntawv ua haujlwm
- Ctrl + Sab laug xub - dhia mus rau sab xub thawj ntawm daim ntawv khomob
Muab Cov Npe Nruab Nrab rau Ib Daim Ntawv Sau Npe
Tib qho tseem ceeb keyboard ua ke siv tau ntxiv ob kab thiab kab rau ib daim ntawv ua haujlwm:
Ctrl + Ua haujlwm + "+" (ntxiv rau kos npe)Ntxiv rau ib qho ntxiv rau lwm tus:
- xaiv kab tag nrho mus rau sab xis ntawm qhov chaw rau sab tshiab
- xaiv tag nrho kab saum toj qhov chaw rau tus kab tshiab
Lus Cim: Rau cov keyboards nrog tus leb npab mus rau sab xis ntawm cov keyboards, siv lub npe + kos npe rau tsis muaj tus yuam sij haujlwm. Txoj kev ua ke tseem ceeb tiav:
Ctrl + "+" (ntxiv rau kos npe)