Txawm hais tias pab pawg cov ntaub ntawv hauv Microsoft Excel tuaj yeem yog txoj hauv kev muaj txiaj ntsig los khaws cov qauv sib xws, tshem tawm cov pab pawg nws yuav yog qhov xav tau yog tias koj xav hloov pauv cov ntawv tshwj xeeb. Txhawm rau tshem tawm cov ntawv txheeb, nyem rau ntawm ib qho ntawm nplooj ntawv thiab xaiv "Ungroup" lossis nias ⇧ Shift thaum nyem ib qho ntawm cov ntawv txheeb. Ib yam nkaus, kev sib cais kab lossis kab yog ua tiav los ntawm kev xaiv cov ntaub ntawv xav tau ntau thiab xaiv "Ungroup" los ntawm "Cov Ntaub Ntawv" tab (lossis siv Windows/Mac keyboard shortcuts). Tsis txhob hnov qab txuag koj txoj haujlwm ua ntej hloov pauv rau koj pab pawg!
Cov kauj ruam
Txoj Kev 1 ntawm 3: Rho Tawm Cov Ntawv Teev Npe
Kauj Ruam 1. Txheeb xyuas cov ntawv uas tau muab ua pawg
Cov tab rau cov ntawv sib koom ua ke yuav hais txog qhov ntxoov ntxoo lossis xim zoo ib yam thiab cov ntawv ntawm lub tab ntawm cov ntawv nquag nyob hauv pab pawg yuav ua siab tawv.
Kauj Ruam 2. Txoj cai-nias ib qho ntawm cov pawg ntawv tab thiab xaiv "Ungroup Sheets" los ntawm cov ntawv qhia zaub mov
Cov ntawv yuav tsis koom nrog pawg thiab koj tuaj yeem hloov pauv yam tsis cuam tshuam rau txhua nplooj ntawv.
Kauj Ruam 3. Hloov ua lwm yam, Nias ⇧ Shift thaum nyem rau ntawm daim ntawv nquag nyob hauv pab pawg tam sim no
Kauj Ruam 4. Rov sau cov ntawv ua haujlwm tom qab hloov pauv (xaiv tau)
Nias thiab tuav Ctrl (Windows) lossis ⌘ Cmd (Mac) thiab sab laug nyem rau ntawm kab ntawv ua haujlwm tab uas koj xav tau ua pawg. Cov ntawv yuav raug faib ua pawg thaum tso tus yuam sij.
Txoj Kev 2 ntawm 3: Pab Pawg Tsis Siv Neeg Cov Ntaub Ntawv
Kauj Ruam 1. Txiav txim siab yog tias koj cov ntaub ntawv tau muab tso ua pawg lossis ua ke
Yog tias koj cov ntaub ntawv tau muab ua pawg nrog "Pab Pawg" khawm nws tau ua tiav ntawm tus kheej. Qee zaum cov pab pawg tau tsim los ntawm kev ua haujlwm, zoo li Subtotal, uas tuaj yeem txheeb xyuas los ntawm kab lus "Subtitle" hauv qab cov ntaub ntawv pawg.
Kauj Ruam 2. Nyem rau “+” khawm kom nthuav pab pawg (yog tias zais)
Lub pob no tau muab tso rau sab laug ntawm daim ntawv nthuav qhia. Yog tias pab pawg tau nthuav dav, "-" tau qhia dua. Kev nthuav dav yuav nthuav tawm ib pab pawg lossis kab uas tau muab zais.
Kauj Ruam 3. Nyem thiab rub kom pom tag nrho cov kab lossis kab hauv pawg
Kauj Ruam 4. Nyem rau "Cov Ntaub Ntawv" tab
Qhov no nyob hauv kab ntawv qhia zaub mov saum toj kawg nkaus thiab yuav nthuav tawm cov txheej txheem tshwj xeeb ntawm kev tswj hwm.
Kauj Ruam 5. Nyem “Ungroup”
Lub pob no nyob ntawm sab xis ntawm lub cuab yeej hauv ntu "Tus Qauv" thiab yuav ua rau pawg tsis raug xaiv.
Koj kuj tseem tuaj yeem siv cov keyboard luv kom tshem tawm pawg xaiv lossis kab. Xaiv pawg pawg thiab nias Alt+⇧ Shift+← (Windows) lossis ⌘ Command+⇧ Shift+J (Mac)
Txoj Kev 3 ntawm 3: Sib Koom Tsis Siv Neeg Cov Ntaub Ntawv Pawg
Kauj Ruam 1. Txiav txim siab yog tias koj cov ntaub ntawv tau muab tso ua pawg lossis ua ke
Yog tias koj cov ntaub ntawv tau muab ua pawg nrog "Pab Pawg" khawm ces nws tau ua tiav ntawm tus kheej. Qee zaum cov pab pawg tau tsim los ntawm kev ua haujlwm, zoo li Subtotal, uas tuaj yeem txheeb xyuas los ntawm kab lus "Subtitle" hauv qab cov ntaub ntawv pawg.
Kauj ruam 2. Nyem rau "Data" tab
Qhov no nyob hauv kab ntawv qhia zaub mov sab saum toj thiab yuav nthuav tawm cov txheej txheem tshwj xeeb ntawm kev tswj hwm.
Kauj Ruam 3. Nyem rau "Subtotal" khawm
Lub pob no nyob ntawm sab xis ntawm cov cuab yeej cov ntaub ntawv hauv ntu "Tus Qauv" thiab yuav nthuav tawm lub thawv sib tham.
Kauj Ruam 4. Nyem rau "Tshem Tawm Txhua" khawm
Lub pob no yog nyob rau sab laug sab laug ntawm lub npov kab lus thiab yuav tshem tawm tag nrho cov ntaub ntawv thiab tshem tawm qhov sib cais.
