Yuav ua li cas pab pawg thiab sau cov ntaub ntawv hauv Excel: 14 Cov Kauj Ruam

Cov txheej txheem:

Yuav ua li cas pab pawg thiab sau cov ntaub ntawv hauv Excel: 14 Cov Kauj Ruam
Yuav ua li cas pab pawg thiab sau cov ntaub ntawv hauv Excel: 14 Cov Kauj Ruam

Video: Yuav ua li cas pab pawg thiab sau cov ntaub ntawv hauv Excel: 14 Cov Kauj Ruam

Video: Yuav ua li cas pab pawg thiab sau cov ntaub ntawv hauv Excel: 14 Cov Kauj Ruam
Video: Tshuaj theem vim li cas thiaj tau nqi ?/ Siv kho mob dab tsi?/paris polyphylla use for? 2024, Tej zaum
Anonim

Qhov wikiHow qhia koj yuav ua li cas pab pawg ib feem ntawm cov ntaub ntawv hauv Excel yog li koj tuaj yeem nkaum lawv hauv cov ntawv. Txoj hauv kev no muaj txiaj ntsig yog tias koj muaj cov ntaub ntawv loj nrog ntau cov ntaub ntawv. Koj tuaj yeem pab pawg thiab sau cov ntaub ntawv hauv Excel ntawm ob qho tib si Windows thiab Mac.

Kauj ruam

Ntu 1 ntawm 2: Txiav Txim Siab

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 1
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 1

Kauj Ruam 1. Qhib daim ntawv Excel

Ob npaug nias rau daim ntawv Excel kom qhib nws.

Pawg thiab Txheej Txheem Excel Cov Ntaub Ntawv Kauj Ruam 2
Pawg thiab Txheej Txheem Excel Cov Ntaub Ntawv Kauj Ruam 2

Kauj Ruam 2. Nyem rau Cov Ntaub Ntawv tab

Nws nyob rau sab laug ntawm kab ntsuab nyob rau sab saud ntawm lub qhov rai Excel. Qhov no yuav qhib lub cuab yeej hauv qab kab ntawv.

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 3
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 3

Kauj Ruam 3. Nyem hauv qab ntawm Pab Pawg khawm

Lub pob no tuaj yeem pom ntawm sab xis ntawm txoj hlua Cov ntaub ntawv. Cov ntawv qhia zaub mov nco-down yuav tshwm.

Kauj Ruam 4. Nyem Pib Qhia

Nws nyob hauv cov ntawv qhia zaub mov nco-down Pawg.

Yog tias lub npov pom zoo hais tias "Tsis tuaj yeem tsim tus qauv", koj cov ntaub ntawv tsis muaj cov qauv uas tuaj yeem sau ua ke. Koj yuav tsum sau cov ntaub ntawv manually

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 5
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 5

Kauj Ruam 5. Txo cov ntaub ntawv saib

Nyem khawm [-] nyob rau sab saud lossis sab laug ntawm daim ntawv Excel kom nkaum pawg ntawm cov ntaub ntawv. Feem ntau, cov kauj ruam no tsuas yog tso saib kab kawg ntawm cov ntaub ntawv.

Pawg thiab Txheej Txheem Excel Cov Ntaub Ntawv Kauj Ruam 6
Pawg thiab Txheej Txheem Excel Cov Ntaub Ntawv Kauj Ruam 6

Kauj Ruam 6. Tshem cov ntsiab lus yog tias tsim nyog

Nyem Ungroup mus rau sab xis ntawm kev xaiv Pawg, ces nyem Qhia meej … ntawm cov ntawv qhia zaub mov nco-down. Cov kauj ruam no tshem tawm cov pab pawg ntawm cov ntaub ntawv thiab xa rov qab cov ntsiab lus yav dhau los lossis pab pawg ua ke.

Ntu 2 ntawm 2: Kev Xam Xaj Los Ntawm Tus Kheej

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 7
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 7

Kauj Ruam 1. Xaiv cov ntaub ntawv

Nyem thiab luag tus cursor los ntawm sab laug sab laug ntawm cov ntaub ntawv koj xav kom pab pawg mus rau hauv qab txoj cai ntawm tes.

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 8
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 8

Kauj Ruam 2. Nyem Cov Ntaub Ntawv yog tias tab no tseem tsis tau qhib

Nws nyob rau sab laug ntawm kab ntsuab nyob rau sab saud ntawm lub qhov rai Excel.

Pawg thiab Txheej Txheem Excel Cov Ntaub Ntawv Kauj Ruam 9
Pawg thiab Txheej Txheem Excel Cov Ntaub Ntawv Kauj Ruam 9

Kauj Ruam 3. Nyem Pawg

Nws nyob ntawm sab xis ntawm qhov toolbar Cov ntaub ntawv.

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 10
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 10

Kauj Ruam 4. Nyem Pawg…

Qhov kev xaiv no yog nyob hauv cov ntawv qhia zaub mov nco-down Pawg.

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 11
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 11

Kauj Ruam 5. Xaiv pawg ntaub ntawv

Nyem Kab kom sau cov ntaub ntawv ntsug lossis nyem Kab los sau cov ntaub ntawv kab rov tav.

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 12
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 12

Kauj Ruam 6. Nyem OK

Nws nyob hauv qab ntawm lub qhov rais uas tshwm.

Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 13
Pawg thiab Qhia Txog Excel Cov Ntaub Ntawv Kauj Ruam 13

Kauj Ruam 7. Ntsuas cov ntaub ntawv saib

Nyem khawm [-] nyob rau sab saud lossis sab laug ntawm daim ntawv Excel kom nkaum pawg ntawm cov ntaub ntawv. Feem ntau, cov kauj ruam no tsuas yog tso saib kab kawg ntawm cov ntaub ntawv.

Pawg thiab Txheej Txheem Excel Cov Ntaub Ntawv Kauj Ruam 14
Pawg thiab Txheej Txheem Excel Cov Ntaub Ntawv Kauj Ruam 14

Kauj Ruam 8. Tshem tawm cov ntsiab lus yog tias tsim nyog

Nyem Ungroup mus rau sab xis ntawm kev xaiv Pawg, ces nyem Qhia meej … ntawm cov ntawv qhia zaub mov nco-down. Cov kauj ruam no tshem tawm cov pab pawg ntawm cov ntaub ntawv thiab xa rov qab cov ntsiab lus yav dhau los lossis pab pawg ua ke.

Lub tswv yim

Koj tsis tuaj yeem siv txoj haujlwm no rau sib koom daim ntawv nthuav qhia

Pom zoo: