Yuav Ua Li Cas Hloov Excel rau Lo Lus: 15 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav Ua Li Cas Hloov Excel rau Lo Lus: 15 Kauj Ruam (nrog Duab)
Yuav Ua Li Cas Hloov Excel rau Lo Lus: 15 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Hloov Excel rau Lo Lus: 15 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Hloov Excel rau Lo Lus: 15 Kauj Ruam (nrog Duab)
Video: Yuav ua li cas thiaj khiav dim lub ntiajteb no 2024, Kaum ib hlis
Anonim

Koj puas xav hloov daim ntawv Excel rau hauv Microsoft Word ntawv? Excel tsis muaj cov ntaub ntawv-rau-Lo lus hloov pauv cov yam ntxwv, thiab Lo Lus tsis tuaj yeem qhib Excel cov ntaub ntawv ncaj qha. Txawm li cas los xij, Excel cov ntxhuav tuaj yeem theej thiab muab tso rau hauv Lo Lus thiab tom qab ntawd khaws ua cov ntawv Word. Nyeem phau ntawv qhia no kom paub yuav ua li cas ntxig lub rooj Excel rau hauv Lo Lus ntawv.

Kauj ruam

Txoj Kev 1 ntawm 2: Luam thiab Paste Excel Cov Ntaub Ntawv rau Lo Lus

Hloov Excel rau Lo Lus Kauj Ruam 1
Hloov Excel rau Lo Lus Kauj Ruam 1

Kauj Ruam 1. Luam cov ntaub ntawv Excel

Hauv Excel, nyem thiab rub kom xaiv cov ntsiab lus uas koj xav ntxig rau hauv Lo Lus cov ntawv, thiab tom qab ntawd nias Ctrl+C.

  • Nias Ctrl + A txhawm rau xaiv tag nrho cov ntaub ntawv hauv kab ntawv, tom qab ntawd nias Ctrl + C.
  • Koj tseem tuaj yeem nyem Kho kom raug cov ntawv qhia zaub mov, tom qab ntawd nyem Luam.
  • Yog tias koj siv Mac, nyem Command + C txhawm rau luam.
  • Ntxiv rau kev theej thiab paste Excel cov ntaub ntawv, koj tseem tuaj yeem luam thiab paste Excel kab kos rau hauv Lo Lus.
Hloov Excel rau Lo Lus Kauj Ruam 2
Hloov Excel rau Lo Lus Kauj Ruam 2

Kauj Ruam 2. Hauv Lo Lus, muab cov ntaub ntawv Excel tso

Hauv kab ntawv Word, txav tus cursor mus rau lub rooj uas koj xav tau, thiab tom qab ntawd nias Ctrl+V. Cov lus no tau muab tso rau hauv Lo Lus.

  • Koj tseem tuaj yeem nyem qhov Edit menu, tom qab ntawd nyem Paste.
  • Yog tias koj siv Mac, nias Command + V los muab tshuaj txhuam.
Hloov Excel rau Lo Lus Kauj Ruam 3
Hloov Excel rau Lo Lus Kauj Ruam 3

Kauj Ruam 3. Xaiv koj qhov kev xaiv muab tshuaj txhuam

Hauv qab txoj cai kaum ntawm lub rooj, nyem rau Paste Options khawm kom pom cov kev xaiv sib txawv.

Yog tias koj tsis pom Paste Options khawm, koj tsis pab nws. Txhawm rau pab nws, mus rau Lo Lus Xaiv, nyem Advanced. Hauv qab Txiav, Luam, thiab Muab Tshuaj txhuam, nyem rau ntawm Show Show Paste Options lub thawv txhawm rau ntxiv tus cim kos

Hloov Excel rau Lo Lus Kauj Ruam 4
Hloov Excel rau Lo Lus Kauj Ruam 4

Kauj Ruam 4. Nyem Khaws Qhov Chaw Formatting los siv Excel lub rooj style

Hloov Excel rau Lo Lus Kauj Ruam 5
Hloov Excel rau Lo Lus Kauj Ruam 5

Kauj Ruam 5. Nyem Match Destination Table Style kom siv Lo Lus cov lus style

Hloov Excel rau Lo Lus Kauj Ruam 6
Hloov Excel rau Lo Lus Kauj Ruam 6

Kauj Ruam 6. Tsim Excel cov lus sib txuas

Lo lus muaj qhov tshwj xeeb uas cia koj tsim txuas rau lwm cov ntaub ntawv hauv Chaw Haujlwm. Qhov no txhais tau tias yog koj hloov pauv rau Excel cov ntaub ntawv, cov ntawv theej kuj tseem yuav hloov kho tshiab hauv Lo Lus. Nyem Khaws Cov Ntawv Formatting thiab Txuas rau Excel lossis Match Destination Table Style thiab Txuas rau Excel los tsim Excel rooj sib txuas.

Ob txoj kev xaiv no sib raug rau cov qauv siv rau lwm qhov kev xaiv muab tshuaj txhuam

Hloov Excel rau Lo Lus 7
Hloov Excel rau Lo Lus 7

Kauj Ruam 7. Nyem Khaws Cov Ntawv Xwb Txhawm rau muab cov ntawv Excel tso rau yam tsis muaj kev sau tshwj xeeb

Yog tias koj siv qhov kev xaiv no, txhua kab yuav yog kab lus cais, nrog cov tab cais cov kab ntawv

Txoj Kev 2 ntawm 2: Ntxig Daim Duab Excel rau hauv Lo Lus

Hloov Excel rau Lo Lus Kauj Ruam 8
Hloov Excel rau Lo Lus Kauj Ruam 8

Kauj Ruam 1. Hauv Excel, nyem kab ntawv lossis kab lus kom xaiv nws, tom qab ntawd nyem Ctrl + C los theej nws.

Hloov Excel rau Lo Lus Kauj Ruam 9
Hloov Excel rau Lo Lus Kauj Ruam 9

Kauj Ruam 2. Hauv Lo Lus, nias Ctrl + V los muab tshuaj txhuam daim duab.

Hloov Excel rau Lo Lus Kauj Ruam 10
Hloov Excel rau Lo Lus Kauj Ruam 10

Kauj Ruam 3. Xaiv koj qhov kev xaiv muab tshuaj txhuam

Hauv qab txoj cai kaum ntawm lub rooj, nyem rau Paste Options khawm kom pom cov kev xaiv sib txawv.

Tsis zoo li pasting Excel cov ntaub ntawv, thaum koj muab tshuaj txhuam daim duab, muaj ob txoj kev xaiv uas koj tuaj yeem xaiv los ntawm. Koj tuaj yeem hloov cov phiaj xwm cov ntaub ntawv xaiv, nrog rau kev xaiv hom ntawv

Hloov Excel rau Lo Lus Kauj Ruam 11
Hloov Excel rau Lo Lus Kauj Ruam 11

Kauj Ruam 4. Nyem Daim Duab (txuas rau Excel cov ntaub ntawv) yog li daim duab yuav raug hloov kho thaum Excel hloov tshiab

Hloov Excel rau Lo Lus Kauj Ruam 12
Hloov Excel rau Lo Lus Kauj Ruam 12

Kauj Ruam 5. Nyem Excel Chart (tag nrho phau ntawv ua haujlwm) tso cai rau koj qhib ib daim ntawv Excel los ntawm kab ntawv nws tus kheej

Txhawm rau qhib ib daim ntawv Excel los ntawm kab ntawv, nyem rau ntawm kab ntawv, thiab tom qab ntawd nyem Kho Cov Ntaub Ntawv. Cov ntaub ntawv Excel qhov chaw yuav qhib

Hloov Excel rau Lo Lus Kauj Ruam 13
Hloov Excel rau Lo Lus Kauj Ruam 13

Kauj Ruam 6. Nyem Muab Tshuaj txhuam raws li Daim Duab los muab daim duab ua ib daim duab zoo li qub uas yuav tsis hloov tshiab thaum hloov kho Excel cov ntaub ntawv

Hloov Excel rau Lo Lus Kauj Ruam 14
Hloov Excel rau Lo Lus Kauj Ruam 14

Kauj Ruam 7. Nyem Khaws Qhov Chaw Formatting los siv Excel lub rooj style

Pom zoo: