Yuav Ua Li Cas Txo Excel Cov Ntaub Ntawv Loj (nrog Duab)

Cov txheej txheem:

Yuav Ua Li Cas Txo Excel Cov Ntaub Ntawv Loj (nrog Duab)
Yuav Ua Li Cas Txo Excel Cov Ntaub Ntawv Loj (nrog Duab)

Video: Yuav Ua Li Cas Txo Excel Cov Ntaub Ntawv Loj (nrog Duab)

Video: Yuav Ua Li Cas Txo Excel Cov Ntaub Ntawv Loj (nrog Duab)
Video: 1 tsug 13 hnub _part#2_phees lauj fullmusic MV 2022-2023 2024, Tej zaum
Anonim

Qhov wikiHow no qhia koj yuav ua li cas txo qhov chaw Microsoft Microsoft cov ntaub ntawv siv los ntawm kev tshem qee qhov kev ua haujlwm, muab cov duab tso tseg, thiab khaws cov ntaub ntawv ua kom zoo dua qub.

Kauj ruam

Ntu 1 ntawm 6: Txuag Cov Ntawv Los Ua Cov Ntaub Ntawv Binary

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 1
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 1

Kauj Ruam 1. Qhib Microsoft Excel cov ntaub ntawv

Ob npaug nias lub cim ntsuab thiab dawb app icon nrog tsab ntawv " X", nyem menu" Cov ntaub ntawv "thiab" Qhib …, thiab xaiv cov ntaub ntawv xav tau.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 2
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 2

Kauj Ruam 2. Nyem Cov Ntaub Ntawv

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 3
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 3

Kauj Ruam 3. Nyem Txuag Raws Li…

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 4
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 4

Kauj Ruam 4. Ntaus lub npe ntawv

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 5
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 5

Kauj Ruam 5. Nyem rau "File Format:" drop-down box

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 6
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 6

Kauj Ruam 6. Nyem rau Excel Binary Workbook ntawm ntu "Cov Qauv Tshwj Xeeb".

Cov ntaub ntawv khaws tseg hauv hom ntawv no me me me me piv rau cov ntaub ntawv.xls li qub.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 7
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 7

Kauj Ruam 7. Nyem Txuag

Cov ntaub ntawv Excel me me yuav raug cawm hauv lub computer.

Ntu 2 ntawm 6: Tshem Tawm Cov Qauv los ntawm Kab Tsis Raug thiab Kab

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 8
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 8

Kauj Ruam 1. Qhib Microsoft Excel cov ntaub ntawv xav tau

Ob npaug nias lub cim ntsuab thiab dawb app icon nrog tsab ntawv " X", nyem menu" Cov ntaub ntawv "thiab" Qhib …, thiab xaiv cov ntaub ntawv xav tau.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 9
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 9

Kauj Ruam 2. Xaiv tag nrho cov kab uas seem

Nyem rau thawj kab ntawv kab ntawv, tom qab ntawd nias thiab tuav tus yuam sij ua ke Ctrl+⇧ Shift+↓ (Windows) lossis+⇧ Shift+↓ (Mac).

Cov xub tuav feem ntau nyob rau hauv kaum sab xis-sab xis ntawm cov keyboard

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 10
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 10

Kauj Ruam 3. Nyem rau Tsev tab lossis (Windows) lossis Kho kom raug ntawm cov ntawv qhia zaub mov bar (Mac).

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 11
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 11

Kauj Ruam 4. Nyem Clear

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 12
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 12

Kauj Ruam 5. Nyem Clear All (Windows) lub Hom ntawv (Mac).

Nrog rau qhov kev xaiv no, cov ntawv tsis tsim nyog yuav raug tshem tawm ntawm cov cell uas tsis siv.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 13
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 13

Kauj Ruam 6. Xaiv tag nrho cov kab uas seem

Nyem tsab ntawv ntawm thawj kab ntawv khoob, tom qab ntawd nyem thiab tuav qhov tseem ceeb ua ke Ctrl+⇧ Shift+→ (Windows) lossis+⇧ Shift+→ (Mac).

Cov xub tuav feem ntau nyob rau hauv kaum sab xis-sab xis ntawm cov keyboard

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 14
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 14

Kauj Ruam 7. Nyem rau Tsev tab (Windows) lub Kho kom raug ntawm cov ntawv qhia zaub mov bar (Mac).

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 15
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 15

Kauj Ruam 8. Nyem Clear

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 16
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 16

Kauj Ruam 9. Nyem Clear All (Windows) lub Hom ntawv (Mac).

Nrog rau qhov kev xaiv no, cov ntawv tsis tsim nyog yuav raug tshem tawm ntawm cov cell uas tsis siv.

Ntu 3 ntawm 6: Tshem Tawm Txoj Cai Raws Cai

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 17
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 17

Kauj Ruam 1. Qhib Microsoft Excel cov ntaub ntawv xav tau

Ob npaug nias lub cim ntsuab thiab dawb app icon nrog tsab ntawv " X", nyem menu" Cov ntaub ntawv "thiab" Qhib …, thiab xaiv cov ntaub ntawv xav tau.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 18
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 18

Kauj Ruam 2. Nyem rau Home tab nyob rau sab saum toj ntawm lub vijtsam

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 19
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 19

Kauj Ruam 3. Nyem Txoj Cai Hloov Kho

Nws nyob hauv ntu "Cov Qauv" ntawm cov ntawv xaiv.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 20
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 20

Kauj Ruam 4. Nyem Ntsuas Cov Cai

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 21
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 21

Kauj Ruam 5. Nyem Ntsuas Cov Cai los ntawm Daim Ntawv Teev Npe

Ntu 4 ntawm 6: Tshem Tawm Hom Ntawv Los Ntawm Cov Tsis Muaj Cells (Windows)

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 22
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 22

Kauj Ruam 1. Qhib Microsoft Excel cov ntaub ntawv xav tau

Ob npaug nias lub cim ntsuab thiab dawb app icon nrog tsab ntawv " X", nyem menu" Cov ntaub ntawv "thiab" Qhib …, thiab xaiv cov ntaub ntawv xav tau.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 23
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 23

Kauj Ruam 2. Nyem rau Home tab nyob rau sab saum toj ntawm lub vijtsam

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 24
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 24

Kauj Ruam 3. Nyem Nrhiav & Xaiv

Qhov kev xaiv no nyob hauv ntu "Kho kom raug" ntawm cov kab ntawv xaiv.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 25
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 25

Kauj Ruam 4. Nyem Mus Rau…

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 26
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 26

Kauj Ruam 5. Nyem Tshwj Xeeb…

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 27
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 27

Kauj Ruam 6. Nyem rau Blanks xov tooj cua khawm

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 28
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 28

Kauj Ruam 7. Nyem OK

Tam sim no, txhua lub cell tsis muaj dab tsi hauv cov ntaub ntawv teeb tsa yuav raug cim.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 29
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 29

Kauj Ruam 8. Nyem Clear

Qhov kev xaiv no yog qhia los ntawm lub cim lwv.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 30
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 30

Kauj Ruam 9. Nyem Clear All

Ntu 5 ntawm 6: Tshem Tawm Hom Ntawv Los Ntawm Cov Tsis Paub Cells (Mac)

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 31
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 31

Kauj Ruam 1. Qhib Microsoft Excel cov ntaub ntawv xav tau

Ob npaug nias lub cim ntsuab thiab dawb app icon nrog tsab ntawv " X", nyem menu" Cov ntaub ntawv "thiab" Qhib …, thiab xaiv cov ntaub ntawv xav tau.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 32
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 32

Kauj ruam 2. Nyem Kho kom raug

Qhov kev xaiv no nyob hauv cov ntawv qhia zaub mov nyob rau sab saud ntawm qhov screen.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 33
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 33

Kauj Ruam 3. Nyem Nrhiav

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 34
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 34

Kauj Ruam 4. Nyem Mus Rau…

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 35
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 35

Kauj Ruam 5. Nyem Tshwj Xeeb…

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 36
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 36

Kauj Ruam 6. Nyem rau Blanks xov tooj cua khawm

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 37
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 37

Kauj Ruam 7. Nyem OK

Tam sim no, txhua lub cell tsis muaj dab tsi hauv cov ntaub ntawv teeb tsa yuav raug cim.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 38
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 38

Kauj Ruam 8. Nyem Kho kom raug ntawm cov ntawv qhia zaub mov

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 39
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 39

Kauj ruam 9. Nyem Clear

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 40
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 40

Kauj ruam 10. Nyem Format

Ntu 6 ntawm 6: Cov Duab Nyiam

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 41
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 41

Kauj Ruam 1. Qhib Microsoft Excel cov ntaub ntawv xav tau

Ob npaug nias lub cim ntsuab thiab dawb app icon nrog tsab ntawv " X", nyem menu" Cov ntaub ntawv "thiab" Qhib …, thiab xaiv cov ntaub ntawv xav tau.

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 42
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 42

Kauj Ruam 2. Qhib "Compression" lub npov lus

Kom tso saib nws:

  • Ntawm lub khoos phis tawj Windows, nyem rau daim duab, tom qab ntawd nyem rau " Hom ntawv "Thiab nyem qhov kev xaiv" Nyem "Ntawm toolbar.
  • Hauv Mac computer, nyem rau " Cov ntaub ntawv "thiab xaiv" Txo Cov Ntawv Loj … ”.
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 43
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 43

Kauj Ruam 3. Nyem rau cov ntawv qhia zaub mov uas nyob ib sab ntawm "Duab Zoo" xaiv

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 44
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 44

Kauj Ruam 4. Xaiv qhov me me daws teeb meem duab

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 45
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 45

Kauj Ruam 5. Kos rau lub npov "Rho tawm thaj tsam ntawm cov duab"

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 46
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 46

Kauj Ruam 6. Nyem Txhua daim duab hauv daim ntawv no

Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 47
Txo Qhov Loj ntawm Excel Cov Ntaub Ntawv Kauj Ruam 47

Kauj Ruam 7. Nyem OK

Cov duab tso tawm hauv cov ntawv yuav raug muab yaug thiab cov duab tsis zoo yuav raug muab tshem tawm.

Pom zoo: