Yuav Paub
- Ua ib daim ntawv nthuav dav nrog cov ntaub ntawv thiab kev tsim qauv rau tus qauv. Hauv daim nplaub tshev tshiab, nyem New > Google Sheets ua ib daim ntawv khoob.
- Nyob rau hauv daim ntawv nthuav dav, taw qhia thiab luam cov ntsiab lus koj xav siv hauv tus qauv. Muab tso rau hauv daim ntawv khoob.
- Npe thiab txuag tus qauv. Thaum koj xav siv tus qauv kev cai no, ua ib daim qauv kom koj tsis txhob hloov cov ntaub ntawv qub.
Kab lus no piav qhia yuav ua li cas los tsim koj tus kheej template hauv Google Sheets thaum ib qho ntawm Google Sheets pre-match templates yuav tsis ua haujlwm. Koj yuav xav tau Google account txhawm rau nkag mus rau Google Sheets. Nkag mus rau Google Sheets nrog tib tus lej koj siv nkag mus rau Gmail lossis YouTube.
Yam Koj Xav Tau rau Kev Cai Google Sheets Template
A Google Sheets kev cai template muaj cov ntaub ntawv tshwj xeeb rau cov ntawv koj xav ua. Txhawm rau ua tus qauv kev cai, pib nrog daim ntawv teev cov ntaub ntawv uas muaj cov ntaub ntawv thiab formatting koj xav siv hauv template.
Tsim cov ntaub ntawv spreadsheet hauv txhua qhov kev pabcuam spreadsheet, xws li LibreOffice lossis Microsoft Excel. Koj tuaj yeem ua daim ntawv nthuav dav hauv Google Sheets, tsis yog los ntawm kos lossis los ntawm Template Gallery. Tsuas yog qhib ib qho ntawm cov qauv no thiab kho nws raws li xav tau kom haum rau koj qhov project.
Ua ib lub nplaub tshev rau kev cai Templates
Txhawm rau khaws koj cov qauv kev cai tsim, tsim ib daim nplaub tshev uas yuav muaj cov ntaub ntawv template nkaus xwb.
-
Qhib Google Drive thiab mus rau hauv lub hauv paus nplaub tshev (cov ntaub ntawv saum toj kawg nkaus thiab tsis yog subfolder).
-
Xaiv New> Folder.
Image -
Nyob hauv New folder dialog box, sau ib lub npe piav qhia rau daim nplaub tshev, tom qab ntawd xaiv Create.
Image - Daim nplaub tshev tshiab tshwm hauv daim ntawv nrog rau lwm cov folders hauv Google Drive.
Ntxiv Koj Tus Qauv rau Folder
Txhawm rau ntxiv koj tus qauv kev cai rau lub nplaub tshev tsim tshiab:
- Qhib cov templates folder koj tsim.
-
Xaiv New > Google Sheets los ua ib daim ntawv khoob uas yuav siv los ua cov ntaub ntawv template.
Image Yog koj xaiv Los ntawm tus qauv, Google Sheets Template Gallery qhia. Koj tsis tuaj yeem rub tawm cov qauv lossis tsim cov qauv dawb paug los ntawm Template Gallery.
- Qhib daim ntawv nthuav qhia uas muaj cov ntaub ntawv koj xav siv hauv cov qauv thiab qhia nws cov ntsiab lus. Txhawm rau xaiv txhua yam hauv daim ntawv nthuav qhia, nias lub Ctrl+ A lossis Command+ A keyboard shortcut.
-
Xaiv Edit > Copy txhawm rau luam cov ntsiab lus tseem ceeb. Los yog, nias Ctrl+ C lossis Command+ C.
Image -
Qhib cov ntawv khoob khoob uas koj tau ua hauv Kauj Ruam 2 thiab xaiv Kho kom raug> Muab tshuaj txhuamtxhawm rau muab cov ntawv nthuav qhia. Los yog, nias Ctrl+ V lossis Command+ V.
Image Xaiv lub xovtooj ntawm qhov koj xav kom muab tso rau qhov chaw. Piv txwv li, yog tias koj tau theej txhua yam hauv daim ntawv nthuav qhia, xaiv lub xwmfab rau sab laug ntawm Athiab saum toj 1 txhawm rau txhawm rau txhawm rau tag nrho daim ntawv, tom qab ntawd muab tshuaj txhuam spreadsheet cov ntsiab lus.
-
Sau lub npe piav qhia rau tus qauv.
Image - Xaiv Google Sheets icon kom rov qab mus rau Google Sheets.
Siv koj tus qauv kev cai
Thaum koj xav siv tus qauv kev cai no los tsim ib daim ntawv nthuav dav tshiab, ua ib daim qauv ntawm cov ntaub ntawv ua ntej koj hloov pauv rau cov ntaub ntawv qub. Yog tias koj hloov kho tus qauv qub, koj yuav tsis muaj tus qauv uas tsis hloov pauv tau siv rau yav tom ntej.
Yuav ua ib daim qauv ntawm tus qauv, nyem nyem los yog kais-thiab-tuav cov ntaub ntawv template, ces xaiv Ua daim ntawv.
Tom qab ntawd, hloov lub npe luam thiab txav daim ntawv mus rau lwm lub nplaub tshev kom koj tsis txhob yuam kev hloov tus qauv.
