Yuav Ua Li Cas Tsim Tus Qauv hauv Excel ntawm PC lossis Mac (nrog Duab)

Cov txheej txheem:

Yuav Ua Li Cas Tsim Tus Qauv hauv Excel ntawm PC lossis Mac (nrog Duab)
Yuav Ua Li Cas Tsim Tus Qauv hauv Excel ntawm PC lossis Mac (nrog Duab)

Video: Yuav Ua Li Cas Tsim Tus Qauv hauv Excel ntawm PC lossis Mac (nrog Duab)

Video: Yuav Ua Li Cas Tsim Tus Qauv hauv Excel ntawm PC lossis Mac (nrog Duab)
Video: yuav coj li cas kom luag nyiam 2024, Tej zaum
Anonim

Qhov wikiHow no qhia koj li cas kom txuag tau phau ntawv Excel ua tus qauv siv, siv lub khoos phis tawj. Txoj kev no, koj tuaj yeem ntshuam thiab siv koj cov qauv kev cai los tsim thiab dhia pib lwm daim ntawv.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Siv Excel 2010 lossis 2015

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 1
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 1

Kauj Ruam 1. Qhib phau ntawv Excel uas koj xav khaws tseg ua tus qauv

Nrhiav phau ntawv ua haujlwm uas koj xav tig los ua tus qauv ntawm koj lub khoos phis tawj, thiab ob npaug nias rau nws lub cim kom qhib daim ntawv nthuav tawm.

Xwb, koj tuaj yeem qhib phau ntawv ua haujlwm dawb, thiab tsim koj tus qauv los ntawm kos

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 2
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 2

Kauj ruam 2. Nyem rau File tab

Lub pob no yog nyob rau sab saud sab laug ntawm koj lub vijtsam. Nws yuav qhib koj cov ntawv xaiv ntawm cov ntawv qhia zaub mov.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 3
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 3

Kauj Ruam 3. Nyem Txuag Raws Li ntawm Cov Ntawv qhia zaub mov

Qhov kev xaiv no yuav tso cai rau koj khaws cov ntawv no hauv lwm hom ntawv tshaj li tus qauv Excel Workbook (.xlsx).

Hauv Mac, koj tuaj yeem nyem rau ntawm Txuag Ua Tus Qauv xaiv ntawm File menu.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 4
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 4

Kauj Ruam 4. Nyem rau cov ntawv qhia zaub mov uas nyob ib sab ntawm "Txuag raws li hom

Qhov no yuav qhib ib daim ntawv teev npe ntawm txhua hom ntawv uas koj tuaj yeem khaws koj cov ntawv ua.

Ntawm Mac, qhov kev xaiv no tuaj yeem sau ua "Cov Qauv Ntawv."

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 5
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 5

Kauj Ruam 5. Xaiv Excel Template (*.xltx) ntawm daim ntawv teev npe

Qhov no yuav txuag koj phau ntawv ua haujlwm ua tus qauv, thiab tso cai rau koj ntshuam nws tom qab mus rau lwm phau ntawv teev npe ua haujlwm.

Yog tias koj phau ntawv muaj macros, xaiv Excel Macro-Enabled Template (*.xltm) nov.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 6
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 6

Kauj Ruam 6. Xaiv qhov chaw txuag

Nyem rau daim nplaub tshev uas koj xav khaws koj tus qauv.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 7
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 7

Kauj Ruam 7. Nyem khawm Txuag

Qhov no yuav tig koj phau ntawv ua haujlwm ua tus qauv, thiab khaws nws mus rau qhov chaw xaiv.

Txoj Kev 2 ntawm 2: Siv Excel 2013 lossis 2016

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 8
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 8

Kauj Ruam 1. Qhib phau ntawv Excel uas koj xav hloov mus ua tus qauv

Nrhiav phau ntawv ua haujlwm uas koj xav khaws tseg ua tus qauv hauv koj lub computer, thiab ob npaug nias rau nws lub cim kom qhib daim ntawv nthuav tawm.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 9
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 9

Kauj ruam 2. Nyem rau File tab

Lub pob no yog nyob rau sab saud sab laug ntawm koj lub vijtsam. Nws yuav qhib koj cov ntawv xaiv ntawm cov ntawv qhia zaub mov.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 10
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 10

Kauj Ruam 3. Nyem Xaiv ntawm Cov Ntawv qhia zaub mov

Qhov no yuav qhib koj cov kev xaiv Excel hauv lub qhov rai pop-up tshiab.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 11
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 11

Kauj Ruam 4. Nyem rau Save tab ntawm sab laug vaj huam sib luag navigation

Qhov kev xaiv no tau teev tseg ntawm Ntawv pov thawj thiab Lus ntawm sab laug sab tes ntawm Excel Options window.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 12
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 12

Kauj Ruam 5. Teeb tsa qhov chaw txuag cia rau cov qauv

Koj tus qauv yuav raug khaws cia rau qhov chaw no tom qab.

  • Txav mus rau ntu "Txuag phau ntawv ua haujlwm".
  • Nyem rau kab ntawv kab ntawv tom ntej ntawm "Default personal templates location."
  • Nkag mus rau kab ntawv kab ntawv ntawm daim nplaub tshev uas koj xav khaws koj cov ntawv.
  • Nyem rau OK khawm kom txuag nws.
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 13
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 13

Kauj Ruam 6. Nyem Cov Ntaub Ntawv tab nyob rau sab saud

Nws yuav qhib koj cov ntawv qhia zaub mov.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 14
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 14

Kauj Ruam 7. Nyem Export rau ntawm File menu

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 15
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 15

Kauj Ruam 8. Nyem qhov Hloov Cov Ntaub Ntawv Hom

Qhov no yuav tso cai rau koj khaws koj phau ntawv ua haujlwm hauv lwm hom ntawv.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 16
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 16

Kauj Ruam 9. Ob-nias tus Qauv hauv Phau Ntawv Teev Npe Cov Hom

Txoj kev no, koj cov ntaub ntawv yuav raug khaws tseg ua tus qauv, thiab tuaj yeem siv hauv phau ntawv sib txawv tom qab.

Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 17
Tsim Tus Qauv hauv Excel ntawm PC lossis Mac Kauj Ruam 17

Kauj ruam 10. Nyem khawm Txuag

Qhov no yuav txuag koj tus qauv rau koj qhov chaw tus kheej tus qauv tam sim no.

Pom zoo: