Yuav ua li cas txav Kab hauv Excel: 7 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav ua li cas txav Kab hauv Excel: 7 Kauj Ruam (nrog Duab)
Yuav ua li cas txav Kab hauv Excel: 7 Kauj Ruam (nrog Duab)

Video: Yuav ua li cas txav Kab hauv Excel: 7 Kauj Ruam (nrog Duab)

Video: Yuav ua li cas txav Kab hauv Excel: 7 Kauj Ruam (nrog Duab)
Video: qhia yuav computer ua 3D 2024, Plaub Hlis Ntuj
Anonim

Qhov wikiHow qhia koj li cas txav ib kab mus rau lwm qhov chaw hauv Microsoft Excel rau Windows lossis macOS.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Dragging Kab

Tsiv Kab hauv Excel Kauj Ruam 1
Tsiv Kab hauv Excel Kauj Ruam 1

Kauj Ruam 1. Nyem tsab ntawv saum kab lus uas koj xav txav mus

Qhov no xaiv kem.

Txhawm rau txav ntau dua ib kab (nyob ib sab) tib lub sijhawm, tuav Ctrl (PC) lossis ⌘ Command (Mac) thaum koj nyem rau txhua kab ntawv

Tsiv Kab hauv Excel Kauj Ruam 2
Tsiv Kab hauv Excel Kauj Ruam 2

Kauj Ruam 2. Hover nas hla ciam teb ntawm thaj chaw xaiv

Tus cursor yuav tig mus rau plaub-taw qhia xub (PC) lossis txhais tes (Mac).

Tsiv Kab hauv Excel Kauj Ruam 3
Tsiv Kab hauv Excel Kauj Ruam 3

Kauj Ruam 3. Rub kab ntawv mus rau qhov chaw xav tau

Nyem thiab rub kab ntawv xaiv (s) mus rau qhov chaw koj xav txav nws, thiab tom qab ntawd tso lub pob nyem.

Txoj Kev 2 ntawm 2: Txiav thiab Muab Tshuaj Txhuam

Tsiv Kab hauv Excel Kauj Ruam 4
Tsiv Kab hauv Excel Kauj Ruam 4

Kauj Ruam 1. Nyem tsab ntawv saum kab lus uas koj xav txav mus

Qhov no xaiv kem.

Txhawm rau txav ntau dua ib kab (nyob ib sab) tib lub sijhawm, tuav Ctrl (PC) lossis ⌘ Command (Mac) thaum koj nyem rau txhua kab ntawv

Tsiv Kab hauv Excel Kauj Ruam 5
Tsiv Kab hauv Excel Kauj Ruam 5

Kauj ruam 2. Nias Ctrl+X (PC) lub ⌘ Hais kom ua+X (Mac).

Qhov no "txiav" cov ntaub ntawv hauv kab ntawv, uas tiag tiag tsuas yog xaiv nws thiab ntxiv nws rau hauv cov ntawv teev cia.

  • Cov ntaub ntawv kab ntawv yuav nyob hauv nws qhov chaw kom txog thaum koj muab nws tso rau hauv nws qhov chaw tshiab.
  • Koj tseem tuaj yeem txiav kab ntawv los ntawm txhaj lub cim txiab ntawm lub Tsev tab. Nws nyob hauv ntu "Clipboard" ze ntawm lub ces kaum sab laug ntawm lub app.
  • Yog tias koj txiav kab ntawv tsis raug, nyem Esc kom xa cov ntaub ntawv mus rau nws qhov chaw qub.
Tsiv Kab hauv Excel Kauj Ruam 6
Tsiv Kab hauv Excel Kauj Ruam 6

Kauj Ruam 3. Right-click tsab ntawv saum kab ntawv mus rau sab xis ntawm qhov chaw koj xav txav cov ntaub ntawv

Cov ntawv qhia zaub mov nco-down yuav nthuav dav.

Thaum koj ntxig koj cov ntaub ntawv theej, nws yuav raug txav mus rau sab laug ntawm kab ntawv koj txoj cai-nyem ntawm no

Tsiv Kab hauv Excel Kauj Ruam 7
Tsiv Kab hauv Excel Kauj Ruam 7

Kauj Ruam 4. Nyem Insert Cut Cells ntawm txoj cai-nyem ntawv qhia zaub mov

Excel yuav ntxig kab txiav rau sab laug ntawm ib qho uas koj tau nyem rau.

  • Yog tias koj xav thim rov qab cov kab ntawv dhau los, nias Ctrl+Z (PC) lossis ⌘ Command+Z (Mac).
  • Xwb, koj tuaj yeem nyem lub cim nco-down nyob ib sab ntawm Ntxig khawm ntawm Tsev toolbar nyob rau sab saum toj, thiab xaiv Ntxig Txiav Cells los yog Ntxig Cells nov. Qhov no tseem yuav ntxig thiab txav koj cov ntaub ntawv ib yam nkaus.

Pom zoo: