Yuav Paub
- Set a default template place: Mus rau File > Options > Save. Nrhiav Default tus kheej template qhov chaw, ntxiv cov npe, thiab nyem Save.
- Save a workbook as a template: Mus rau File > Export > Hloov hom ntaub ntawv. Muab ob npaug rau-nias Template , tom qab ntawd lub npe thiab txuag tus qauv.
- Ntawm Mac: Tsim koj phau ntawv ua haujlwm, tom qab ntawd xaiv File > Save as Template. Sau lub template thiab khaws cia rau yav tom ntej siv.
Kab lus no piav qhia yuav ua li cas los tsim ib daim ntawv nthuav dav hauv Microsoft Excel kom txuag lub sijhawm thaum tsim cov ntaub ntawv tib yam, xws li daim ntawv teev txhua lub limtiam lossis daim ntawv qhia txog kev siv nyiaj. Cov lus qhia npog Excel 2019, 2016, 2013, 2010, thiab 2007, nrog rau Excel rau Microsoft 365 thiab Excel rau Mac.
Create Spreadsheet Templates hauv Excel
Tim qauv tsim txoj kev sib txawv me ntsis nyob ntawm koj qhov Excel version.
Excel 2013 thiab Tom qab
Yog tias koj khaws phau ntawv ua haujlwm rau thawj zaug, pib los ntawm kev teeb tsa tus kheej tus kheej qhov chaw nyob:
- Xaiv File> Options.
-
Xaiv Txuag hauv daim ntawv qhia zaub mov.
Image - Nrhiav Default tus kheej template qhov chawtxog ib nrab ntawm nplooj ntawv.
- Tau npe rau hauv phau ntawv qhia uas koj yuav khaws koj cov qauv kev cai, xws li Cov Ntaub Ntawv / Custom Office Templates.
-
Xaiv Save. Tam sim no, tag nrho cov kev cai templates koj khaws rau hauv My Templates nplaub tshev cia li tshwm nyob rau hauv Personal ntawm New nplooj (File > New ).
Tom qab koj teeb tsa tus kheej tus kheej templates qhov chaw koj tuaj yeem khaws phau ntawv ua haujlwm ua tus qauv:
- Qhib phau ntawv ua haujlwm uas koj xav khaws cia ua tus qauv thiab hloov kho koj xav tau.
- Xaiv File > Export.
- Under Export, xaiv Hloov hom ntaub ntawv.
- In the Workbook File Types box, double-click Template.
- Nyob rau hauv File name lub npov, ntaus lub npe koj xav siv rau tus qauv
-
Xaiv Save thiab tom qab ntawd kaw tus qauv. Tam sim no nws muaj rau siv txhua lub sijhawm koj xav tau.
Tau tsim phau ntawv ua haujlwm tshiab raws li koj tus qauv, Xaiv File > Tshiab > Tus Kheej, thiab tom qab ntawd xaiv tus qauv uas koj nyuam qhuav tsim.
Excel 2010 thiab Excel 2007
Qhov kev ua haujlwm rau kev tsim qauv yog txawv me ntsis nrog Excel 2010 thiab 2007.
- Qhib phau ntawv ua haujlwm uas koj xav siv ua tus qauv.
- Xaiv File> Save As.
- In the Save as type lub npov, xaiv Excel Template, lossis nyem Excel Macro-Enabled Templateyog tias phau ntawv ua haujlwm muaj macros uas koj xav kom muaj nyob rau hauv tus qauv.
-
Xaiv Save.
Tus qauv tau muab tso rau hauv Templates nplaub tshev thiab yuav muaj thaum koj xav siv nws los tsim phau ntawv ua haujlwm tshiab.
Excel rau Mac
Kho phau ntawv ua haujlwm kom txog thaum koj tau ua txhua yam kev hloov pauv uas koj xav pom hauv cov qauv, thiab xaiv File > Save as Template. Sau lub template thiab txuag nws. Cov qauv tam sim no muaj rau txhua cov ntaub ntawv tshiab.
Muaj ntau cov qauv dawb Excel muaj nyob hauv lub vev xaib, yog li koj tsis tas yuav tsim koj tus kheej.
Ntau ntawm Cov Ntsiab Lus thiab Kev Hloov Kho hauv Tus Qauv
Ib tus qauv tuaj yeem tuav ntau yam ntawm cov ntawv nyeem, xws li nplooj ntawv npe, kab thiab kab ntawv, kab ntawv kab lus, thiab lwm yam. Txuag cov ntaub ntawv, suav nrog cov ntawv nyeem thiab tus lej. Tus qauv kuj tseem tuaj yeem tsim cov duab hauv tsev, xws li cov duab, logos, thiab cov duab, nrog rau cov qauv uas yuav tsum tau rov qab siv dua hauv cov ntawv ua haujlwm tshiab.
Fonts, ntawv loj, thiab xim yog hom kev xaiv uas koj tuaj yeem khaws cia rau hauv Excel template. Ntau hom kev xaiv muaj xws li keeb kwm yav dhau los sau xim, kab dav dav, naj npawb thiab hnub hom, kev sib dhos, thiab tus naj npawb ntawm cov nplooj ntawv ua ntej hauv phau ntawv ua haujlwm.
Ntau cov yam ntxwv siab dua tuaj yeem khaws cia rau hauv tus qauv, ib yam nkaus. Qhov no suav nrog cov xov tooj xauv, cov kab zais lossis kab, lossis cov ntawv ua haujlwm uas muaj cov ntaub ntawv uas tsis yog rau kev nkag mus tau yooj yim. Macros tuaj yeem khaws cia rau hauv lub template, raws li kev cai toolbars.
