Ungawakopisha kanjani ama-worksheet amaningi ku-Excel eyodwa

I-Microsoft Excel

I-Excel, ngokuzimela kwayo, i- Isicelo esihle kakhulu sokwenza amaspredishithi, kusuka kokulula njengokugcina umnotho wekhaya, kumashidi anedatha engafuneki, ebhekisa kwamanye amafayela kanye / noma amakhasi wewebhu, imininingwane ehlaziywa ngokuqhubekayo evumela ukuqhutshwa kwedatha okuqhubekayo nolwazi oluvuselelwe kuwo wonke umzuzu.

Ifayela ngalinye le-Excel lakhiwe ngamashidi nawo wonke amashidi akha ifayela le-Excel abizwa ngeBhuku. Lokhu kuyasivumela dala amashidi ahlukene kufayela / encwadini efanayo ukuba nabo bonke endaweni eyodwa. Ishidi ngalinye lingathola idatha ngokuzimela yize isakhiwo sinye.

Lokho wukuthi, singaba namashidi amaningana ncamashi ekwakhiweni kepha ngalinye lisikhombisa idatha ehlukile noma lithole ngokuzenzakalela idatha evela kweminye imithombo. Kepha ngalokhu, into yokuqala okufanele siyenze kopisha izikhathi eziningana ishidi elifanayo kufayela / encwadini efanayo.

kopisha amashidi amaningi we-excel

Ukukopisha amaspredishithi amaningi encwadini efanayo, ukugcina ukwakheka nokwakheka, sinezinketho ezimbili:

Indlela ye-1

  • Beka igundane ngaphezu kweshidi esifuna ukulikopisha bese ucindezela inkinobho yesokudla yegundane.
  • Bese ukhetha Hambisa noma kopisha.
  • Ebhokisini elilandelayo, sihlola ibhokisi Dala ikhophi bese sikhetha isikhundla esizoba naso eshidini, inketho yokudlulela ekugcineni kube inketho enconyiwe, ukuze ishidi elisha libekwe njengephepha lokugcina lencwadi.

Indlela ye-2

Enye inketho esheshayo bese uqhafaza eshidini lencwadi esifuna ukulikopisha futhi cindezela inkinobho Yokulawula ngenkathi uhambisa igundane maqondana nendawo lapho sifuna ukwenza khona ikhophi leshidi okukhulunywa ngalo.


Okuqukethwe yi-athikili kunamathela ezimisweni zethu ze izimiso zokuhlelela. Ukubika iphutha chofoza lapha.

Yiba ngowokuqala ukuphawula

Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele imininingwane: Miguel Ángel Gatón
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.