Virtual office suite los ntawm Google, muab mus rau hauv lawv cov huab cia, yog nrov heev ntawm cov neeg siv vim nws siv dawb thiab yooj yim. Nws suav cov kev siv web xws li Kev Tshaj Tawm, Cov Ntawv, Cov Ntaub Ntawv, Cov Ntawv Qhia. Cov hauj lwm nrog lub tom kawg, ob qho tag nrho hauv qhov browser ntawm PC thiab ntawm mobile pab kiag li lawm, yuav raug muab tham rau hauv tsab xov xwm no.
Pin kab mus rau google cov lus
Google ntxhuav yog nyob rau hauv ntau txoj kev ua zoo rau ib qho kev sib xws ntawm Microsoft - lub spreadsheet Excel processor. Yog li, txhawm rau txhim kho cov kab hauv cov khoom ntawm kev tshawb nrhiav loj heev, uas tej zaum yuav tsum tsim kom muaj lub rooj header lossis header, tsuas yog muaj ib txoj kev. Hauv qhov no, muaj ob qho kev xaiv rau nws txoj kev siv.
Web version
Txoj kev yooj yim tshaj plaws yog siv Google Spreadsheets hauv qhov browser, tshwj xeeb tshaj yog tias koj ua hauj lwm nrog lub web service los ntawm lub tuam txhab cov khoom muag, Google Chrome, muaj nyob rau ntawm qhov rais, macOS thiab Linux computers.
Qhov Xaiv 1: Kho Kho Ib Kab
Cov neeg tsim khoom hauv Google tau muab qhov kev ua haujlwm uas peb xav tau yuav luag rau qhov chaw tsis muaj chaw ntau, uas yog vim li cas ntau tus neeg siv cov teeb meem. Thiab tsis tau, txhawm rau txhim kho tus kab hauv lub rooj, txhua yam koj yuav tsum tau ua yog tsuas yog ib co clicks.
- Siv tus nas, xaiv cov kab hauv cov lus uas koj xav kho. Instead of xaiv kev xaiv, koj tuaj yeem nias ntawm nws cov lus nug hauv pawg tswj hwm.
- Tshaj siab tshaj qhov kev tshaj tawm ntawm sab saum toj, nrhiav tus tab "Saib". Txhawm rau nws hauv cov ntawv teev npe zaub mov, xaiv "Ruaj ntseg".
- Hauv sub-menu uas tshwm sim, xaiv "1 kab".
Tus xaiv kab yuav raug tsau - thaum scrolling lub rooj, nws yuav nco ntsoov nyob hauv nws qhov chaw.
Nco Ntsoov: Tsis ntev los no, qhov "Saib" tab yog hu ua "Saib", yog li koj yuav tsum qhib rau nws kom nkag tau rau cov ntawv qhia cov paj.
Raws li koj tau pom, tsis muaj dab tsi nyuab hauv kev kho ib kab. Yog tias koj xav ua qhov no nrog ntau kab rov tav ntawm ib zaug, nyeem rau.
Qhov Xaiv 2: Pinning qhov ntau
Tsis tas li lub taub hau ntawm tsab ntawv khom nqi tsuas muaj ib kab xwb, muaj ob, peb lossis ntau tshaj. Siv lub web daim ntawv thov los ntawm Google, koj tuaj yeem txhim kho tus xov tooj ntawm cov kab uas tsis muaj cov ntaub ntawv.
- Nyob rau ntawm cov chaw sib koom tes, siv tus nas mus xaiv ntau yam ntawm cov kab uas koj npaj yuav hloov mus rau hauv ib lub rooj sib npaug.
- Rov ua cov kauj ruam uas tau piav nyob rau hauv lub dhau los ntawm version: nyem rau ntawm tab "Saib" - "Ruaj ntseg".
- Xaiv yam khoom "Ntau Kab (N)"qhov twg xwb "N" tus naj npawb ntawm cov zauv xaiv los ntawm koj yuav tsum pom hauv nkhaus.
- Kab rov tav ntau yam koj tau xaiv yuav raug tsau.
Tswv yim: Tsis txhob xaiv nrog tus nas, koj tuaj yeem nias rau ntawm tus naj npawb ntawm thawj kab hauv qhov ntau, thiab mam li tuav "NQI" ntawm cov keyboard, nyem rau ntawm tus lej kawg. Lub sijhawm koj xav tau yuav raug ntes.
Them sab nraud "Rau kab tam sim no (N)" - nws tso cai rau koj kho tag nrho cov kab ntawm lub rooj, uas muaj cov ntaub ntawv, mus txog qhov kawg kab tas (tsis suav).
Li ntawd xwb koj yuav kho tau ob peb kab los yog ib kab tag nrho kab rov tav hauv Google Ntxhuav.
Undo kab nyob rau hauv lub rooj
Yog hais tias qhov yuav tsum tau txhim kho cov kab disappears, cia li nias ntawm qhov tab. "Saib"xaiv yam khoom "Ruaj ntseg"thiab ces tus thawj daim ntawv xaiv - "Txhim kho txoj kab". Kho qhov xaiv yav dhau los yuav raug tso tseg.
Saib kuj:
Yuav ua li cas kho lub hau hauv lub rooj Excel
Yuav kho lub npe li cas hauv Excel
Txawb daim ntawv thov
Google Spreadsheets no tsuas muaj nyob rau hauv lub vas sab xwb, tab sis kuj ntawm mobile pab kiag li hauv Android thiab iOS. Daim ntawv thov yog yooj yim thiab yooj yim mus use, thiab, tau kawg, yog endowed nrog cov nuj nqi ntawm huab synchronization, ntse txhua Google kev pabcuam. Xav seb yuav ua li cas txhim kho cov kab hauv cov rooj sib tw txawb.
Qhov Xaiv 1: Ib txoj kab
Google Spreadsheets rau smartphones thiab ntsiav tshuaj, ntawd lawv cov functionality, yuav luag tib yam li cov qhov web version. Thiab tseem ua tiav qhov kev nqis tes ua, qhov chaw ntawm cov cuab yeej thiab cov kev tswj nyob rau hauv daim ntawv thov yog muab coj los ua dog dig txawv. Yog li ntawd, peb xav paub tias tseem yuav kho cov kabmob los ua ib lub rooj rau lub npe uas tsis yog txhua tus xav tias kev nrhiav nws.
- Thaum pib ua daim ntawv thov, qhib daim ntawv tsim nyog lossis tsim ib qho tshiab (ntawm kos lossis rau ib daim qauv ntawv).
- Coj mus rhaub rau ntawm kab zauv ntawm kab koj xav khi. Qhov no yuav yog ib qho, vim tsuas yog thawj zaug (sab saud) thiaj yuav tsau ib los ntawm ib qho.
- Tuav koj tus ntiv tes rau ntawm kab xov tooj kom txog rau thaum lub pop-up zaub mov tshwm. Tsis txhob totaub los ntawm qhov tseeb tias nws muaj cov lus txib rau kev ua hauj lwm nrog cov ntaub ntawv, cia li nias ntawm lub ellipsis thiab xaiv los ntawm yam khoom siv hauv tshuab raj "Ruaj ntseg".
- Tus xaiv kab yuav raug kho, tsis txhob hnov qab mus nias lub cim kos nyob rau ntawm sab qaum sab laug kom paub tseeb tias qhov kev nqis tes ua. Txhawm rau kom muaj kev vam meej ntawm txoj kev ua tiav, hla lub rooj saum toj mus rau sab qab thiab rov qab.
Qhov Xaiv 2: Kab Qib
Kev kho ntawm ob los sis ntau kab hauv Google Ntxhuav yog ua tau siv tib lub algorithm raws li nyob rau hauv rooj plaub ntawm tsuas yog ib qho. Tab sis, dua, ntawm no, ib yam nkaus thiab, nws muaj ib qho tsis txav rau txhua qhov teeb meem, thiab nws nyob hauv qhov teeb meem ntawm kev paub ob kab thiab / los yog qhia tias muaj ntau yam - nws tsis yog tam sim ntawd meej hais tias qhov no yog ua li cas.
- Yog tias ib kab ntawv twb txuas rau koj lawm, nyem rau ntawm nws cov kab lus. Ua tau, koj yuav tsum tau nyem rau nws thiab yog tias tsis muaj cov header hauv lub rooj.
- Sai li qhov xaiv cheeb tsam ua haujlwm, uas yog, ib kab xiav nrog qhov tshwm sim, rub nws mus rau kab kawg, uas yuav muab tso rau hauv qhov chaw ruaj (hauv peb qhov piv txwv, qhov no yog qhov thib ob).
Nco Ntsoov: Yuav rub nws yog qhov tsim nyog rau xiav taw tes nyob rau hauv cheeb tsam ntawm lub hlwb, thiab tsis yog rau lub voj voog nrog pointers ze tus kab nab npawb).
- Tuav koj tus ntiv tes rau ntawm thaj chaw uas tau xaiv, thiab tom qab cov lus qhia nrog cov lus txib tshwm, coj mus rhaub rau ntawm peb daim duab.
- Xaiv ib qho kev xaiv "Ruaj ntseg" los ntawm cov npe ntawm cov kev xaiv, thiab paub meej tias koj cov kev ua haujlwm yog txhaj qhov kos npe. Scroll los ntawm lub rooj thiab xyuas kom tseeb tias cov hlua muaj koom ua tiav, uas txhais tau hais tias lub hau tau tsim.
- Hom no zoo heev thaum koj xav kho kho ob peb kab nyob ze. Tab sis dab tsi yog qhov ntau yog qhov dav heev? Txhob rub tus ntiv tes sib kis ntawm lub rooj, sim mus rau ntawm txoj kab. Nyob rau hauv qhov tseeb, txhua yam yog ntau yooj yim.
- Nws tsis muaj teeb meem yog hais tias cov kab no tas los tsis, xaiv ib qho uas yuav kawg ntawm qhov muaj nyob rau hauv qhov chaw khwv.
- Tuav koj tus ntiv tes rau ntawm thaj chaw xaiv, thiab tom qab ib qho me me zaub mov tshwm, nias rau ntawm peb qho ntsiab lus ntsug. Ntawm daim ntawv teev npe cia, xaiv "Ruaj ntseg".
- Tom qab lees txais lub lag luam los ntawm kos lub cim kos, cov kab ntawm thawj hnub dhau los ntawm koj yuav tsum khi rau lub rooj hau lus, uas tuaj yeem pom pom ntawm qhov pib mus rau hauv qab thiab tom qab ntawd.
Nco Ntsoov: Yog hais tias qhov ntau ntawm cov kab ruaj ruaj dhau plaws lawm, nws yuav muab cov khoom tso tawm ntawm qhov screen. Qhov no yog qhov tsim nyog rau kev yooj yim navigation thiab ua hauj lwm nrog tus so ntawm lub rooj. Hauv qhov no, lub hau npog nws tus kheej tuaj yeem tshawb tau cov lus qhia yooj yim.
Tam sim no koj paub tias yuav ua li cas los tsim ib lub taub hau hauv Google Spreadsheets, khi ib los yog ob peb kab thiab txawm tias lawv txoj kab dav dav. Nws yog txaus ua qhov no tsuas yog ob peb zaug thiaj li nco ntsoov tsis zoo tshaj plaws thiab nkag siab ntawm cov khoom tsim nyog.
Undoing kab
Koj tuaj yeem siv cov kab nyob hauv mobile hauv Google cov lus sib npaug raws li peb tau teem tseg.
- Xaiv kab thawj zaug ntawm lub rooj (txawm tias qhov khwv tau tsau) los ntawm tapping nws tus naj npawb.
- Tuav koj tus ntiv tes rau ntawm thaj chaw tseem ceeb kom txog rau thaum lub tshuab qhib pop-up tshwm. Nias rau nws rau peb qho ntsiab lus ntsug.
- Nyob rau hauv daim ntawv teev cov kev ua uas yuav qhib, xaiv "Tsis muaj"tom qab uas qhov kev cog lus ntawm kev sib tw (thiab) nyob rau hauv lub rooj yuav raug muab tso tseg.
Xaus
Los ntawm tsab xov xwm me me koj tau kawm txog kev daws qhov teeb meem xws li ua lub hau luam los ntawm kev xa cov kab mus rau Google Spreadsheets. Dua li ntawm qhov tseeb tias cov algorithm rau kev ua cov txheej txheem rau hauv lub web thiab daim ntawv thov mobile yog ho txawv, koj tsis tuaj yeem hu nws nyuaj. Qhov tseem ceeb tshaj plaws yog kom nco ntsoov qhov chaw ntawm cov kev xaiv tsim nyog thiab cov khoom noj khoom haus. Los ntawm txoj kev, tib txoj kev koj yuav txhim kho txhua kab - cia li xaiv qhov khoom coj los siv hauv cov ntawv qhia zaub mov tab "Saib" (yav dhau los - "Saib") ntawm lub desktop lossis qhib cov zaub mov ntawm cov lus txib ntawm lub smartphone los yog ntsiav tshuaj.
