Li Cas Rov Muab Ib Daim Ntawv Foos hauv Excel

01 ntawm 02

Npe Rename Daim Ntawv Foos hauv Excel

Renaming thiab Recoloring Worksheet tabs

Ob txoj kev hloov uas ua rau nws yooj yim dua los npaj thiab qhia cov ntawv khom nqi thiab cov ntaub ntawv uas lawv muaj yog los hloov cov ntawv khom nqi thiab hloov cov xim ntawm daim ntawv tab tab uas muaj lub npe nyob hauv qab ntawm qhov chaw ua haujlwm.

Hloov Piv Txwv Daim Ntawv Sau Npe (Excel Worksheet)

Muaj ntau txoj kev los hloov dua tshiab ntawm daim ntawv ua haujlwm hauv Excel, tab sis tag nrho ob qho tib si siv cov ntawv tab hauv qab ntawm Excel los sis cov kev xaiv nyob hauv Tsev Tsev ntawm cov ntawv sau .

Qhov Xaiv 1 - Siv Keyboard Kub Daws:

Lus Cim : Qhov tseem ceeb hauv qab tsis tas yuav tsum tuav cia thaum tuav lwm tus yawm sij, xws li nrog ib co keyboard shortcuts. Txhua qhov tseem ceeb yog nias thiab tso tawm rau hauv succession.

Dab tsi yog qhov txheej txheem ntawm cov keystrokes yog qhib cov kev cai ribbon. Thaum kawg qhov tseem ceeb hauv qhov sib lawv liag - qhov R - yog nias thiab tso tawm, lub npe tam sim no rau ntawm daim ntawv tab ntawm daim ntawv tam sim no los yog muaj nuj nqi .

1. Nias thiab tso tawm rau hauv kev sib lawv liag nram qab no kom pom lub npe ntawm cov ntawv xov xwm;

Alt + H + O + R

2. Sau lub npe tshiab rau daim ntawv sau;

3. Nias Tus Ntaus Nkag mus rau ntawm cov keyboard los ua dua daim ntawv sau dua.

Hloov Cov Ntawv Cuam Tshuam Keyboard Shortcut

Ib qho piv txwv keyboard shortcut yog hloov ntawm cov ntawv ua haujlwm - txij li cov ntawv xa tawm yog lub npe uas yuav tau hloov dua tshiab uas siv cov kev sib txuas ua ke saum toj no. Siv cov lus nug nram qab no kom paub tseeb tias cov lus qhia ua haujlwm tau txais:

Ctrl + PgDn - txav mus rau ntawm daim ntawv Ctrl + PgUp - txav mus rau ntawm daim ntawv rau sab laug

Daim Ntawv Xaiv Cov Kev Xaiv

Ib daim ntawv khom nqi yuav muab rhais tau los ntawm txhaj rau daim ntawv tab nrog ob qho kev xaiv tom ntej.

Kev Xaiv 2 - Ob Ntxiv Nias Cov Ntawv Tab:

1. Ob npaug nias ntawm lub npe tam sim no hauv daim ntawv tab tab kom pom lub npe tam sim no hauv tab;
2. Sau lub npe tshiab rau daim ntawv sau qhia;
3. Nias tus yuam sij nkag rau ntawm cov keyboard los ua kom tiav cov npe sau;
4. Lub npe tshiab yuav tsum pom ntawm daim ntawv tab.

Kev Xaiv 3 - Txoj Cai Nias Ntawv Tab:

1. Txoj cai nias ntawm lub tab ntawm daim ntawv khij nyiab koj xav rho tawm los qhib lub ntsiab lus teb;
2. Nias ntawm Rename nyob rau hauv daim ntawv teev cov npe khoom los ua kom pom cov npe ntawv tam sim no;
3. Ua raws li cov kauj ruam 2 txog 4 saum toj no.

Kev Xaiv 4 - Nkag Mus Rau Qhov Ribbon Kev Xaiv nrog Tus Nas:

1. Nias rau ntawm daim ntawv ntawm cov ntawv ua haujlwm yuav tsum tau muab kho dua los ua nws daim ntawv
2. Nias rau ntawm lub tsev tab ntawm txoj hlua
3. Nias rau ntawm txoj kev xaiv rau ntawm daim qauv sau rau hauv cov ntawv sau cia
4. Hauv phau ntawv txhim kho khoom seem hauv daim ntawv qhia zaub mov, nyem rau ntawm Daim Ntawv Npe Kho Npe kom highlighting daim ntawv nyob rau sab hauv qab ntawm qhov screen
5. Sau lub npe tshiab rau daim ntawv khomob
6. Nias tus nkag mus rau ntawm tus keyboard los ua kom tiav cov npe sau ntawv

Saib tag nrho Cov Ntawv Tabs hauv phau Workbook

Yog tias ib phau ntawv muaj ntau cov ntawv khom nqi los yog cov kab rov tav dua tau muab ncua lawm, tsis yog txhua daim ntawv tab tab txawm pom ntawm ib zaug - tshwj xeeb tshaj yog vim thaum cov ntawv npe tau ntev, yog li ua cov tabs.

Yog xav kho qhov teeb meem no,

1. Muab tus pointer poias hla tus ntsug ellipsis (peb feem ntsug dots) ntawm kab rov tav scroll bar;
2. Tus pointer mouse yuav hloov mus rau ob sab xub ntiag - raws li muaj nyob hauv daim duab saum toj no thaum nws yog qhov tseeb;
3. Nias thiab tuav lub pob nyem khawm thiab cab tus pointer mus rau sab xis kom ntug qhov chaw rau daim ntawv tab tab yuav tsum tau tso tawm kom pom - los yog sab laug mus rau sab loj dua.

Excel Daim Ntawv Xaj Npe Kev Txwv

Muaj qee qhov kev txwv qis thaum nws tuaj yeem rov xa cov ntawv ua haujlwm rau Excel:

• Lub npe tsis muaj peev xwm tshaj 31 cim nyob ntev
• Daim ntawv khij lub npe tsis tuaj yeem tso dawb paug
• Cov cim nram qab no tuaj yeem siv tsis tau rau hauv lub npe: \ /? : * [

Siv Cov Ntawv Sau Npe Cov Ntawv Ua Hauv Cov Qauv Tshaj Xo (Excel Formulas)

Renaming ib daim ntawv qhia tsis tsuas yog yooj yim ua kom yooj yim kom taug qab cov ntawv txheeb ntawm ib phau ntawv loj, tab sis nws muaj cov txiaj ntsig zoo dua ntxiv uas ua rau nws nkag siab yooj yim kom nkag siab cov qauv uas siv ntau daim ntawv khom nqi.

Thaum lub mis muaj cov ntawv siv ntawm cov ntawv ua haujlwm sib txawv ntawm daim ntawv ua haujlwm npe muaj nyob hauv tus qauv.

Yog hais tias siv lub npe ua haujlwm npe ntawv - xws li Ntawv Sheet2, Sheet3 - qhov formula yuav pom tej yam zoo li no:

= Sheet3! C7 + Sheet4! C10

Muab cov ntawv khom nqi piav qhia lub npe - xws li Tej Nyiaj Siv Rau Ib Hlis thiab Lub Rau Hli Ntuj - yuav ua rau lub mis yooj yim dua. Piv txwv li:

= 'Cov Nqi Them Nqi Zog!' C7 + 'June Expenses'! C10

02 ntawm 02

Hloov Cov Ntawv Xim Xim

Hloov Cov Ntawv Xim Cov Lus Cuam Tshuam

Yuav pab koj nrhiav tau cov ntaub ntawv hauv cov ntaub ntawv loj spreadsheet, nws yog qhov tseem ceeb heev rau txoj cai xim tabs ntawm cov ntawv khomob uas muaj cov ntaub ntawv muaj feem xyuam.

Ib yam li ntawd, koj tuaj yeem siv cov tab xim sib txawv los sib txawv ntawm cov ntawv txheeb uas tsis muaj ntaub ntawv.

Lwm qhov kev xaiv yog los tsim ib qhov system ntawm cov xim xim uas nthuav kev ceev nrig rau qhov theem ntawm kev ua tiav rau cov haujlwm - xws li ntsuab mus tsis tu ncua, thiab xim liab kom tiav.

Hloov Tab Xim ntawm Daim Ntawv Xwb Ua Lawm

Qhov Xaiv 1 - Siv Keyboard Kub Daws:

Lus Cim : Thaum nrog cov ntawv ua haujlwm tshiab uas siv cov khoom kub , tus yuam sij tseem tsis tas yuav tsum tuav cia thaum tuav lwm tus yawm suab, xws li nrog ib co keyboard shortcuts. Txhua qhov tseem ceeb yog nias thiab tso tawm rau hauv succession.

1. Nias thiab tso tawm rau hauv cov sib lawv liag nram qab no kom ua ke qhib lub palette xim nyob rau hauv Hom Kev Xaiv Tsev rau ntawm Tsev Tsev ntawm kev sib tw:

Alt + H + O + T

2. Los ntawm lub neej ntawd, xim xwm yeem nyob rau sab laug sab laug ntawm palette - dawb hauv daim duab saum toj no - raug xaiv. Nyem nrog tus pointer nas lossis siv xub tuav ntawm cov keyboard tshem cov xim rau yam xim;

3. Yog tias siv cov xub tuav, nias tus yuam sij nkag rau hauv cov keyboard los ua kom tiav cov ntawv sau;

4. Pom ntau dua cov xim, nias M khawm ntawm cov keyboard kom qhib qhov kev cai xim palette.

Kev Xaiv 2 - Txoj Cai Nias Ntawv Tab:

1. Txoj cai nias ntawm lub tab ntawm daim ntawv ua haujlwm uas koj xav kom rov ua xim rau nws cov ntawv sau thiab qhib lub ntsiab lus teb cov ntawv qhia;
2. Xaiv Cov Xim Xim hauv cov ntawv teev lus qhib cov xim palette;
3. Nias rau ntawm xim kom nws xaiv;
4. Pom ntau dua xim, nyem rau ntawm Xaiv cov xim dua hauv qab ntawm cov xim palette qhib qhov kev cai xim palette.

Kev Xaiv 3 - Nkag Mus Rau Qhov Ribbon Kev Xaiv nrog Tus Nas:

1. Nias rau ntawm daim ntawv ntawm cov ntawv ua haujlwm yuav tsum tau muab kho dua los ua nws daim ntawv qhia;
2. Ndliv lub tsev tab ntawm txoj kab;
3. Nias rau ntawm txoj kev xaiv hom ntawm txoj hlua qhib lub tshuab raj;
4. Hauv phau ntawv txheeb cais ntawm cov ntawv qhia zaub mov, nyem rau ntawm Tab Color qhib cov xim palette;
5. Nias rau ntawm xim kom nws xaiv;
6. Pom ntau dua xim, nyem rau ntawm Xaiv cov xim dua hauv qab ntawm cov xim palette qhib qhov kev cai xim palette.

Hloov cov xim xim ntawm ntau cov ntawv khom nqi

Ceeb Toom: Tag nrho cov nplooj ntawv tab tab xaiv yuav yog tib xim.

1. Txhawm xaiv ntau tshaj li ib daim ntawv tab, tuav twj ywm Ctrl rau ntawm cov keyboard thiab nias ntawm txhua tab nrog tus pointer pointer.
   Txoj cai nyem rau ntawm ib qho ntawm cov ntawv xaiv tab tab tab qhib qhov khij tawm tshuab raj.
2. Xaiv Cov Xim Xim hauv cov ntawv teev lus qhib cov xim palette.
3. Mus saib ntau xim, nyem rau Colours Ntxiv rau hauv qab ntawm cov xim palette qhib qhov Custom Color Palette.

Ntsiab lus

1. Hloov cov xim tab rau ib daim ntawv ua haujlwm:
   • Daim ntawv ua haujlwm npe yog kos raws hauv cov xim xaiv.
2. Hloov cov xim tab rau ntau tshaj ib daim ntawv ua haujlwm:
   • Daim ntawv khom nqi (active tab sheets tab) yog qhov khij nyiab hauv cov xim xaiv.
   • Tag nrho lwm daim ntawv tabsis tso tawm xim xaiv.