4 Txoj hauv kev los ntxig Duab rau hauv Microsoft Excel

Cov txheej txheem:

4 Txoj hauv kev los ntxig Duab rau hauv Microsoft Excel
4 Txoj hauv kev los ntxig Duab rau hauv Microsoft Excel

Video: 4 Txoj hauv kev los ntxig Duab rau hauv Microsoft Excel

Video: 4 Txoj hauv kev los ntxig Duab rau hauv Microsoft Excel
Video: Насколько важны YouTube видео для роста бизнеса | Идеи YouTube... 2024, Plaub Hlis Ntuj
Anonim

Ib yam li lwm qhov ntawm Microsoft Office, Microsoft Excel tso cai rau koj ntxig cov duab nraaj rau hauv koj daim ntawv nthuav tawm. Koj tuaj yeem ntxig ib qho ntawm cov duab kos duab uas tuaj nrog Microsoft Office, lossis koj tuaj yeem ntxig daim duab los ntawm koj lub hard drive lossis los ntawm Lub Vev Xaib. Nram qab no yog cov lus qhia yuav ua li cas ntxig duab rau hauv Microsoft Excel 2003, 2007, thiab 2010.

Cov kauj ruam

Txoj Kev 1 ntawm 4: Ntxig Clip Art

Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 1
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 1

Kauj Ruam 1. Xaiv qhov chaw uas koj xav ntxig rau daim duab kos

Koj tuaj yeem ntxig daim duab kos rau hauv txhua daim ntawv xov tooj ntawm tes lossis hauv kab ntawv taub hau lossis hauv qab.

  • Txhawm rau xaiv lub cell, nyem rau nws.
  • Txhawm rau xaiv lub header lossis footer hauv Excel 2003, xaiv "Setup Page" los ntawm File menu thiab tom qab ntawd nyem rau Header/Footer tab ntawm nplooj ntawv teeb tsa kev sib tham.
  • Txhawm rau xaiv lub header lossis footer hauv Excel 2007 lossis 2010, nyem lub pob "Header & Footer" hauv Cov Ntawv Pawg ntawm Insert menu ribbon.
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 2
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 2

Kauj Ruam 2. Nkag mus rau qhov "Insert" feature

  • Hauv Excel 2003, xaiv "Duab" los ntawm Insert menu, tom qab ntawd xaiv "Clip Art."
  • Hauv Excel 2007 thiab 2010, xaiv "Clip Art" los ntawm Pab Pawg Sib Piv ntawm Insert menu ribbon.
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 3
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 3

Kauj Ruam 3. Tshawb cov duab kos duab uas koj xav tau

Ntaus ib lo lus piav qhia lossis kab lus hauv "Tshawb nrhiav" ntawm Clip Art ua haujlwm pane lossis ib feem ntawm cov npe ntawv. Koj tuaj yeem nqaim koj qhov kev tshawb fawb nrog ib lossis ob qho ntawm cov hauv qab no:

  • Txheeb tsuas yog lub npov nyob rau ntawm xub ntiag ntawm cov khoom hauv "Tshawb hauv:" daim ntawv teev npe uas sawv cev rau cov chaw koj xav tshawb rau daim duab kos duab.
  • Kos tsuas yog lub thawv "Clip Art" hauv "Cov txiaj ntsig yuav tsum yog:" cov npe teev cia. (Lwm qhov kev xaiv muaj yog Duab, Tsos, thiab Suab.)
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 4
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 4

Kauj Ruam 4. Nyem rau lub pob "Mus"

Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 5
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 5

Kauj Ruam 5. Xaiv cov khoom kos duab hauv daim ntawv teev npe uas koj xaiv los ntxig nws rau hauv koj daim ntawv nthuav tawm

Txoj Kev 2 ntawm 4: Ntxig Daim Duab Los Ntawm Cov Ntaub Ntawv

Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 6
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 6

Kauj Ruam 1. Xaiv qhov chaw uas koj xav ntxig daim duab

Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 7
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 7

Kauj Ruam 2. Nkag mus rau Insert feature

  • Hauv Excel 2003, xaiv "Duab" los ntawm Insert menu, tom qab ntawv xaiv "Los ntawm Cov Ntaub Ntawv."
  • Hauv Excel 2007 thiab 2010, xaiv "Duab" los ntawm Pab Pawg Sib Piv ntawm Insert menu ribbon.
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 8
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 8

Kauj Ruam 3. Xauj mus rau daim duab koj xav ntxig rau hauv Insert Picture dialog

Ob npaug nias rau daim nplaub tshev qhib nws, lossis ntaus lub npe duab hauv "Cov npe cov ntaub ntawv:" teb. Koj kuj tseem tuaj yeem siv daim ntawv nco cia rau sab xis ntawm "Cov ntaub ntawv npe:" teb kom nqaim cov duab muaj rau ib hom ntawv tshwj xeeb.

Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 9
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 9

Kauj Ruam 4. Ntxig daim duab

Xwb nias lub pob "Ntxig" lossis ob npaug nyem rau ntawm daim duab.

Thaum koj ntxig ib daim duab li no, nws nce tag nrho qhov loj ntawm koj daim ntawv Excel. Koj tuaj yeem hloov qhov txuas mus rau daim duab los ntawm txhaj lub xub xub rau sab xis ntawm "Ntxig" khawm thiab nyem "Txuas rau Cov Ntaub Ntawv." Yog tias tom qab koj txav daim duab mus rau lwm qhov chaw ntawm koj lub khoos phis tawj, txawm li cas los xij, qhov txuas yuav tawg thiab koj yuav tsum rov tsim qhov txuas kom muaj daim duab rov los dua

Txoj Kev 3 ntawm 4: Ntxig Daim Duab Los Ntawm Lub Vev Xaib

Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 10
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 10

Kauj Ruam 1. Mus rau nplooj ntawv Web uas qhia cov duab koj xav ntxig

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 11
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 11

Kauj Ruam 2. Txoj nyem rau ntawm daim duab

Cov ntawv qhia zaub mov tshwm tuaj.

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 12
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 12

Kauj Ruam 3. Xaiv "Txuag Duab Raws Li" los ntawm cov ntawv qhia zaub mov

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 13
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 13

Kauj Ruam 4. Muab lub npe duab rau daim duab

Sau nws hauv "Cov ntaub ntawv npe:" teb.

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 14
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 14

Kauj Ruam 5. Nyem rau lub pob "Txuag"

Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 15
Ntxig Graphics rau hauv Microsoft Excel Kauj Ruam 15

Kauj Ruam 6. Ua raws li cov lus qhia hauv qab "Inserting a Picture From a File

"Xauj mus rau daim duab cov ntaub ntawv koj tau tsim lossis sau nws lub npe hauv" Cov ntaub ntawv npe: "teb ntawm Insert Picture dialog.

Txoj Kev 4 ntawm 4: Luam Daim Duab Los Ntawm Lub Vev Xaib

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 16
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 16

Kauj Ruam 1. Mus rau nplooj ntawv Web uas qhia cov duab uas koj xav theej

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 17
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 17

Kauj Ruam 2. Txoj nyem rau ntawm daim duab

Cov ntawv qhia zaub mov tshwm tuaj.

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 18
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 18

Kauj Ruam 3. Xaiv "Luam" los ntawm cov ntawv qhia zaub mov

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 19
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 19

Kauj Ruam 4. Right-click qhov chaw hauv koj daim ntawv teev npe uas koj xav ntxig daim duab

Lwm qhov pop-up menu tshwm.

Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 20
Ntxig Duab rau hauv Microsoft Excel Kauj Ruam 20

Kauj Ruam 5. Xaiv "Paste" los ntawm cov ntawv qhia zaub mov

Koj daim duab tshwm ntawm qhov chaw koj xaiv.

Yog tias koj xaiv daim duab uas tau txuas rau lwm nplooj ntawv Web page, koj yuav pom qhov txuas mus rau nplooj ntawv ntawd nyob ntawm qhov duab uas koj xav tau. Yog tias qhov no tshwm sim, rov qab mus rau Lub Vev Xaib uas muaj cov duab uas koj xav tau thiab ua raws cov lus qhia hauv qab "Inserting a Picture From a Web Page."

Lub tswv yim

  • Yog tias koj npaj yuav ntxig koj cov duab rau hauv kab ntawv hauv taub hau lossis hauv qab, khaws daim ntawv theej ntawm cov duab nraaj kom koj tuaj yeem rov qab mus rau nws yog tias koj txiav txim siab hloov cov duab thiab pom qhov kev hloov pauv tsis zoo li koj xav tias lawv yuav.
  • Ib txwm khaws koj daim ntawv Excel daim ntawv ua ntej koj hloov daim duab lossis ua ntej ua qauv lossis txiav cov duab nraaj.
  • Excel 2003 tso cai rau koj ntxig cov duab los ntawm koj lub scanner lossis lub koob yees duab ncaj qha rau koj daim ntawv nthuav tawm. Qhov kev ua haujlwm no tau raug tshem tawm ntawm Excel 2007 thiab 2010 nrog kev hloov pauv rau cov ntawv qhia zaub mov sib txuas. Yog tias koj tab tom npaj hloov kho los ntawm Excel 2003 rau ib qho ntawm cov hloov tshiab lossis yog tias koj xav tias koj xav siv daim duab lossis duab hauv ntau dua ib daim ntawv nthuav tawm, koj yuav tsum khaws cov duab digital rau hauv koj lub khoos phis tawj thiab tom qab ntawd ntxig lawv ua cov duab.

Lus ceeb toom

  • Spreadsheet headers thiab footers tuaj yeem pom nrog seem ntawm daim ntawv teev npe hauv Excel 2003 thiab cov ntawv ua ntej tsuas yog siv lub tshuab Luam Ntawv Ua Ntej.
  • Paub txog cov cai siv rau ib qho duab duab uas koj npaj yuav muab tso rau hauv koj daim ntawv Excel ua ntej koj siv lawv, yog tias koj npaj yuav faib koj daim ntawv nthuav tawm sab nraum koj lub chaw haujlwm. Cov duab hauv Microsoft Office Clip Art thiab Media Library tuaj yeem siv rau lwm lub hom phiaj tsis yog muag cov duab lawv tus kheej; tib yam muaj tseeb rau feem ntau cov duab thaij duab thaum koj yuav nws. Yog koj muaj kev ua xyem xyav txog koj txoj cai rau ib daim duab, hu rau tus tswv daim duab kom tau kev tso cai.

Pom zoo: