Koj tuaj yeem ntxiv cov tab, lossis cov ntawv ua haujlwm, hauv Excel cais cov ntaub ntawv thiab ua kom nws nkag tau yooj yim dua. Los ntawm lub neej ntawd, Excel muab ib daim ntawv ua haujlwm (peb yog tias koj siv Excel 2007), tab sis koj tuaj yeem tsim cov ntawv ntxiv raws li koj xav tau.
Kauj ruam
Txoj Kev 1 ntawm 3: Ntxiv Ib Daim Ntawv Ua Haujlwm
Kauj Ruam 1. Pib Excel ntawm Start menu (Windows) lossis Applications folder (Mac), tom qab ntawd qhib phau ntawv ua haujlwm uas koj xav kom ntxig rau hauv daim ntawv ua haujlwm
Thaum koj qhib Excel, koj yuav raug nug kom xaiv cov ntawv.
Kauj Ruam 2. Nyem rau "+" khawm ntawm qhov kawg ntawm daim ntawv ua haujlwm txhawm rau ntxiv daim ntawv ua haujlwm dawb rau sab xis ntawm daim ntawv ua haujlwm uas twb muaj lawm
- Koj tseem tuaj yeem nias ua haujlwm+F11 txhawm rau ntxiv ib daim ntawv ua ntej ntawm daim ntawv xaiv. Piv txwv li, yog tias koj xaiv Sheet1 thiab nias Shift+F11, Sheet2 yuav raug muab tso ua ntej ntawm Sheet1.
- Txhawm rau tsim lub tab tshiab hauv Mac version ntawm Excel, nias Command+T.
Kauj Ruam 3. Luam daim ntawv ua haujlwm los ntawm kev xaiv ib daim ntawv tshwj xeeb, nias Ctrl/Xaiv, thiab kos daim ntawv ua haujlwm.
Excel yuav ua daim ntawv theej ntawm daim ntawv thiab cov ntaub ntawv hauv nws.
Yog tias koj xav luam ntau daim ntawv ua haujlwm ib zaug, nias thiab tuav Ctrl/⌥ Opt thaum nyem rau ntawm daim ntawv koj xav tau
Kauj Ruam 4. Nyem ob lub tab kom hloov nws
Thaum cov ntawv raug xaiv, koj tuaj yeem sau npe rau daim ntawv ua haujlwm txhua lub npe.
Kauj Ruam 5. Txoj cai-nias ib qho ntawm cov tab, tom qab ntawd xaiv "Tab Xim" los hloov xim
Koj tuaj yeem xaiv los ntawm ntau yam xim tsis raug, lossis nyem "Ntau Xim" los tsim koj tus kheej.
Kauj Ruam 6. Hloov tus naj npawb ntawm phau ntawv ua haujlwm tsis raug rau phau ntawv ua haujlwm tshiab
Koj tuaj yeem hloov kho Excel teeb tsa kom suav nrog ntau lossis tsawg daim ntawv ua haujlwm thaum koj tsim phau ntawv ua haujlwm tshiab.
- Nyem rau File tab lossis Office button, tom qab ntawv xaiv "Options".
- Ntawm "General" lossis "Nrov" tab, nrhiav ntu "Thaum tsim phau ntawv ua haujlwm tshiab".
- Hloov tus nqi hauv qhov "suav nrog ntau nplooj ntawv" xaiv.
Kauj Ruam 7. Nyem thiab luag cov tabs sab laug lossis sab xis kom rov teeb tsa cov tabs
Thaum koj muaj ob peb tabs, koj tuaj yeem nyem thiab rub lawv. Luag tab sab laug lossis sab xis kom txav nws mus rau txoj haujlwm tshiab. Txoj haujlwm hloov pauv no yuav tsis cuam tshuam rau cov qauv lossis cov ntaub ntawv hais txog.
Txoj Kev 2 ntawm 3: Ntxiv Ntau Daim Ntawv Qhia
Kauj Ruam 1. Tuav Shift, tom qab ntawd xaiv tus naj npawb ntawm cov ntawv uas koj xav ntxiv
Piv txwv li, yog tias koj xav ntxiv peb daim ntawv ua haujlwm ib zaug, tuav Shift thaum xaiv peb daim ntawv ua haujlwm. Hauv lwm lo lus, koj yuav tsum muaj peb daim ntawv ua ntej koj tuaj yeem tsim peb daim ntawv los ntawm cov kauj ruam no.
Kauj Ruam 2. Nyem rau "Insert" khawm hauv Tsev tab
Koj yuav pom ib qho ntxiv "Ntxig" qhov kev xaiv. Nco ntsoov tias koj nyem "▼" xub kom qhib cov ntawv qhia ntxiv.
Kauj Ruam 3. Xaiv "Insert Sheet
" Excel yuav ntxiv daim ntawv ua haujlwm dawb paug raws li tus lej ntawm daim ntawv uas koj tau xaiv. Daim ntawv ua haujlwm yuav raug ntxiv rau sab laug ntawm thawj daim ntawv uas koj xaiv.
Txoj Kev 3 ntawm 3: Ntxig Daim Ntawv Teev Npe
Kauj Ruam 1. Tsim lossis rub tawm tus qauv koj xav siv
Koj tuaj yeem tig txhua phau ntawv ua haujlwm rau hauv tus qauv los ntawm kev txuag nws hauv "Excel Template (*.xltx)" hom ntawv. Cov ntaub ntawv tus qauv yuav raug cawm hauv Templates nplaub tshev. Xwb, koj tseem tuaj yeem rub tawm ntau yam qauv los ntawm Microsoft thaum tsim cov ntawv tshiab.
Kauj Ruam 2. Txoj cai-nias lub tab uas koj xav ntxig tus qauv ua ntej
Tus qauv tshiab yuav raug ntxig rau ntawm lub tab uas koj xaiv.
Kauj Ruam 3. Xaiv qhov "Insert" xaiv los ntawm cov ntawv qhia zaub mov
Koj yuav pom lub qhov rai tshiab uas koj tuaj yeem xaiv cov khoom koj xav ntxig.
Kauj Ruam 4. Xaiv tus qauv koj xav tau, tom qab ntawd nyem "OK"
Cov qauv uas tau rub tawm thiab khaws tseg yuav tshwm nyob rau hauv "General" tab.
Kauj Ruam 5. Xaiv lub tab tshiab
Ib lub tab tshiab (lossis kab ntawv tab yog tias tus qauv muaj ntau dua ib daim ntawv ua haujlwm) yuav muab tso rau ntawm xub ntiag ntawm lub tab koj xaiv.
Lub tswv yim
- Koj tuaj yeem thov hloov pauv rau ntau lub tab ib zaug los ntawm pab pawg lawv. Tuav tus yuam sij Ctrl thaum nyem ib lub tab los tsim pawg tabs. Txhawm rau pab pawg ua ke ntawm cov tabs, tuav tus Shift qhov tseem ceeb, tom qab ntawv nyem rau thawj thiab kab ntawv kawg uas koj xav ua pawg. Txhawm rau tshem tawm ib pawg tab, tso Ctrl lossis Shift qhov tseem ceeb, tom qab ntawd nyem rau ib qho tab.
- Cov tab yooj yim dua los txheeb xyuas yog tias lawv tau muab cov npe tshwj xeeb, xws li lub hlis, tus lej, lossis lwm yam uas sawv cev rau cov ntsiab lus ntawm cov tab.
