Shandisa Excel Clipboard kuKopa Multiple Items Multiple Times

01 ye 01

Dzvora, Kopota uye Nyora Data muExcel neHhodhi Clipboard

System Clipboard vs. Office Clipboard

The system clipboard chikamu chekushandisa kombiyuta, yakadai seMicrosoft Windows kana Mac O / S, uko munhu angakwanisa kuchengeta demo kwenguva.

Mune zvimwe zvinyorwa zvemagetsi, bhidhiyobhodhi ndeyekuchengetedza kwechinguva chiduku kana dampu yedata mumakombiyuta e RAM iyo inochengetedza dambudziko rekushandisa zvakare.

Bhodhibhodhi inogona kushandiswa mukati me Excel kusvika kune:

• dare rinowanzoshandiswa dhiyabhorosi rekushandisa zvakare muhwendefa rimwechete kana bhuku rebhuku;
• famba kana kukopa dhenda kune rimwe bhuku rebhuku kana kuti purogiramu yakasiyana zvachose.

Mhando dze data iyo clipboard inogona kubata inosanganisira:

• text strings
• nhamba yedata - yakarongwa
• graphical images
• mafomu
• kodepi yemakombiyuta inoshandiswa mu macros

The Office Clipboard muExcel uye mamwe mapurogiramu muMicrosoft Office inowedzera zvigadziro zvebasa rekugadzira.

Kunyange zvazvo Windows Clipboard inobata chete chinhu chakapedzisira chikopiwa, Officeboardboard inogona kuchengetedza kusvika ku 24 zvakapinda zvakasiyana uye inopa huwandu hwekushandura muhutano uye nhamba yezvinyorwa zvepachikodhi zvinogona kuderedzwa munzvimbo pane imwe nguva.

Kana zvinhu zvinopfuura makumi maviri zvakapinda muHhodhi Clipboard, zvinyorwa zvekutanga zvakabviswa kubva pakubhadhadhi rekuona.

Kushanda kweHhodhi Clipboard

The Office Clipboard inogona kushandiswa ne

1. Kushandura pa Clipboard dialog box launcher - inoratidzwa mumufananidzo uri pamusoro - iyo ichazarura Office Clipboard task pane - iri paImba yebhu yebhoni mu Excel.
2. Kushandisa zvigetsi zve Ctrl + C + C pane keyboard - kuchinyorera tsamba C kana kutumira dhidhiyo kuComputer Clipboard, ichikufambisa kaviri paHofadhi Clipboard - izvi zvinogona kana kuti hazvingasviki Office Clipboard task pane, zvichienderana nezvimwe zvakasarudzwa zvisarudzo (ona pasi apa).

Kuona mukati meHhodhi Clipboardboard

Zvinhu zviripo ikozvino muHofadhi Clipboard uye kurongeka kwavakakopiwa zvinogona kuonekwa vachishandisa Office Clipboard basa pane.

Basa rekushandisa rinogona kushandiswawo kusarudza zvinhu zvipi uye mune zvakarongeka zvinhu zviri mubasa rekugadzirisa zvinogona kuiswa munzvimbo itsva.

Kuwedzera Dhidhiyo kune Clipboard

Dhiyabhorosi yakawedzerwa kune Clipboard uchishandisa kopi kana kukoka (kutama) mirairo uye yakashandurwa kana kunyoreswa munzvimbo itsva nechisarudzo.

Muchiitiko cheSystem Clipboard, kopi imwe neimwe itsva kana basa rakachekwa rinosvitsa data iripo kubva pa clipboard uye inoiisa iyo ne data itsva.

Hofisi Clipboard, kune rumwe rutivi, ine zvinyorwa zvepakutanga pamwe chete nezvitsva uye zvinobvumira kuti zvipinde munzvimbo itsva mune chero mararamiro aunosarudza kana kuti zvinyorwa zvose zviri mubhodhibhodhi kuti zvipwe munguva imwechete.

Clearing the Clipboard

1) Nzira yakanyatsojeka yekubvisa bhodhibhodhi yehofisi ndeyokutsvaga paBlic All Clear iri pahofisi ye Clipboardboard task pane. Apo Office Office Clipboard ichabviswa, chirongwa cheBhodi yeChechi chinotswawo zvakare.

2) Kubuda kwezvirongwa zvose zveMicrosoft Office zvinokonzera kupfigira Office Clipboard, asi asiya muClipboardboard inoshanda.

Zvisinei, sezvo system Clipboard inongova imwe chete inopinda panguva imwe chete, iyo chete yekupedzisira yakakopihwa muHofadhi Clipboard inochengetwa kamwe kana mapurogiramu eHofisi akavharwa.

3) Sezvo Chikwangwani chiri chenguva yekuchengetedza zvishoma, kubvisa urongwa hwekushanda - kana nokuvhara kana kutangazve kombiyuta - ichasara zvose system uye Office Clipboard ye data yakachengetwa.

Office Clipboard Options

Pane zvakawanda zvingasarudzwa zvekushandisa Office Office. Izvi zvinogona kugadziriswa uchishandisa Bhokisi reKutora riri pasi peHofter Clipboard task pane.

• Ratidza Office Clipboard Automatically : Inonyatsoratidza Office Clipboard paunenge uchinyora zvinhu.
• Ratidza Office Clipboard Kana CTRL + C Yakamanikidzwa kaviri: Inonyatsoratidza Office Clipboard paunenge uchidhinda CTRL + C kaviri.
• Chengetedza Pasina Kuisa Office Clipboard: Inobatsira, uye makopi zvinhu kune Office Officeboard, asi pasina kuvhura Office Clipboard task pane.
• Ratidza Office Clipboard Icon pane Taskbar: Inoratidzira Office Clipboardboard icon munzvimbo yemaitiro kana tray yebharakiti apo Office Office Clipboard inoshanda. Iyi sarudzo inoshandiswa nekutadza.
• Ratidza Mamiriro Pedyo neTabkbar Paunenge Uchinyora: Unoratidza mharidzo yemashoko yakagadzirwa paunenge uchinyorera zvinhu paHofadhi Clipboard. Iyi sarudzo inoshandiswa nekutadza.

Kunyora Dhinda reDhina kuChepboardboard

Kana iwe uine rutsva rwemashoko, rakadai sezita remazita raunenge uchitopinda muitiro imwechete kuenda mune pepa rekushandura, kushandisa clipboard kunogona kuita nyore kupinda mazita.

1. Ratidzai zvose zvakanyorwa mubasa rekushanda;
2. Dhinda maki eCtrl + C + C pane keyboard. Nyaya yacho ichagadzirirwa seimwe chinyorwa muHofadhi Clipboard.

Wedzera Dhipatimendi kune Pepa Rokushanda Kubva muBhodi YemaBhodi

1. Dzvanya pachitokisi mune pepa rekushanda apo iwe unoda kuti data iwanikwe;
2. Dzvanya pamutambo unoda uri mu clipboard muoneti kuti uwedzere iyo kushandiswa seki ;
3. Munyaya yedheteti yedhesi kana urongwa, paunenge wapinda mubasa rekushanda, ichachengetedza kusarudzwa uye kurongeka kwerwendo rwekutanga;
4. Kana uchida kuwedzera zvose zvinyorwa mubasa rekushanda, chengetedza Bhinda Chese Bhatani pamusoro pekuona bhodhibhodhi. Excel inonyanya kuvhara imwe neimwe muchitokisi chakasiyana mumutsetse kutanga ne-active cell.