3 Txoj Kev Hloov Cov Ntawv Xaj Xo Cov Ntawv Xim hauv Excel

Tab xim tuaj yeem pab koj koom nrog hauv cov ntawv tshaj tawm

Pab koj nrhiav tau cov ntaub ntawv hauv cov ntaub ntawv loj spreadsheet, nws yog ib qho tseem ceeb rau xim xim cov ntawv tab tab ntawm daim ntawv khomob uas muaj cov ntaub ntawv qhia txog. 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.

Cov no yog peb qho kev hloov ntawm daim ntawv tab xim ntawm ib daim ntawv ua haujlwm hauv ib phau ntawv sau ua haujlwm:

• Siv cov keyboard daws.
• Txoj cai-txhaj rau daim ntawv tab (tej zaum qhov yooj yim txoj kev).
• Siv hom ntawv tabs xaiv rau ntawm txoj kab.

Hloov Cov Ntawv Cuam Cov Tab Xeeb Siv cov Keyboard Keys lossis Mouse

Qhov Xaiv 1 - Siv Keyboard Kub Daws:

Lus Cim : Qhov tseem ceeb hauv qab hauv qab no 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 - T - yog nias thiab tso tawm, xim palette rau kev hloov cov ntawv xim tab qhib.

1. Nias ntawm daim ntawv tab tab kom ua rau daim ntawv xov xwm - los yog siv cov nram qab no cov shortcuts los xaiv qhov cov ntawv ua haujlwm uas xav tau:

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

2. Nias thiab tso tawm rau hauv cov kab ke nram qab no kom qhib qhov xim palette nyob rau hauv Hom Kev Xaiv Tsev ntawm tsev ntawm txoj kab xov :

Alt + H + O + T

3. Los ntawm kev ua neej, xim xwm txheej ntawm cov xim tab tam sim no tseem ceeb (ncig los ntawm ib lub txiv kab ntxwv). Yog tias qhov xim xim tsis tau hloov yav dhau los ces yuav dawb. Nyem nrog tus pointer nas lossis siv xub tuav ntawm cov keyboard tshem cov xim rau yam xim hauv palette;

4. Yog tias siv cov xub tuav, nias lub khawm Enter rau ntawm cov keyboard kom ua tiav cov xim;

5. 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 qhov tab ntawm daim ntawv ua hauj lwm uas koj xav kom rov qab xim kom nws ua daim ntawv xov xwm thiab qhib lub ntsiab lus teb;

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 cov xim, nyem rau Colours Ntxiv rau 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 hauj lwm kom tau muab hloov dua tshiab los ua nws daim ntawv qhia;

2. Nias lub tsev tab ntawm txoj kab;

3. Ntaus qhov Hom Kev Xaiv rau ntawm txoj hlua qhib lub tshuab raj;

4. Hauv seem Cheeb Tsam ntawm daim ntawv qhia zaub mov, nyem rau ntawm Xim Xim kom qhib qhov xim palette;

5. Nias ntawm xim kom nws xaiv;

6. Pom ntau ntau 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

Hloov cov ntawv xim tab rau ntau daim ntawv khom nqi yuav tsum tau xaiv cov ntawv ua haujlwm tag nrho ua ntej yuav siv ib qho ntawm cov qauv qhia saum toj no.

Cov nplooj ntawv xaiv tau sib txuas tau - sib txuas rau ib leeg, xws li cov ntawv txheeb ib, ob, peb - ​​los yog ib tus neeg xaiv, xws li cov nplooj ntawv plaub thiab rau.

Tag nrho cov ntawv xaiv tab tab yuav yog xim tib yam.

Xaiv cov kab ntawv sib txuas

1. Nias rau ntawm daim ntawv ntawm daim ntawv ua haujlwm nyob rau sab laug kawg ntawm pawg uas tau hloov mus ua nws daim ntawv qhia.

2. Tuav tus yuam sij ua haujlwm hauv tus keyboard.

3. Nias rau ntawm daim ntawv ntawm daim ntawv ua haujlwm ntawm sab kawg ntawm pab pawg - txhua daim ntawv ua haujlwm ntawm cov nplooj ntawv pib thiab xaus yuav tsum raug xaiv.

4. Yog tias muaj ntau cov nplooj ntawv raug xaiv los ntawm qhov yuam kev, nyem rau ntawm daim ntawv kawg - nrog rau qhov ua haujlwm tseem ceeb tseem pressed - los xaiv cov ntawv khom nqi tsis txaus siab.

5. Siv ib qho ntawm cov hau kev saum toj saud los hloov cov xim tab rau tag nrho cov xaiv xaiv.

Xaiv cov ntawv khom nqi

1. Nias rau ntawm daim ntawv ntawm thawj daim ntawv ua haujlwm kom nws ua tus ntawv sau;

2. Tuav lub Ctrl key rau ntawm cov keyboard thiab nias ntawm tabs ntawm tag nrho cov ntawv ua haujlwm los hloov - lawv tsis tas yuav tsim ib pawg sib txuas - raws li pom muaj nplooj ntawv plaub thiab rau hauv daim duab saum toj no;

3. Yog tias daim ntawv xaiv tau los ntawm qhov ua yuam kev, nyem rau ntawm nws dua zaum ob - nrog tus Ctrl tseem ceeb - tseem yuav xaiv nws;

4. Siv ib qho ntawm cov hau kev saum toj saud los hloov cov xim tab rau tag nrho cov xaiv xaiv.

Tab xim cov cai

Thaum ntawv tab xim hloov, cov cai hauv Excel ua raws hauv displaying cov tab xim:

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 sau ua haujlwm tab (s) yog hauv qab ntawm cov xim xaiv.
   • Tag nrho lwm daim ntawv tab tab muab tso tawm xim xaiv.