Izinkinobho zokunqamulela ukusika, ukukopisha, nokunamathisela idatha ku-Excel

01 ngo-02

Kopisha futhi Namathisela Idatha ku-Excel Ngezinqamuleli Zezinqamuleli

Ukukopisha idatha ku-Excel kuvame ukusetshenziselwa ukwenza imisebenzi emibili, ifomula, amashadi kanye neminye imininingwane. Indawo entsha ingaba

• ekhasini elifanayo lokusebenzela ,
• kumafomethi okusebenza ahlukene
• ezincwadini zokusebenzela ezahlukene noma kumafayela.

Izindlela Zokukopisha Idatha

Njengasezinhlelo zonke ze-Microsoft, kunendlela engaphezu kweyodwa yokufeza umsebenzi. Imiyalo ngezansi ikhava ezintathu izindlela zokukopisha nokuhambisa idatha ku-Excel.

• usebenzisa isinqamuleli sekhibhodi,
• usebenzisa imenyu yomongo wokuchofoza ngakwesokudla;
• usebenzisa izinketho zemenyu ezisendaweni yekhaya lebhande

I-Clipboard neDatha idatha

Ukukopisha idatha akukaze kube yisinyathelo esisodwa sezinyathelo zezindlela ezibalwe ngenhla. Uma umyalo wekhophi usebenze i-duplicate yedatha ekhethiwe ifakwa ebhodini lokunamathisela , okuyinto indawo yokugcina yesikhashana.

Kusukela ebhodini lokunamathisela, idatha ekhethiwe idluliselwa esitokisini esendaweni noma amaseli. Izinyathelo ezine ezihilelekile kule nqubo yilezi :

1. Khetha idatha ezokopishwa;
2. Yenza kusebenze umyalo wekhophi;
3. Chofoza esitokisini sokuphela;
4. Yenza kusebenze umyalo wokunamathisela.

Ezinye izindlela zokukopisha idatha ezingabandakanyi ukusebenzisa ibhodi lokunamathisela zihlanganisa ukusebenzisa isibambo sokugcwalisa bese uhudula bese uphonsa ngegundane.

Kopisha Idatha ku-Excel ne-Shortcut Keys

Inhlanganisela yamakhibhodi ekhibhodi esetshenziselwa ukuhambisa idatha yilezi:

I-Ctrl + C (incwadi "C") - isebenza umyalo wekhophi Ctrl + V (incwadi "V") - isebenza umyalo wokunamathisela

Ukukopisha idatha ngokusebenzisa izinkinobho zesinqamuleli:

1. Chofoza kuseli noma amangqamuzana amaningi ukuze uwaqokomise;
2. Cindezela bese ubamba ukhiye we- Ctrl ekhibhodi;
3. Cindezela bese ukhulula i- "C" ngaphandle kokukhipha ukhiye we- Ctrl
4. Amaseli akhethiwe kufanele azungezwe umngcele omnyama ohambayo owaziwa ngokuthi izintuthwane ezihambayo ukukhombisa ukuthi idatha esele noma amaseli ibhalwa;
5. Chofoza esitokisini esendaweni - uma ukopisha amangqamuzana amaningi wedatha, chofoza kuseli elisekhoneni eliphezulu elingakwesokunxele lebanga lokufika ;
6. Cindezela bese ubamba ukhiye we- Ctrl ekhibhodi;
7. Cindezela bese ukhulula i- "V" ngaphandle kokukhipha ukhiye we- Ctrl ;
8. Idatha ephindiwe kufanele manje itholakale ezindaweni zombili zokuqala nezindawo eziya kuyo.

Qaphela: Izinkinobho zomcibisholo ekhibhodi zingasetshenziswa esikhundleni se-pointer yegundane ukuze ukhethe kokubili amaseli omthombo nendawo okuyofika lapho ukopisha futhi udlulisa idatha.

• Ukukhetha amaseli amaningi aseduze ngamakhiye omcibisholo, cindezela bese ubamba ukhiye we- Shift .
• Ukukhetha amaseli amaningi angasondelene namakhilo omcibisholo, sebenzisa ukhiye we- Ctrl .

2. Kopisha Idatha Ukusebenzisa Imenyu Yokuqukethwe

Ngenkathi izinketho ezitholakalayo kwimenyu yenkomfa - noma imenyu yokuchofoza ngakwesokudla - evamile ukushintsha kuye ngokuthi into ekhethiwe uma imenyu ivuliwe, imiyalo yokukopisha nokunamathisela ihlala ikhona.

Ukukopisha idatha usebenzisa imenyu yokuqukethwe:

1. Chofoza kuseli noma amangqamuzana amaningi ukuze uwaqokomise;
2. Chofoza ngakwesokudla kumaseli akhethiwe ukuvula imenyu yokuqukethwe;
3. Khetha ikhophi kusuka kokukhethwa kukho kwemenyu etholakalayo njengoba kuboniswe ngakwesokudla kwesithombe ngenhla;
4. Amaseli akhethiwe kufanele azungezwe izintuthwane ezihambayo ukukhombisa ukuthi idatha eselini noma amaseli ikopishwa;
5. Chofoza esitokisini esendaweni - uma ukopisha amangqamuzana amaningi wedatha, chofoza kuseli elisekhoneni eliphezulu elingakwesokunxele lebanga lokufika;
6. Chofoza ngakwesokudla kumaseli akhethiwe ukuvula imenyu yokuqukethwe;
7. Khetha ukunamathisela kusuka kokukhethwa kukho kwemenyu etholakalayo;
8. Idatha ephindiwe kufanele manje itholakale ezindaweni zombili zokuqala nezindawo eziya kuyo.

2. Kopisha Idatha Ukusebenzisa Izinketho ZeMenyu kuthebhu lasekhaya leRibhoni

Imiyalo yokukopisha nokunamathisela ifakwe kusigaba se-Clipboard noma ebhokisini ngokuvamile itholakala ngakwesokunxele kwethebhu laseKhaya lebhebhoni

Ukukopisha idatha ngokusebenzisa imiyalo ye-ribbon:

1. Chofoza kuseli noma amangqamuzana amaningi ukuze uwaqokomise;
2. Chofoza ku- Copy icon ku-ribbon;
3. Amaseli akhethiwe kufanele azungezwe izintuthwane ezihambayo ukukhombisa ukuthi idatha esele noma amaseli ikopishwa;
4. Chofoza esitokisini esendaweni - uma ukopisha amangqamuzana amaningi wedatha, chofoza kuseli elisekhoneni eliphezulu elingakwesokunxele lebanga lokufika;
5. Chofoza ku- Paste isithonjana ku-ribbon;
6. Idatha ephindiwe kufanele manje itholakale ezindaweni zombili zokuqala nezindawo eziya kuyo.

02 ka 02

Hambisa idatha ku-Excel ngezinkinobho zokunqamulela

Ukuhambisa idatha ku-Excel kuvame ukusetshenziswa ukuthutha imisebenzi, ifomula, amashadi, kanye neminye imininingwane. Indawo entsha ingaba:

• kuphepha lokusebenzela elifanayo,
• emafishini asebenzayo ahlukene
• ezincwadini zokusebenzela ezahlukene noma kumafayela.

Ayikho umyalo wokuthutha wangempela noma isithonjana ku-Excel. Igama elisetshenziswe lapho ukudluliswa kwedatha kunqunywa. Idatha inqunywe kusuka endaweni yayo yasekuqaleni bese ibanjwe ibe entsha.

I-Clipboard neDatha idatha

Idatha yokuhambisa ayisoze inqubo eyodwa. Uma umyalo wokuhambisa usucushiwe ikhophi yedatha ekhethiwe ifakwa ebhodini lokunamathisela , okuyinto indawo yokugcina yesikhashana. Kusukela ebhodini lokunamathisela, idatha ekhethiwe idluliselwa esitokisini esendaweni noma amaseli.

Izinyathelo ezine ezihilelekile kule nqubo yilezi :

1. Khetha idatha ezosuswa;
2. Qalisa umyalo wokusika;
3. Chofoza esitokisini sokuphela;
4. Yenza kusebenze umyalo wokunamathisela.

Ezinye izindlela zokuhambisa idatha ezingabandakanyi ukusebenzisa ibhodi lokunamathisela zihlanganisa ukudonsa bese uphonsa ngegundane.

Izindlela Ezihlanganisiwe

Njengazo zonke izinhlelo ze-Microsoft, kunendlela engaphezu kweyodwa yokuhambisa idatha ku-Excel. Lokhu kufaka:

• usebenzisa isinqamuleli sekhibhodi,
• usebenzisa imenyu yomongo wokuchofoza okulungile;
• usebenzisa izinketho zemenyu ezisendaweni yekhaya lebhande

Ukuhambisa Idatha ku-Excel ne-Shortcut Keys

Inhlanganisela yokhiye wekhibhodi esetshenziselwa ukukopisha idatha yilezi:

I-Ctrl + X (incwadi "X") - isebenza umyalo wokusika uCtrl + V (incwadi "V") - isebenza umyalo wokunamathisela

Ukuhambisa idatha usebenzisa izinkinobho zesinqamuleli:

1. Chofoza kuseli noma amangqamuzana amaningi ukuze uwaqokomise;
2. Cindezela bese ubamba ukhiye we- Ctrl ekhibhodi;
3. Cindezela bese ukhulula i- "X" ngaphandle kokukhipha ukhiye we- Ctrl ;
4. Amaseli akhethiwe kufanele azungezwe umngcele omnyama ohambayo owaziwa ngokuthi izintuthwane ezihambayo ukukhombisa ukuthi idatha esele noma amaseli ibhalwa;
5. Chofoza esitokisini esendaweni - uma uhambisa amangqamuzana amaningi wedatha, chofoza kuseli elisekhoneni eliphezulu elingakwesokunxele lebanga lokufika;
6. Cindezela bese ubamba ukhiye we- Ctrl ekhibhodi;
7. Cindezela bese ukhulula ukhiye we "V" ngaphandle kokukhipha ukhiye we- Ctrl ;
8. Idatha ekhethiwe kufanele manje ibe khona endaweni yokuphela kuphela.

Qaphela: Izinkinobho zomcibisholo ekhibhodi zingasetshenziswa esikhundleni se-pointer yegundane ukukhetha kokubili amangqamuzana omthombo namasendaweni lapho usika futhi udlulisa idatha.

• Ukukhetha amaseli amaningi aseduze ngamakhiye omcibisholo, cindezela bese ubamba ukhiye we- Shift .
• Ukukhetha amaseli amaningi angasondelene namakhilo omcibisholo, sebenzisa ukhiye we- Ctrl .

2. Hambisa Idatha Ukusebenzisa Imenyu Yokuqukethwe

Ngenkathi izinketho ezitholakalayo kwimenyu yenkomfa - noma imenyu yokuchofoza ngakwesokudla - evamile ukushintsha kuye ngokuthi into ekhethiwe uma imenyu ivuliwe, imiyalo yokukopisha nokunamathisela ihlala ikhona.

Ukuhambisa idatha usebenzisa imenyu yokuqukethwe:

1. Chofoza kuseli noma amangqamuzana amaningi ukuze uwaqokomise;
2. Chofoza ngakwesokudla kumaseli akhethiwe ukuvula imenyu yokuqukethwe;
3. Khetha ukusika kusuka kokukhethwa kukho kwemenyu etholakalayo;
4. Amaseli akhethiwe kufanele azungezwe izintuthwane ezihambayo ukukhombisa ukuthi idatha esele noma amaseli ishukunyiswa;
5. Chofoza esitokisini esendaweni - uma ukopisha amangqamuzana amaningi wedatha, chofoza kuseli elisekhoneni eliphezulu elingakwesokunxele lebanga lokufika;
6. Chofoza ngakwesokudla kumaseli akhethiwe ukuvula imenyu yokuqukethwe;
7. Khetha ukunamathisela kusuka kokukhethwa kukho kwemenyu etholakalayo;
8. Idatha ekhethiwe kufanele manje ibe khona endaweni yokuphela.

2. Hambisa Idatha Ukusebenzisa Izinketho ZeMenyu kuthebhu lasekhaya leRibhoni

Imiyalo yokukopisha nokunamathisela ifakwe kusigaba se-Clipboard noma ebhokisini ngokuvamile itholakala ngakwesokunxele kwethebhu laseKhaya lebhebhoni

Ukuhambisa idatha usebenzisa imiyalo ye-ribbon:

1. Chofoza kuseli noma amangqamuzana amaningi ukuze uwaqokomise;
2. Chofoza kusithonjana se- Cut kwi-ribbon;
3. Amaseli akhethiwe kufanele azungezwe yizintuthwane ezihambayo ukukhombisa ukuthi idatha esele noma amaseli ishukunyiswa;
4. Chofoza esitokisini esendaweni - uma ukopisha amangqamuzana amaningi wedatha, chofoza kuseli elisekhoneni eliphezulu elingakwesokunxele lebanga lokufika;
5. Chofoza ku- Paste isithonjana ku-ribbon;
6. Idatha ekhethiwe kufanele manje ibe khona endaweni yokuphela kuphela.