Gwiritsani ntchito Excel Clipboard kuti Mukhombe Zinthu Zambirimbiri Multiple Times

01 ya 01

Dulani, Lembani ndi Kuyika Dongosolo mu Excel ndi Bokosi la Maofesi

Pulogalamu ya Pakanema vs. Office Clipboard

Chojambulajambulachi ndi mbali ya ma kompyuta, monga Microsoft Windows kapena Mac O / S, kumene wogwiritsa ntchito akhoza kusunga nthawi.

Mwachidziwitso chokwanira, chojambulajambula ndi malo osungirako osungirako kapena chida chadongosolo pamakina a RAM omwe amasunga deta kuti agwiritsirenso ntchito.

Chojambulajambula chingagwiritsidwe ntchito mkati mwa Excel mpaka:

• kusungirako deta yomwe imagwiritsidwa ntchito mobwerezabwereza mkati mwa tsamba limodzi kapena buku la ntchito;
• kusuntha kapena kukopera deta ku bukhu losiyana kapena pulogalamu yosiyana.

Mndandanda wa deta yomwe makanema angagwiritse ntchito ndi awa:

• zingwe zolemba
• Deta ya deta - yokonzedwa
• zithunzi zojambula
• mawonekedwe
• khodi yamakina yogwiritsidwa ntchito m'ma macros

Bokosi la Maofesi ku Excel ndi mapulogalamu enanso ku Microsoft Office amalongosola mphamvu zowonongeka.

Pamene bolodi la Mawindo la Windows likugwira kokha chinthu chotsiriza chomwe chidakopedwa, Bokosi la Maofesi likhoza kutenga zolemba makumi awiri ndi ziwiri zosiyana siyana ndipo zimapereka kusintha kwakukulu mu dongosolo ndi chiwerengero cha zolembera zojambulajambula zomwe zingathe kulowetsedwa mu malo nthawi imodzi.

Ngati zinthu zoposa 24 zalowa mu Bokosi la Maofesi, zolembedwerako zoyambirira zimachotsedwa kuwonawotchi.

Kugwiritsa ntchito bolodi lazithunzi

Ofesi ya Maofesi akhoza kukonzedwa ndi

1. Kusindikiza pa Clipboard dialog box launcher - yosonyezedwa pa chithunzi pamwambapa - chomwe chidzatsegula Office Boardboard task pane - yomwe ili pa Tsamba la Home la Ribbon ku Excel.
2. Pogwiritsa ntchito makiyi a Ctrl + C + C pamakinawo - kutsegula kalata C kamodzi kutumiza deta ku kawunilo kameneka, potsegulira kawiri kawiri pa bolodi la Office - chotsatiracho chikhoza kapena sichikutsegula Officeboardboard task pane, malinga ndi ena osankhidwa zosankha (onani m'munsimu).

Kuwona M'kati mwa Ofesi Yowonjezera

Zomwe zili panopa ku Bokosi la Maofesi ndi Zomwe adalembedwera zingawoneke pogwiritsa ntchito Office Clipboard task pane.

Malo ogwiritsira ntchito angagwiritsidwe ntchito posankha zinthu zomwe ndizomwe zinthu zomwe zili mu gawo la ntchito zingadutse m'malo atsopano.

Kuwonjezera Data ku Clipboard

Deta ikuwonjezeredwa ku Clipboard pogwiritsa ntchito malemba kapena kudula (kusuntha) malamulo ndi kusamutsidwa kapena kukopera m'malo atsopano ndi chisankho.

Pankhani ya Clipboard, kopi iliyonse yatsopano kapena ntchito yodulayo imayendetsa deta yomwe ilipo kuchokera pa bolodi lojambula zithunzi ndikuiyika ndi deta yatsopano.

Ofesi ya Maofesi, komabe, imakhala ndi zolembedwera kale ndi zatsopano ndipo zimawalola kuti zilowe m'malo atsopano muyeso iliyonse yomwe mumasankha kapena zonse zomwe zili mu bolodiloli kuti zilowetsedwe nthawi imodzi.

Kusula Clipboard

1) Njira yowonekera kwambiri yochotsera bolodi la maofesiwa ndikutsegula pa Botani Yonse Yonse yomwe ili pa Office Clipboard task pane. Pamene Bokosi la Maofesi likuchotsedweratu, ndondomeko yowonongeka imachotsedwanso.

2) Kuchokera pa mapulogalamu onse a Microsoft Office kuli ndi zotsatira zotseketsera bolodi la Maofesi a Office, koma kuchoka pa bolodi lachikhomo.

Komabe, popeza pulogalamu ya Clipboard ili ndi imodzi yokha panthawi yake, chinthu chotsatira chomwe chinakopedwa ku Bokosi la Maofesi Chimalumikizidwa pokhapokha mapulogalamu onse a Ofesi atsekedwa.

3) Popeza Clipboard ndi malo osungirako kanthawi, kuchotsa kachitidwe kachitidwe - kaya kutseka kapena kukhazikitsanso kompyutala - idzatulutsani dongosolo ndi Office Boardboard ya deta yosungidwa.

Zokambirana za Office Office

Pali njira zingapo zomwe mungapeze pogwiritsa ntchito Boardboard Clipboard. Izi zikhoza kukhazikitsidwa pogwiritsa ntchito bokosi la Zosankha zomwe zili pansi pa Officeboardboard task pane.

• Onetsani Bokosi la Maofesi Mwachindunji
• Onetsani Bokosi la Maofesi Pamene CTRL + C Inakakamizidwa Kawiri: Imaonetsa Bungwe la Pakanema la Wowonongeka pomwe mutsegula CTRL + C kawiri.
• Kusonkhanitsa Popanda Kuwonetsa Ofesi Yojambula Pakompyuta: Zimagwiritsira ntchito, ndi makope ku Office Boardboard, koma popanda kutsegula Officeboardboard task pane.
• Onetsani Chizindikiro Chakwangwani pa Office pa Taskbar: Chiwonetsero chizindikiro cha Officeboardboard pamalo omwe ali ndi udindo kapena tray ya bar taskbar pamene Office Clipboard ikugwira ntchito. Njira iyi imasinthidwa ndi chosasintha.
• Onetsani Chikhalidwe Chakufupi ndi Taskbar Mukamakopera: Kuwonetsa uthenga wachinthu chotengedwa pamene mukujambula zinthu ku Bokosi la Maofesi. Njira iyi imasinthidwa ndi chosasintha.

Kujambula Mndandanda wa Data ku Clipboard

Ngati muli ndi deta yambiri, monga mndandanda wa mayina omwe mudzawongolera mobwerezabwereza mu ndondomekoyi, kugwiritsa ntchito bokosilo likhoza kukhala losavuta kulowa mndandanda.

1. Onetsetsani mndandanda wonsewo mu worksheet;
2. Dinani makiyi a Ctrl + C + C pa kibokosilo. Mndandandawo udzakhazikitsidwa ngati umodzi kulowa mu Bokosi la Maofesi.

Onjezerani Dongosolo ku Tsamba Labwino Kuchokera ku Bokosi la Zithunzi

1. Dinani pa selo mu tsamba limene mukufuna kuti deta likhale;
2. Dinani pa chofunikirako chofunikirako muwonetsero wojambulapo kuti muwonjezere ku selo yogwira ntchito ;
3. Pankhani ya mndandanda wa deta kapena mndandanda, mukamalowa m'ndandanda, zidzasungiranso mndandanda wa mndandanda wamakono;
4. Ngati mukufuna kuwonjezera zonse zolembedwera pa tsamba, chotsani bokosi Lembani Onse pamwamba pa wojambula zithunzi. Excel idzagwiritsira ntchito selo yeniyeni muzomweyambira kuyambira ndi selo yogwira ntchito.